Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lowest number in row excluding empty cells
I am trying to return the minimum value in a range J2:AJ2 whilst ignoring
empty cells. How do I do it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lowest number in row excluding empty cells
hi,
for rows, try =min(2:2) or =mina(2:2) regards FSt1 "Mark" wrote: I am trying to return the minimum value in a range J2:AJ2 whilst ignoring empty cells. How do I do it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lowest number in row excluding empty cells
Try this array entere with trl+Shift+Enter
=MIN(IF(J2:AJ20,J2:AJ2)) Mike "Mark" wrote: I am trying to return the minimum value in a range J2:AJ2 whilst ignoring empty cells. How do I do it? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
lowest number in row excluding empty cells
hi
or Min(J2:AJ2) Regards FSt1 "FSt1" wrote: hi, for rows, try =min(2:2) or =mina(2:2) regards FSt1 "Mark" wrote: I am trying to return the minimum value in a range J2:AJ2 whilst ignoring empty cells. How do I do it? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
lowest number in row excluding empty cells
"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 --- |
#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 --- |
Reply |
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 |