I have a list of names/indexes, along with a random number used for sorting....depending on the number of names, we'll divide them into flights. So I want to be able to sort the first X names based on the random seed (column C). Then sort the next X names based on the random seed, etc., etc. depending on the value in G2.
Example, if I have 40 names, 2 flights, I want the first 20 names sorted off the key in Col. C, then the next 20 names after that.
In this way, the flights are randomly drawn so that pairings are done randomly
Thanks for any help!
Mark
Bookmarks