Railworks America

Posted: **Tue Mar 22, 2016 8:20 pm**

I need help in creating an Excel formula that will randomly assign one of four specific values to a cell. The four values are Box, Tank, Gondola, and Flat. This is designed to populate a Team Track in a simple Switchlist Generator utility. I've been able to customize several functions to help create realistic switching operations, but this one has me "beat."

Thank you in advance for your help.

Harry Adkins

Posted: **Wed Mar 23, 2016 2:27 pm**

Try this....

Http://www.guidingtech.com/28523/pick-r ... ame-excel/

...might help

Posted: **Thu Mar 24, 2016 9:10 am**

Thanks, I was able to solve the issue on an Excel forum.

Railworks America

Need Excel Formula to Randomly assign one of four values to a cell

Need Excel Formula to Randomly assign one of four values to a cell

Re: Need Excel Formula to Randomly assign one of four values to a cell

Re: Need Excel Formula to Randomly assign one of four values to a cell