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?

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?

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?

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?

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
---

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
---