I am trying to take a list of 18 people in a column, and create a random list of 5 and 4 without repeating names within the smaller lists. I've tried with a few formulas I found online, but they don't guarantee no duplications, and when I try to F9 it to recalculate, it changes all values in the lists I've just created. Please help!!
Bookmarks