-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
skip column
-
E
DESPERATE FOR HELP! Drag formula and skip colums
hi, i am currently working on a document where i am pulling data from another work sheet, but i need to skip columns when i drag my formula down to the next row. for example, i want to drag formula "=SUM('2016 Project Breakout'!D12:D17)" down to the next row and have it be "=SUM('2016 Project...- evilchris
- Thread
- excel formula skip column
- Replies: 1
- Forum: Excel Questions
-
A
Dragging a formula right while skipping two columns
I have a formula typed into cell C1 currently. I need this formula to be repeated in F1, I1, L1 etc. How can I drag this formula across all the way until cell BZ1? Essentially, I am skipping two columns each time.- APNADTITON
- Thread
- dragging excel skip column
- Replies: 5
- Forum: Excel Questions
-
L
Skip X cells when dragging a simple formula
Hi Lovely all, I'm trying to drag a formula but would like to skip two columns. I have 2 sheets. Sheet 1 with results and the other with column A originals, B actuals, C difference. Sheet 2 has only originals. So if I drag it goes: ='Sheet 1'A2, ='Sheet 1'B2, ='Sheet 1'C2, etc... What I...- Lia33
- Thread
- copy and paste formula drag drag formula skip column
- Replies: 6
- Forum: Excel Questions
