Hi there,

Apologies if this is straight forward but I can't seem to arrive at a solution here.

Trying to produce a rank for a column (column AA based on column Z in attached image) with unique ranks (no duplicates) and with no skipping rank numbers, currently using the below standard formula:

=RANK(Z2,$Z$2:$Z$784)+COUNTIF($Z$2:Z2,Z2)-1

*

Unsure why this is throwing up duplicates still, and what's more there seems to inconsistencies on where these duplicates land.

Cell Z22 and Z23 are equal in value, but they are ranked 21st and 23rd, and then Z24 also carries a rank of 23rd even though it is slightly less than the other two cells.

Further, Z29, Z30 AND Z31 are all equal in value but display no duplicate ranks (28th, 29th and 30th), but are then followed by 2 more equal values in Z32 and Z33 who show the duplicate rank of 32nd (skipped a rank number). The following rank is 33rd and doesn't skip so there seems to be inconsistent applications of these rank numbers.

To clarify, there are no further decimal points that are hidden that might separate these otherwise equal values shown.

Any help would be greatly appreciated.

Smok3y

Apologies if this is straight forward but I can't seem to arrive at a solution here.

Trying to produce a rank for a column (column AA based on column Z in attached image) with unique ranks (no duplicates) and with no skipping rank numbers, currently using the below standard formula:

=RANK(Z2,$Z$2:$Z$784)+COUNTIF($Z$2:Z2,Z2)-1

*

*Please note I have only ranked by column Z for demonstrative purposes in the image, to show the issues below - normally these are ranked by another factor and the Total column is not sorted in ascending order.*Unsure why this is throwing up duplicates still, and what's more there seems to inconsistencies on where these duplicates land.

Cell Z22 and Z23 are equal in value, but they are ranked 21st and 23rd, and then Z24 also carries a rank of 23rd even though it is slightly less than the other two cells.

Further, Z29, Z30 AND Z31 are all equal in value but display no duplicate ranks (28th, 29th and 30th), but are then followed by 2 more equal values in Z32 and Z33 who show the duplicate rank of 32nd (skipped a rank number). The following rank is 33rd and doesn't skip so there seems to be inconsistent applications of these rank numbers.

To clarify, there are no further decimal points that are hidden that might separate these otherwise equal values shown.

Any help would be greatly appreciated.

Smok3y