Hi,
We have series of external events that people at our office want to attend. We are only able to send 1 person to each so our intention is to hold a small lottery to choose who gets to go. I've attached the spreadsheet where people have signed up for their events of choice. I'm trying to figure out the best way to choose one person for each event. I foresee that one person may be chosen for multiple events so it would be best if that is avoided.
I tried playing around with Rand & Index functions but didn't get the results I was hoping for. Any suggestions would be much appreciated.
max
lottery test.xlsx
Bookmarks