If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Formulas
=INDEX(Data!A:A,ROWS($1:1)*2+16)
copy down as far as needed "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! |
#3
|
|||
|
|||
Formulas
Put the row numbers in column E from E1 to E11:
18 20 22 24 26 28 30 47 49 51 53 Then put this formula in A1: =IF(INDEX(Data!A:A,$E1)="","",INDEX(Data!A:A,$E1)) and copy across to D1. Then copy A11 down to row 11. Hope this helps. Pete On Mar 17, 3:43*pm, 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! |
Thread Tools | |
Display Modes | |
|
|