Our Favorite Gifts.xlsx
This is a simplification of what I really need. But say I have 5 people, and I have 5 gifts (A-E) Each person is in order by who gets first choice, second, etc.
And each person has indicated from 1 - 5 which gift they like best.
1=most favorite 5=least favorite
I'm trying to create formulas to show who gets what. My actual spreadsheet has more people/items but is virtually the same thing.
In the attached example,the first person, Bill, gets first choice, then Mary, then Karl etc.
Bill would get Gift C.
Mary would get gift A
Karl would get Gift D because gift C and A are already taken.
The spreadsheet itself could be done differently if there's a easier/better way to get the data.
And, I am not very familiar with VBA, so hopefully there are regular formulas that will do it. Thanks!
Bookmarks