| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get 2 Lowest Numbers from 4 Cells?
I want to get the 2 lowest numbers from 4 cells. Is there an easy way to
code this? Thanks, in advance, for your help. G |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get 2 Lowest Numbers from 4 Cells?
Use two formulas similar to these:
=SMALL(B5:B8,1) =SMALL(B5:B8,2) Tom "G" wrote: I want to get the 2 lowest numbers from 4 cells. Is there an easy way to code this? Thanks, in advance, for your help. G |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting the two lowest numbers | Excel Discussion (Misc queries) | |||
| Sum of Lowest Cell Numbers | Excel Discussion (Misc queries) | |||
| Lowest numbers | Excel Discussion (Misc queries) | |||
| Possible to pick out the lowest eight numbers in a row? | Excel Discussion (Misc queries) | |||
| How to get the 10 lowest numbers out of 20 in Excel | Excel Programming | |||
Hybrid Mode
