duplicate rank issue
hi all, this is probably simple but I cant figure it out.
I have the following data, currently ranked by Pts. 2 rows show the same Pts value and are then ranked the same. I need to rank these by Pts and then by a further set of values to get a rank with no duplications. Data Pts GD Rank A 7 12 1 B 3 19 3 C 3 10 3 D 6 9 2 I would want B to be ranked 3 and C to be ranked 4, based on Pts then by GD. Can this be done? Help!! |
duplicate rank issue
Hello,
I suggest to use the COUNTIF + COUNTIF approach as shown under 2. at http://sulprobil.com/html/sorting.html Regards, Bernd |
duplicate rank issue
Try this:
=RANK(B1,B$1:B$4)+SUMPRODUCT(--(B1=B$1:B$4),--(C1<C$1:C$4)) Copy down as needed. -- Biff Microsoft Excel MVP "Russler" wrote in message ... hi all, this is probably simple but I cant figure it out. I have the following data, currently ranked by Pts. 2 rows show the same Pts value and are then ranked the same. I need to rank these by Pts and then by a further set of values to get a rank with no duplications. Data Pts GD Rank A 7 12 1 B 3 19 3 C 3 10 3 D 6 9 2 I would want B to be ranked 3 and C to be ranked 4, based on Pts then by GD. Can this be done? Help!! |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com