Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking Question
I am dealing with a dataset that has a many ties in it. This is a list of
sales from 2008 to current, by customer and I need to rank on total sales. In many cases, our smaller customers will buy the same items in the same quantity month after month so it is not uncommon to have 100+ customers with the exact same total sales amount. How would I write a formula to ignore multiple ties, e.g.: Total Amount Rank 1,000,000 1 900,000 2 300,000 3 5,000 4 5,000 5 5,000 6 5,000 7 5,000 8 2,500 9 2,500 10 50 11 50 12 50 13 25 14 and so on. Thanks! PJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 part ranking question | Excel Discussion (Misc queries) | |||
Ranking Formula Question | Excel Discussion (Misc queries) | |||
Tricky Ranking Question | Excel Discussion (Misc queries) | |||
Ranking question (ties) | Excel Discussion (Misc queries) | |||
Another ranking question | Excel Worksheet Functions |