I need help in creating a formula that will randomly assign one of four specific values to a cell. The four values are Box, Tank, Gondola, and Flat. Thank you in advance for your help.
Harry Adkins
I need help in creating a formula that will randomly assign one of four specific values to a cell. The four values are Box, Tank, Gondola, and Flat. Thank you in advance for your help.
Harry Adkins
Try
=CHOOSE(RANDBETWEEN(1,4),"Box","Tank","Gondola","Flat")
In, say, A1:A4 put 1, 2,3 and 4 respectively. In B1:B4 put Box, Tank, Gonola and Flat respectively.
Formula would then be: =INDEX($B$1:$B$4,MATCH(RANDBETWEEN(1,4),$A$1:$A$4,0))
Every time a recalculation is done the result of the formula will be updated.
(Or use Jonmo1's simpler formula)
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Thanks gentlemen. I really appreciate your help.
Harry
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks