Formulas
I want to enter the formula =IF(Data!D18="","",Data!D18). Is there any way to
have the fomula automaticaly capture the reference Data in the next cells without manually typing it in as the Data is not consecutive. Example below =Data!A18 =Data!B18 =Data!C18 =Data!D18 =Data!A20 =Data!B20 =Data!C20 =Data!D20 =Data!A22 =Data!B22 =Data!C22 =Data!D22 =Data!A24 =Data!B24 =Data!C24 =Data!D24 =Data!A26 =Data!B26 =Data!C26 =Data!D26 =Data!A28 =Data!B28 =Data!C28 =Data!D28 =Data!A30 =Data!B30 =Data!C30 =Data!D30 =Data!A47 =Data!B47 =Data!C47 =Data!D47 =Data!A49 =Data!B49 =Data!C49 =Data!D49 =Data!A51 =Data!B51 =Data!C51 =Data!D51 =Data!A53 =Data!B53 =Data!C53 =Data!D53 Any Help would be greatly appreciated! |
Formulas
In cell A1 of a a separate sheet type:
=INDIRECT("DATA!"&CHAR(COLUMN()+67)&(ROW()*2-1)+17) and copy down and across. Micky "B.G. - Canada" wrote: I want to enter the formula =IF(Data!D18="","",Data!D18). Is there any way to have the fomula automaticaly capture the reference Data in the next cells without manually typing it in as the Data is not consecutive. Example below =Data!A18 =Data!B18 =Data!C18 =Data!D18 =Data!A20 =Data!B20 =Data!C20 =Data!D20 =Data!A22 =Data!B22 =Data!C22 =Data!D22 =Data!A24 =Data!B24 =Data!C24 =Data!D24 =Data!A26 =Data!B26 =Data!C26 =Data!D26 =Data!A28 =Data!B28 =Data!C28 =Data!D28 =Data!A30 =Data!B30 =Data!C30 =Data!D30 =Data!A47 =Data!B47 =Data!C47 =Data!D47 =Data!A49 =Data!B49 =Data!C49 =Data!D49 =Data!A51 =Data!B51 =Data!C51 =Data!D51 =Data!A53 =Data!B53 =Data!C53 =Data!D53 Any Help would be greatly appreciated! |
All times are GMT +1. The time now is 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com