| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I find the two lowest values in a range?
|
|
#2
|
|||
|
|||
|
|
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
Look at the MIN and SMALL functions
On Sun, 20 Feb 2005 15:49:02 -0800, dlroelike wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to move Y-axis values when X range is -a to +b | Charts and Charting in Excel | |||
| Find lowest value in a range | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
| How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Linear Mode
