Transposing columns of data

jms2553

Board Regular
Joined
Jun 5, 2002
Messages
107
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!
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

MikeNewton

Board Regular
Joined
Nov 17, 2004
Messages
182
Something like this should work

=B1-INDIRECT("B"&25000-ROW())

Then copy down
 

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,640
Members
412,334
Latest member
ExcelForLifeDontHate
Top