MIN to get three lowest
 

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:
--------------------
=MIN($E$193:$AI$193)
--------------------

But how do I get the next two lowest? So I can have somewhat of a top
3 lowest numbers kind of a thing.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=508409

MIN to get three lowest
 

have a look at the SMALL function

--
Don Guillett
SalesAid Software

"DKY" wrote in message
...

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:
--------------------
=MIN($E$193:$AI$193)
--------------------

But how do I get the next two lowest? So I can have somewhat of a top
3 lowest numbers kind of a thing.


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=508409

MIN to get three lowest
 

You can use the SMALL function...

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

and

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

Hope this helps!

In article ,
DKY wrote:

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:
--------------------
=MIN($E$193:$AI$193)
--------------------

But how do I get the next two lowest? So I can have somewhat of a top
3 lowest numbers kind of a thing.