|
formula
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 |
formula
Try this:
=INDEX(2:2,,MAX(--(2:20)*COLUMN(2:2))) It's an array formula, confirm it with Ctrl+Shift+Enter! Regards, Stefi €˛stew€¯ ezt Ć*rta: 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 |
formula
Hi Stefi
I want to replace the(D1+$B$30) part of the following formula with your INDEX(2:2,,MAX(--(2:20)*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 "Stefi" wrote: Try this: =INDEX(2:2,,MAX(--(2:20)*COLUMN(2:2))) It's an array formula, confirm it with Ctrl+Shift+Enter! Regards, Stefi €˛stew€¯ ezt Ć*rta: 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 |
formula
Try...
=IF(ISNUMBER(MATCH(D$7,{"Rehearsals","Day Off","Break","Travel"},0)),"No Show",LOOKUP(2,1/(A2:G20),A2:G2)) Hope this helps! http://www.xl-central.com In article , stew wrote: Hi Stefi I want to replace the(D1+$B$30) part of the following formula with your INDEX(2:2,,MAX(--(2:20)*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 "Stefi" wrote: Try this: =INDEX(2:2,,MAX(--(2:20)*COLUMN(2:2))) It's an array formula, confirm it with Ctrl+Shift+Enter! Regards, Stefi €˛stew€¯ ezt Ć*rta: 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 |
| All times are GMT +1. The time now is 03:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com