Formula help

Harquor

New Member
Joined
Jun 22, 2006
Messages
36
Hi there! Just a basic one, I'm sure, but it's driving me NUTS!

I'm trying to copy a formula down from one cell and have it change just the column letter in the next. Here's my formula.
='Month Ends'!N$52
Next cell should be
='Month Ends'!O$52
and so on.

Please help. Thank you!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi Harquor

In A1:

=INDEX( 'Month Ends'!$52:$52,1,ROW()+13)

If you are not starting in A1 please adjust the number.

Hope this helps
PGC
 

Harquor

New Member
Joined
Jun 22, 2006
Messages
36
Wow! That was quick!

I'm a little new at excel so adjusting this is beyond me. The cell I'm putting the formula in is F10. Could you tell me how to make the adjustments so I can fill in other cells too?

Thank you!
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi again

The second parameter of the index tells you the column you are referencing.

Since you want to start at column N that is column 14 (check).

If you started at A1, you were starting at row 1 and so you had to add 13 to get to N.

Now you already start at row 10 so you just have to add 4.

In F10
=INDEX( 'Month Ends'!$52:$52,1,ROW()+4)

Remark: You could start in any cell in row 10 and the formula would be the same.

Hope this solves your problem
PGC
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
P. S. Copy down the formula to get the other cells (O52, P52, etc.)
 

Forum statistics

Threads
1,136,613
Messages
5,676,813
Members
419,652
Latest member
jjakub33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top