Finding the two (2) lowest numbers in a range of numbers

[Ron]

Is there a simple way to find the two lowest numbers in a
range of numbers?

I'm familiar with the "MIN" command, which finds the
lowest number in a range, but I was hoping there would be
an easy way to find the TWO lowest numbers.

Thanks,

Ron

 

[Dan E]

Ron,

I suppose I could be less retarded than I usually am and post

=SMALL(R:R,k)
R:R = range of data
k = kth smallest (ie 2 for second, 3 for third)

Dan E

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.misc with an email
copy to Ron.
Please use the newsgroup for further discussion.]

Dan E has already introduced you to the SMALL function. You can use it
to find both of the desired numbers by using it as an array formula.
Suppose your data are in A1:A3. Then, select two adjacent cells in a
column and array-enter =SMALL(A1:A3,{1;2})

--
An array formula is entered with CTRL-SHIFT-ENTER rather than just
ENTER. If done correctly, XL will display curly brackets { and }
around the formula
--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions