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...
You can create a sortkey column in your table, please update this with excel formula RAND(). Now sort the table by team name and sortkey. RAND() output keeps changing often with every update. you sort order will also change accordingly.
Team name Name Sortkey
| QA Team | Name 4 | 0.224421 |
| QA Team | Name 6 | 0.107234 |
| QA Team | Name 5 | 0.031831 |
| UX Team | Name 3 | 0.775804 |
| UX Team | Name 1 | 0.082853 |
| UX Team | Name 2 | 0.974162 |
Thank you. I will try this today. Please note that my Excel experience is weak at best. I can create standards spreadsheets and usually find that I'm best at taking a template and modifying it. Once I start getting into editing formulas, I am in over my head...