Copy formula where the cell refrence is not sequential


N

Nenagh

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
 
Ad

Advertisements

R

RagDyeR

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!
=====================================================


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top