Hi guys,
I want to create a list of values that updates automatically, dependent on a changing set of numbers.
I have attached the workbook for your perusal.
In the "Register" tab, people will be able to register which things they need to do by putting their name in an adjacent column. Further across, there is a formula that totals up how many names there are in that range. (B3:J77)
Now, in the "List" tab, I want to create a list that shows which assignments are needed by the most people, sorted descending.
I have tried using INDEX, SUMIF, and all sorts of RANK formulae. But I do feel a little bit "Woods for the trees". I couldn't get this to work when it comes across duplicate values.
For instance, if 3 people need Assignment "Riding Shotgun" They should all have the same rank returned.
If anyone could help me out, I would be massively grateful.
Bookmarks