Hi!
What I want is a column with the values "red," "blue," "white," and several other colours in a random order. If I could set the frequency or approximate frequency of each, that would be even better, but not necessary.
So, is there anything like a "=RAND(red,blue,white)" code? I know next to nothing about Excel functions right now, but I have looked into this and haven't found anything like that yet.
I don't know if it's even possible, but it seems like it should be!
One method
Wow...it looks very good but I have no clue what's going on.
How would I extend that down 313 cells?
Or how would I add other colours?
Please excuse my noobness!
Here is a very simple approach. In a cell, enter:
=CHOOSE(RANDBETWEEN(1,5),"red","blue","green","white","black") and copy down
This can easily be modified for as many colors as you desire.
Gary's Student
Excellent! Exactly what I was looking for! Thanks!
Last edited by Cutter; 09-08-2012 at 07:20 AM. Reason: Removed whole post quote
And thanks to Jason, too...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks