Dragging question

M

MOB

Well-known Member
Joined
Oct 18, 2005
Messages
1,048
Office Version
  1. 365
Platform
  1. Windows
Is there any way, or code etc, that you can drag a formula downwards, and it increments the column letter rather than the row number?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
RoryA

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
40,380
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Not directly, no. You would need to adjust the formula to use an INDEX or OFFSET function in conjunction with the ROW function. The exact detail would depend on your existing function.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Excel Fill Formula
Replies
2
Views
329
Sheizageek
S
P
  • Solved
dragging data issues
Replies
5
Views
138
Fluff
Fluff
R
  • Solved
Drag a formula
Replies
2
Views
86
Rubber Beaked Woodpecker
R
G
  • Solved
Why is formula no dragging over correctly
Replies
2
Views
102
Joe4
Joe4
L
  • Question
Macro for Formula with Reference Cell
Replies
0
Views
229
Lalala221
L

Forum statistics

Threads
1,191,170
Messages
5,985,061
Members
439,937
Latest member
MAlhash

Share this page

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