possible to have formula with "gaps"

[erickguz]

Is it to possible to do the following:

A B C D E F... BA BB BC

4 5 2 8 9 6 (4-5) (2-8) (9-6)

In column BA, I want to subtact COL a from COL B
In column BB, I want to subtract COL C from COL D

This is repeated 150 times so the columns are only for reference.

In other words, normally, I can just drag a formula, but here I wouldn't be able to drag.

Thanks.

 

[Marcelo Branco]

Maybe...

BA1 copied across and down
=INDEX($A1:$F1,2*COLUMNS($BA1:BA1)-1)-INDEX($A1:$F1,2*COLUMNS($BA1:BA1))

M.

 

[mrhstn]

I think the INDEX will be better but seeing as I was about to post...

In BA and copied across

=INDIRECT(ADDRESS(ROW(),2*COLUMN(A1)))-INDIRECT(ADDRESS(ROW(),2*COLUMN(A1)-1))

 

[erickguz]

hi. thank you for reply. It worked. I have a question though.

I placed two columns in between the data and thought I could figure out the formula. Didn't work. Is the following possible?

A B C D E F G H BA BB

Chris Green 10 4 Michael Purple 7 2 (c2-d2) (g2-h2)


The difference is that I have now added two columns with data/info in between.

Thank you.

 

[Marcelo Branco]

Try

BA2 copied across
=INDEX($A2:$H2,4*COLUMNS($BA2:BA2)-1)-INDEX($A2:$H2,4*COLUMNS($BA2:BA2))

M.