Secret Santa

Expiry

Well-known Member
Joined
Jun 20, 2007
Messages
865
I thought I should do a secret santa with some pals that I don't see often, but we all keep in touch on email regularly.

there are 6 of us, so I want to randomly assign 1 person to each of us to buy a gift for, which I could use =rand() for, but it should remain a secret to me, too.

I'm sure there are tons of ways to do this, but I thought some of you might fancy the opportunity to show off your creativity in coming up with an exciting method.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
I have a good method..
Fill a bucket with beer, insert waterproof presents, get everybody to close their eyes....and bob for a pressie.

Personally, I'd just bob for beer !!!
 

Forum statistics

Threads
1,222,622
Messages
6,167,126
Members
452,098
Latest member
xel003

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top