Challenge #144: Secret Santa Assignments (BAH HUMBUG!)

[sann0638]

Looking forward to some Santalytics!  I might need to do something in Santableau too...

[EmilyCR]

First time posting - Happy Christmas!

[KyleCollins]

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?

[ultrarunner]

A beginner's solution using Multi-Field Binning. 

[Hoang7]

My Solution:

Spoiler

[NickC]

Non dynamic first attempt, with a more dynamic solution included too

[JamesMA]

Festive fun!

[ggruccio]

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!