Forum Discussion
paudie190
Apr 18, 2020Copper Contributor
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
Apr 18, 2020Copper Contributor
Apologies - Read Rank.eq() functionality more thoroughly and it is not intended to do what I want - it only gives the lower ranking to a set of ties and assigns the next rank number rather than skipping a number. Rank() skips a rank number.