lowest number in a row that is greater than zero

[Nigel Toates]

I have a row of 19 cells that have many zeros in it but I need to find the
lowest value that is greater than "0"

The problem comes from having 19 months of sales figures and I want to find
the lowest month value we had sales in.

Thanks Nigel

 

[Browny]

I'm new at this but i think =MIN(A1:R1) in the cell where you want the result
should find the lowest value.

 

[Max]

If A1:S1 contained the month headers, and you also want (I'm not sure?) to
extract the month header which corresponds to the minimum sales value in each
row,
you could place this in say, U2, then array-enter it with CSE (press
CTRL+SHIFT+ENTER to confirm the formula) as mentioned in my first response:
=INDEX($A$1:$S$1,MATCH(MIN(IF(A2:S2>0,A2:S2)),IF(A2:S2>0,A2:S2),0))
Then copy U2 down

Note that in the event of any ties in the minimum sales value in each row,
the expression will return only the leftmost month header, ie the first
header from the left
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---

 

[T. Valko]

Assuming there are no negative numbers in the range:

=SMALL(A1:H1,COUNTIF(A1:H1,0)+1)

 

[Rick Rothstein \(MVP - VB\)]

You can use this array-entered** formula to do what you want (it will work
even if there are negative values)...

=MIN(IF(A2:A20<=0,"",A2:A20))

** Commit this formula using Ctrl+Shift+Enter and not just Enter by itself.

Adjust the ranges to match your conditions.

Rick