C
Charno
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?
=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?