Good morning --

I am trying to account for duplicates in using the RANK worksheet
function. Basically, I have 43 categories that I am trying to rank,
but I am only showing the Top 5 / Bottom 5. Each of these sets of
five rarely ever have duplicates, but due to the fact that the mid
section of results typically do have duplicates, I cannot properly
account for categories ranked 39, 40, 41, 42 and 43 (Bottom 5
performers).

The help documentation did not particularly help me in this
situation. Anyone out there with a solution?

Thanks,

Martin Austin