lowest number in row excluding empty cells

[Mark]

I am trying to return the minimum value in a range J2:AJ2 whilst ignoring
empty cells. How do I do it?

 

[FSt1]

hi,
for rows, try =min(2:2) or =mina(2:2)

regards
FSt1

 

[Mike H]

Try this array entere with trl+Shift+Enter

=MIN(IF(J2:AJ2>0,J2:AJ2))

Mike

 

[FSt1]

hi
or Min(J2:AJ2)

Regards
FSt1

hi,
for rows, try =min(2:2) or =mina(2:2)

regards
FSt1

 

[Max]

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:AJ2>0,J2:AJ2))

---

 

[RagDyeR]

Non-array alternative:

=SMALL(J2:AJ2,COUNTIF(J2:AJ2,0)+1)

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

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:AJ2>0,J2:AJ2))

---