The problem is that there are some duplicate values in the estimate column.

In the example shown, Metrolux and Diamond both have the same estimate of $5000.

from a set of numeric data.

Excel formula: nth smallest value

you’re able to use INDEX to retrieve individual values, or entire rows and columns.

MATCH supports approximate and exact matching, andwildcards(* ?)

Excel formula: nth largest value

Excel formula: Sum bottom n values

Excel formula: Find lowest n values

Excel SMALL function

Excel INDEX function

Excel MATCH function

Article image