# Auto fill by 2?

#### Greggey1

##### New Member
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.

### 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)

#### Greggey1

##### New Member
Tried creating a pattern with the first 6 rows. Still no good.

#### Fluff

##### MrExcel MVP, Moderator
What is you existing formula?

#### JamesCanale

##### Board Regular
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

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
What is you existing formula?
=IF(AND(C16="shopped",C17="Shopped"),OR(D16=\$H\$10,D17=\$H\$10),"false")

So when I auto fill I would expect to see c18,c19 and d18,d19.

#### Greggey1

##### New Member
Figured it out. Just have to merge cells by twos than drag the auto fill. Works. Thanks for the help.

#### Fluff

##### MrExcel MVP, Moderator
Glad you sorted it & thanks for the feedback.

Replies
1
Views
45
Replies
2
Views
277
Replies
3
Views
52
Replies
1
Views
160
Replies
2
Views
204

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?

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