I using the SMALL function to rank values 1-5.
If 1 and 2 are equal (tied) how do I get both
values?
Currently I get the #1 value for 1 and 2 and then the #3
value for 3.

Thanks.

GEB,

If they are tied (and are presumably, the same), how do you tell the difference? ;-)

Presumably, you are retreiving some other information from a table based on those values.... If that
is the case, then you need to break the ties by adding a small non-zero unique amount to each number
prior to the ranking, which wouldn't change the actual value. I often add row()/1000000 to do that.

HTH,
Bernie
MS Excel MVP


"GEB" wrote in message
...
I using the SMALL function to rank values 1-5.
If 1 and 2 are equal (tied) how do I get both
values?
Currently I get the #1 value for 1 and 2 and then the #3
value for 3.

Thanks.