hi,

assumuning i have the same number and i want ro rank it.example;75,75,60,91,50,62.how can i do it please.

Not clear on what it is your trying to do,

but there is a =RANK() function you might look at.MIKE

Hi,

Ifyou are trying to Rank a range of values where some numbers are equal (75 in your example), and you do not want a tie, i.e., second equal in your example, you will have to find a way to add or subtract an extra value to the equal numbers to make them not quite equal but without changing their overall position in the rankings.I used an extra column which subtracts a small increment.

Place your numbers in cells A1 to A6

In cell B1 enter this formula:=IF(COUNTIF($A$1:$A$6,A1)>1,A1-CELL("row",A1)/100000,A1)Note the $ signs.

Drag the formula down to B6In cell C12 enter this formula:

=RANK(B1,$B$1:$B$6)Note the $ signs.

Drag the formula down to C6This is the result:

A B C 1 75 74.99999 2 2 75 74.99998 3 3 60 60 5 4 91 91 1 5 50 50 6 6 62 62 4If this works for you, you can hide the extra column, or drag it to a column out of sight.

Regards

What criteria would make one 75be ranked higher than the other75?Will it be random or will it be based on some other criteria?

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History