Finally, that formula must be copied into each of the "Result" cells to see the person so ranked. I.e., copy it into cells B10, B11, etc.
Cordially,
Russ
Does not work if values are of equal ranking
jwellings wrote on September 01, 2005 18:12 EST
If two people have an identical sales value it repeats the first name twice, in positions 1 and 2.
Eg.
If sales are
Mike 1000
Donna 1000
Bill 900
Fred 800
The rankings shown are
1 Mike
2 Mike
3 Bill
ie. Donna is not shown.
This formula is almost what I need. Any ideas for a fix?
Reply: jwellings
Alan wrote on September 07, 2005 02:04 EST
Hi jwellings,
[QUOTE=jwellings]If two people have an identical sales value it repeats the first name twice, in positions 1 and 2.
Eg.
If sales are
Mike 1000
Donna 1000
Bill 900
Fred 800
The rankings shown are
1 Mike
2 Mike
3 Bill
ie. Donna is not shown.
This formula is almost what I need. Any ideas for a fix?[/QUOTE]You need to create a unique rank number like this (assume your date is in A1:B4) then enter the following in, say, C1 and copy down to C4:
=RANK(B1,B$1:B$4)+COUNTIF(B$1:B1,B1)-1
Then use that unique rank to pull out the names using INDEX or whatever you want to do.
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
Getting to Yes: Negotiating Agreement Without Giving In
