MIN to get three lowest

D

DKY

I'm not sure if this is possible. I have a spreadsheet with a set of
values and I figured out how to get the lowest value by the following
function:

Code:
 
D

Domenic

You can use the SMALL function...

= SMALL($E$193:$AI$193,2)

and

= SMALL($E$193:$AI$193,3)

Hope this helps!
 
Top