Forum Discussion
How do I create a spreadsheet that randomizes a list of names within groups?
How do I create a spreadsheet that takes a list of names, contained within groups and generates a random order of those names (still contained within their groups). For example: QA Team Name...
I'd avoid VBA and user-defined functions where you can, although admittedly my solution uses the volatile RAND() function too with a Table. If you didn't want the order to change all of the time, simply use a copy and paste special as values macro to put the numbers into my Table - hopefully, you will get the general idea.
Keep it simple!
Thanks very much! I appreciate the quick reply. I'll give this shot and see how it works out.
-Mike