Transposing columns of data

[jms2553]

I have 2 columns of data - both are over 25,000 rows. I need to subtract the number in A25000 from B1, the number in A25499 from B2 and so on.

I can only transpose rows to columns or vice versa and if I try to auto fill the formula, it won't go in reverse. Please help!

 

[Joe4]

I need to subtract the number in A25000 from B1, the number in A25499 from B2 and so on.

What cells are these formulas going to be placed in?

We should be able to use the INDIRECT function with a calcualtion involving the ROWS function to do what you want.

 

[Domenic]

Maybe...

C1, copied down:

=B1-INDEX($A$1:$A$25499,ROWS($A$1:$A$25499)-ROW()+ROW($A$1))

Hope this helps!