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.
Thanks for your reply - sorting and row/column number would work - but my actual real model ( I just provided a very simple idea of the issue) will not allow sorting of the data
Thanks again
Padraig