finding the first numerical value in a range

[piggylumps]

Hopefully this is the last one today,

I have a range going from b4:h4, it will usually start with 0.00 (but not always) and carry on, what I want a cell to do is return the first cell in that range that has a numerical value in it.

so say the range is:

0, 0, 12676, 12679, 23803.....

I'd need to have the 12676 returned.

Any ideas?

 

[piggylumps]

think I've just done it, testing an array now of:

{=MIN(IF(B4:H4,B4:H4))}

seems to be workign so far, fingers crossed

 

[T. Valko]

Hopefully this is the last one today,

I have a range going from b4:h4, it will usually start with 0.00 (but not always) and carry on, what I want a cell to do is return the first cell in that range that has a numerical value in it.

so say the range is:

0, 0, 12676, 12679, 23803.....

I'd need to have the 12676 returned.

Any ideas?

Assuming the numbers are always positive numbers...

Try ths array formula**:

=INDEX(B4:H4,MATCH(TRUE,B4:H4>0,0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.