Increment cell reference after nth row.

sshirazi

New Member
Joined
Aug 5, 2016
Messages
7
Col A Col B
Text1 Text1
Text2 Text1
Text3 Text1
Text4 Text1
Text5 Text2
Text6 Text2
Text2
Text2
Text3
Text3
Text3
Text3

Need a formula in column B to copy data from Col A & increment the reference every 5th row as above.
Column A is over 2,000 line item. Please help!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
See if you can adapt this to suit what you want. Formula in B2 is copied down.

Excel Workbook
AB
1
2Text1Text1
3Text2Text1
4Text3Text1
5Text4Text1
6Text5Text2
7Text6Text2
8Text2Text2
9Text2Text2
10Text3Text3
11Text3Text3
12Text3Text3
13Text3Text3
14Text4
15Text4
16Text4
17Text4
18Text5
19Text5
Repeat Values
 
Upvote 0

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

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