how can i select every nth row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to select every 10th row in a list of 35,000 email addresses to come
up with 3,500 for a survey. Thanks for any help
 
Hi
in B1 enter:
=--(MOD(ROW()-1,10)=0)
and copy down for all rows.

After this select this range and copy it. Insert it with 'Edit - Paste
Special - Values'

Now apply a filter and filter all rows with a '1'
 
Not to rain on your parade, but doesn't your survey require a random sample?
Perhaps selecting every 10th address would not qualify.

Another approach, assuming you can sort the data, is to put a column on the
right with the formula =RAND() and copy that down. Then sort using that column
of random numbers as the key. Choose the top 3500 (or bottom 3500, or any
group of 3500 from any position in the list).
 
Cool! Thanks, works like a charm!

Frank Kabel said:
Hi
in B1 enter:
=--(MOD(ROW()-1,10)=0)
and copy down for all rows.

After this select this range and copy it. Insert it with 'Edit - Paste
Special - Values'

Now apply a filter and filter all rows with a '1'
Click to expand...
 
I'm sure there will be a macro option to do this.

Other way would be to insert a new column.
Format the column as text.
Enter a series 1 to 35000 using the right hand bottom corner drag and fill
method.

Use --Data--Filter--Autofilter
select in the new column dropdown --custom....--
select ---ends with--
enter 0

regards
Bill K
 
Back
Top