Hello,
Can someone point me in the right direction please; I'm sure i'm not phrasing my question correctly so struggling to find any help...
I'm trying to get a formula to return a defined number of matches in a table. For example; if you have ten people listed in column A from 1 to 10 and next to them in column B is their preferred drink (lets say wine or beer). This just happens to be split into 4 wines and 6 beers - i want to be able to use a formula to return the names of the top 3 people who want beer, if I define in another cell that only 3 beers are available.
My intention is to another formula to "mark" these chosen people and put them to the bottom of the list so next time, the people who didn't get a beer this time will get priority next time over those who did.
i keep getting results in my searches to do with index/match formulas but not sure this is exactly what i need.
any suggestions on where i should be looking?
Thanks
Bookmarks