Rank problem
Yes it does it replicates what was in your first post so I ask again change
the question marks to what you want to see on your worklsheet
123 ?
134 ?
143 ?
134 ?
111 ?
Mike
"Charno" wrote:
it still returns duplicate numbers if there is matching data in column I.
"Mike H" wrote:
Ah I think I see, rank wouldn't produce the result in your example so perhaps
that's what you want to see so try this.
=SUMPRODUCT(--(I15<$I$15:$I$314),1/COUNTIF($I$15:$I$314,$I$15:$I$314&""))+1
Mike
"Mike H" wrote:
For your posted example what would you want to see as a result?
"Charno" wrote:
i have the following formula to rank a column of data
=RANK(I15,$I$15:$I$314,0) but the problem i have is that if the data is
duplicated then it returns a duplicate rank. ie..
DATA Rank
123 3
134 2
143 1
134 2
111 4
how do i get the formula to no duplicate the rank?
|