Forum Discussion
Random selection of participants and Permutations with Excel
Dear all, It is the first time I will try something so complex in Excel. I hope I will be clear and use the right terms to explain it. I am organising a workshop. I have the list of candidate...
There are no doubt multiple ways this can be accomplished. See the attached workbook for one technique. The workbook requires Excel version 2021 or later (because it uses the LET function and the SEQUENCE function).
Row 2 of the RandomSubset worksheet summarizes the diversity. (I included two custom number formats to generate the words that are displayed with the counts.) Copy the last row of this sheet down to add places, or delete it to remove places.
Edit: Corrected the random selection formula, as I had added 1 (to skip past the Candidates column headers), but in the wrong place. The original formula would sometimes generate #REF errors.