formula

S

stew

Hi

I need a formula that will look along a row, to the left, and give me the
first number above zero

Thank you

Stew
 
S

Stefi

Try this:
=INDEX(2:2,,MAX(--(2:2>0)*COLUMN(2:2)))
It's an array formula, confirm it with Ctrl+Shift+Enter!
Regards,
Stefi

„stew†ezt írta:
 
S

stew

Hi Stefi

I want to replace the(D1+$B$30) part of the following formula with your
INDEX(2:2,,MAX(--(2:2>0)*COLUMN(2:2))).
This being an array formula how would I incorporate it into
=IF(D$7="rehearsals",("No Show"),(IF(D$7="DAY OFF",("No
Show"),(IF(D7="BREAK",("No Show"),(IF(D7="TRAVEL",("No
Show"),(D1+$B$30))))))))

Thanks For your time

Stew
 
Top