How to select every nth row

**colll999** · 06-27-2013, 09:03 AM

Hi everybody, this is the first time I have used Excel so my knowledge is pretty non existent!

So here is what I need -

I have rented a mailing list that consists of names and addresses of 5000 people.

I would like to take 1000 of those names and addresses to do a test mailing.

(The file is in .csv)

So I would like to for example select every 10th row or every 6th row (the selection number is not important)

I know I can do this by clicking on the row number then holding down Ctrl and clicking the the next row number i want,
but going through 5000 rows this is going to be time consuming.

Just wondered if there was an easier way to do this?

Any help with this would be much appreciated,

Thanks,
Colin

**amotto11** · 06-27-2013, 09:31 AM

an easy way to do this without VBA is filtering. If your data is in cells A1:B5000 or whatever, put an "A" in cell C1, then for every 10th, highlight C1 to C9. Once you have selected those cells, there should be a small box in the lower right corner of your selection, double click that box and you will have an "A" in every 10th box then go to your data tab and select filter, then filter column C by "A" then copy the data out. Let me know if this help and makes sense.

**martindwilson** · 06-27-2013, 09:55 AM

or in a spare column say col H
put the number you want in H1 say every 5th then put 5
in h2
=IF(MOD(ROWS($A$1:A1),$H$1)=1,"select","") fill that down to last row
now filter data by col h on select