snhandle
asked on
Excel 2003
I would like to have formula in column C where it should show "1" for the largest amount for each ID and then 2 for the second largest amount for each ID and then 3 for the 3rd largest amount for each ID. For exameple for ID 110 it should 1 for 25 amount and 2 for 23 amount. Please look at the attach sample. thanks
Sample.xls
Sample.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you beat me, Thomas...
Dave
Dave
and I ranked backwards.
My formula should be
=SUMPRODUCT(--(B2<$B$2:$B$1000)*($A$2:$A$100 0=A2))+1
lol
Dave
My formula should be
=SUMPRODUCT(--(B2<$B$2:$B$1000)*($A$2:$A$100
lol
Dave
ASKER
Good job
=SUMPRODUCT(--(B2>$B$2:$B$
Increase the 1000 to the max your range will be
see attached:
Dave
ranking-sample-r1.xls