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!
Bookmarks