Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to workbook by cell refrence | Excel Discussion (Misc queries) | |||
Copy sequential formula | Excel Discussion (Misc queries) | |||
range,cell refrence | Excel Worksheet Functions | |||
moving the refrence to the 5th cell while dragging. | Excel Worksheet Functions | |||
How NOT to extend formula/refrence to a cell | Excel Worksheet Functions |