Dear gurus,
thanks to Mynda's amazing dashboard tutorial i am now the go to excel guy in my company. I have been asked to do a secret santa worksheet... Anyone have something they have already developed please?
Hi Allyn,
I'm not aware of any Secret Santa templates, sorry. If you're looking for a formula to randomly assign people to one another then you can use the RANDARRAY functionn with SEQUENCE to generate numbers randomly sorted, if you have Office 365.
Mynda
Hi Allyn
You can have a look at the attached.
It generates a bunch of random unique numbers in column B and then does a VLOOKUP to match the numbers against columns K:L.
You can merge the formulas in columns B and C if you want to.
It will work on Excel 2010. Just press F9 to generate the random numbers.
Hope this helps.
Sunny
