formula

  • Thread starter Thread starter stew
  • Start date Start date
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
 
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:
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif 13
Hyperlink 13
Locating cell using Hyperlink 10
hlookup help 3
adding subTotals from a Column 6
very repetive formula needs looking at 7
address 2
Another Hyperlink Question 4

Back
Top