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
|