can i get excel to choose every 10th entry in a spreadsheet

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

Guest

i have a spreadsheet with over 3000 entries and I need to select every tenth
one - can anyone explain an easy way to do this?

the spreadsheets contain names and addresses, the first column is numbered
one to whatever

thank you
 
Assume your entries start in A2 going to A3001, in B2 put TRUE, in B3 put

=MOD(ROW(1:1),10)=0

copy down to B3001, apply autofilter on row 1 (assuming you heva a header
filter on B and TRUE, select the whole range, press F5, special and select
visible cells, copy and paste to a new sheet, delete the help column, copy
and paste


Regards,

Peo Sjoblom
 
I'll try that, thank you so much

Peo Sjoblom said:
Assume your entries start in A2 going to A3001, in B2 put TRUE, in B3 put

=MOD(ROW(1:1),10)=0

copy down to B3001, apply autofilter on row 1 (assuming you heva a header
filter on B and TRUE, select the whole range, press F5, special and select
visible cells, copy and paste to a new sheet, delete the help column, copy
and paste


Regards,

Peo Sjoblom
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Copy info from one excel spreadsheet to an excel template 2
Function in Excel to count and list number of entries of text valuesin a row. 2
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS 7
Collate data from one spreadsheet into another spreadsheet 2
Using spreadsheet to fill in forms 1
Excel - Compare spreadsheets and indicate matched data 4
Counting dates in columns in a linked spreadsheet 1

Back
Top