Forum Discussion

Karpay750's avatar
Karpay750
Copper Contributor
Nov 23, 2023

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...
BI & Data Analysis
excel
Formulas and Functions
Karpay750's avatar
Karpay750
Copper Contributor
Nov 24, 2023
Oh wow thank you for the example created. I will try this this weekend and come back here to share my results! amazing!
SnowMan55's avatar
SnowMan55
Bronze Contributor
Nov 25, 2023

Karpay750 Eh, not so amazing.  I later noticed that my late-night coding was incorrect in deriving the counts of unique entries.  And then I found a problem in the random selection.  So see the newer attached workbook.  This version also includes more information on the _Info worksheet.

Resources