formula

[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

 

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

 

[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

 

[Domenic]

Try...

=IF(ISNUMBER(MATCH(D$7,{"Rehearsals","Day Off","Break","Travel"},0)),"No
Show",LOOKUP(2,1/(A2:G2>0),A2:G2))

Hope this helps!

http://www.xl-central.com