I have been asked to create a spreadsheet template for my supervisor. Basically, what he wants to be able to do is take a bunch of totals and rank them (first, second, third, etc.) In other words, if the following data appears in a row:
Joe Jane David Mike Sara Diane
100 97 63 27 75 84
...and he has a ranking chart as follows:
1.
2.
3.
etc.
... he wants the column next to each number to auto-populate with the person who ranks #1, #2, etc.
If it helps, what he is doing is taking 9 billers and entering their daily totals, summing the weekly totals at the bottom, and finding who is #1, #2, etc., for total claims billed in a week.
I have discovered the RANK function, but have discovered its limitation: I can't do what he wants to do if two people have the same total. In other words, if both Sara and Diane bill 75 claims, it won't return a person in fourth place or denote a tie for third.
Any suggestions?
2007-11-07
06:49:50
·
2 answers
·
asked by
JohnD
6