Copy formula where the cell refrence is not sequential
Hi,
I want to copy a formula across columns, however the first column has this formula =+IF(A2"",A2,"") The next column the reference is C2, then F2 and then H2. When i highlight all four cells and drag i don't get the sequence repeating. Is there a way i can do this. Don't really want to manually edit all cells. Cheers -- Nenagh |
Copy formula where the cell refrence is not sequential
First of all, your sequence is probably off!
Do you mean: A2, C2, E2, G2, ... etc.? If so, try this *without* the superfluous "+" sign: =IF(INDEX(2:2,2*COLUMNS($A:A)-1)"",INDEX(2:2,2*COLUMNS($A:A)-1),"") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Nenagh" wrote in message ... Hi, I want to copy a formula across columns, however the first column has this formula =+IF(A2"",A2,"") The next column the reference is C2, then F2 and then H2. When i highlight all four cells and drag i don't get the sequence repeating. Is there a way i can do this. Don't really want to manually edit all cells. Cheers -- Nenagh |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com