This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Looking forward to some Santalytics! I might need to do something in Santableau too...
First time posting - Happy Christmas!
Got the answer as shown in the output, but this was assuming that everyone was giving to and receiving from the same person. Wouldn't a true secret santa have 50 random pairings?
A beginner's solution using Multi-Field Binning.
Non dynamic first attempt, with a more dynamic solution included too
I came up with several solutions that would have worked (in theory), but would have filled up my computer. Actually solved with some simple logic and a standard macro.
Love the references to Mickey's Christmas Carol in your intro!