Hi,
I am trying to rank a data set based on a specific criteria. However, when I rank the data set in a limited criteria, the ranking works, but when I want to automate this and include the entire data range, the ranking is then performed on the entire range and not on the specific criteria? The formula I am using is =IF(Q13991=100%,1,IF((UniqueReference=M13991),RANK(H13991,$H$13984:$H$18249))).
Please can you advise me how I can get round this issue, without manually changing each rank range?
Bookmarks