Forum Discussion
Excel rank.eq
I have Excel 365 proplus installed. I am using the rank.eq function as I am trying to rank numbers with ties . See below where I use the Rank.eq function - but it does not seem to distinguish ...
paudie190 I believe that both RANK.EQ and RANK do give the correct result. Both take into account ties and gives the same rank, as it should. It seems that what you are trying to achieve with the COUNTIF correction can also be achieved by just sorting (i.e. not ranking) your data and adding a sequential number to each row. Please see the attached workbook for an example of what I mean.