Auto fill by 2?

Greggey1

New Member
Joined
Mar 29, 2019
Messages
5
have a table with 400rows. Every two rows I’m using a formula to extract data. When I use auto fill the formula only increases the the cell value by one. Example
Need info from a1,a2 and a3, a4...etc
So I use a formula to get the valve of a1 and a2. When I auto fill the formula now uses a2 and a3. Need it to be a3 and a4 is this possible? Really don’t feel redoing the formula 200 times.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,799
Office Version
  1. 365
Platform
  1. Windows
What is you existing formula?
 

JamesCanale

Board Regular
Joined
Jan 13, 2021
Messages
137
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
If you data starts in A2, this does A2+A3, and if you drag it down one, you get a4+a5,...

Excel Formula:
=OFFSET($A$2,(ROW(A2)-2)*2,0)+OFFSET($A$2,(ROW(A2)-2)*2+1,0)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,799
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Another possible option without volatile functions
+Fluff 1.xlsm
AB
1
211, 2
323, 4
435, 6
547, 8
659, 10
7611, 12
8713, 14
9815, 16
10917, 18
111019, 20
1211
1312
1413
1514
1615
1716
1817
1918
2019
2120
Main
Cell Formulas
RangeFormula
B2:B11B2=INDEX($A$2:$A$800,ROWS(F$2:F2)*2-1)&", "&INDEX($A$2:$A$800,ROWS(F$2:F2)*2)
 

Greggey1

New Member
Joined
Mar 29, 2019
Messages
5
Figured it out. Just have to merge cells by twos than drag the auto fill. Works. Thanks for the help.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,799
Office Version
  1. 365
Platform
  1. Windows
Glad you sorted it & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,157
Messages
5,629,027
Members
416,359
Latest member
Juena

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