200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Good day,
I need to build a matrix, 12000 rows deep. Every 10 rows must have the same value, ex 30. The next 10 rows must again have the same value, 16 more than the previous rows, 46.
30
30
30
30
30
30
30
30
30
30
46
46
46
46
46
46
46
46
46
46
62
62
62
62
62
62
62
62
62
62
And so on...
Please assist me?
Regards and thanks,
Anate
Please try this formula.
=$B$30+(INT((ROW()-30)/10)*16)The formula calculates each cell's value based on the original you entered in B30. Please change the column if B isn't the column you work in.
Enter the starting value in 30 of the column indicated in the formula. Paste the formula to the cell immediately below that and copy from there to the bottom of your sheet. All values will change if you modify B30.
Since you have many rows to paste the formula to note this quick way of selecting a large range. On the Ribbon's Home tab click on Find & Select. Select GoTo and enter the range you wish to select in the Reference field. Click OK. You can use this feature to copy/paste. For example, select B31 and click Copy (or press Ctl+C). GoTo B32:B10500, press OK in the dialog box and then press Enter to confirm the selection and to complete the pasting process.