ExcelBanter - How do I find the two lowest values in a range?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I find the two lowest values in a range? (https://www.excelbanter.com/excel-worksheet-functions/14147-how-do-i-find-two-lowest-values-range.html)

dlroelike

How do I find the two lowest values in a range?

Ragdyer

Ola

Try
=SMALL(A1:A10,1)
=SMALL(A1:A10,2)
and if you want the sum
=SUM(SMALL(A1:A10,{1,2}))

but if you want the 2 lowest Unique values, the formula becomes is a little
bit more complicated. Let us know if that's the case.

Ola

Myrna Larson

Look at the MIN and SMALL functions

On Sun, 20 Feb 2005 15:49:02 -0800, dlroelike
wrote:

All times are GMT +1. The time now is 06:36 PM.