Using SMALL where first two values are =
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.
|