

November 14, 2019

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?


July 16, 2010

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

VIP

Trusted Members

June 25, 2016

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

Answers Post
1 Guest(s)
