| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
lowest number in row excluding empty cells
Non-array alternative:
=SMALL(J2:AJ2,COUNTIF(J2:AJ2,0)+1) -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Max" wrote in message ... "Mark" wrote: I am trying to return the minimum value in a range J2:AJ2 whilst ignoring empty cells. How do I do it? Perhaps you had earlier tried: =MIN(J2:AJ2) and you got zero, which is not what you want? (MIN ignores empty cells, but those "empty" cells may actually contain masked zero values) If so, you could try this, array-entered, ie press CTRL+SHIFT+ENTER to confirm the formula: =MIN(IF(J2:AJ20,J2:AJ2)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lowest number in a set EXCLUDING zero | Excel Worksheet Functions | |||
| Looking for formula for lowest costs, excluding zero | Excel Worksheet Functions | |||
| Is there a way to get an average, excluding the lowest number? | Excel Discussion (Misc queries) | |||
| How to get lowest value excluding blanks | Excel Worksheet Functions | |||
| excluding cells from the formula when empty | Excel Worksheet Functions | |||
Threaded Mode
