Mark every nth row

Hi all:

I searched but couldn't find anything quite matching this. I have data in columns A through E down to row 25000. I want to put the number 1 in column F for every nth (in this case fifth row). Attached is a small sample. Any help is appreciated.

Max

Using your posted workbook....try this:

H1: RowTest....(or blank or anything that's not a col heading)
H2: =MOD(ROW(E2),5)=0
Note: that formula refers to the first row under the headings

Next...from the Excel Main Menu:
Data.Filter.Advanced_Filter
...List Range: (select your data....currently A1:E459)
...Criteria Range: $H$1:$H$2
...Click: OK

Now only every 5th row under the headings will be displayed (5, 10, 15, etc)
• Select from F5:F455
• Type: 1.....Hold down CTRL and Press ENTER
(That will enter a 1 in each visible cell in the selection
Last....Data.Filter.Show_All

Does that help?

Here's an example using VBA
Click the button and enter How Many nth rows, it will only enter numbers as far down as you have data.