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.

This works
=RANK(B2,$B$2:$B$12)+COUNTIF($B$2:$B2,B2)-1

change yours to
=RANK(CE2,BoysExtraCurricular)+COUNTIF($CE$2:#CE2,CE2)-1

Regards
Peter

"BoRed79" wrote:

> 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.

Unfortunately that just brings up an error (although it doesnt tell me how to
fix the error) - so that hasnt worked.

Anyone have any other suggestions??

"Billy Liddel" wrote:

> This works
> =RANK(B2,$B$2:$B$12)+COUNTIF($B$2:$B2,B2)-1
>
> change yours to
> =RANK(CE2,BoysExtraCurricular)+COUNTIF($CE$2:#CE2,CE2)-1
>
> Regards
> Peter
>
> "BoRed79" wrote:
>
> > 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.

You do not say what the error is but maybe it is a ref error try changing the
range
RANK(CE2,BoysExtraCurricular) to the specific range BoysExtraCurricular
refers to.

To make sure that the range is there click on Name Box on the formula edit
tool bar and see if you can select BoysExtraCurricular from there.

Regards
Peter

"BoRed79" wrote:

> Unfortunately that just brings up an error (although it doesnt tell me how to
> fix the error) - so that hasnt worked.
>
> Anyone have any other suggestions??
>