# rank the same number

December 7, 2009 at 06:08:28
Specs: Linux i686
 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.

See More: rank the same number

#1
December 7, 2009 at 06:49:20
 Not clear on what it is your trying to do, but there is a =RANK() function you might look at.MIKEhttp://www.skeptic.com/

Report •

#2
December 7, 2009 at 09:11:19
 Hi,If you 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 A6In 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 4 ```If this works for you, you can hide the extra column, or drag it to a column out of sight.Regards

Report •

#3
December 7, 2009 at 09:27:01
 What criteria would make one 75 be ranked higher than the other 75?Will it be random or will it be based on some other criteria?

Report •

Related Solutions