Hello, I am trying to group a list of 100 or so names in to groups of 4 randomly, with the caveat if two names have been grouped together previously they should not be grouped together again. Any ideas on how to approach this? Any code you can share or suggested formulas in excel? I am thinking I will need to write a macro, but not sure how to start. thanks! rps
Bookmarks