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

Report •


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

MIKE

http://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 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 B6

In cell C12 enter this formula:

=RANK(B1,$B$1:$B$6)
Note the $ signs.
Drag the formula down to C6

This 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


Ask Question