Auto fill by 2?

Greggey1

New Member
Joined
Mar 29, 2019
Messages
8
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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
What is you existing formula?
 
Upvote 0
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)
 
Upvote 0
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)
 
Upvote 0
Figured it out. Just have to merge cells by twos than drag the auto fill. Works. Thanks for the help.
 
Upvote 0
Glad you sorted it & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,162
Members
448,554
Latest member
Gleisner2

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
Back
Top