how can i select every nth row?


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
 
Ad

Advertisements

F

Frank Kabel

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'
 
M

Myrna Larson

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).
 
G

Guest

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'
 
Ad

Advertisements

B

Bill Kuunders

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top