G
Guest
I am ranking some data using the following formula (which I thought prevented
duplicate ranks occuring), but I am getting duplicates in my ranking:
=RANK(CE2,BoysExtraCurricular)+COUNTIF($CE$2:CE$2,CE$2)-1
Can anyone suggest what I can change in the formula to get rid of the
duplicates.
Thanks.
duplicate ranks occuring), but I am getting duplicates in my ranking:
=RANK(CE2,BoysExtraCurricular)+COUNTIF($CE$2:CE$2,CE$2)-1
Can anyone suggest what I can change in the formula to get rid of the
duplicates.
Thanks.