As I said, If data is in A1, put formula in B1 and copy down.

"gary53217" wrote:

Thank you "Toppers". So do I copy and paste this formula in A1? It just
made A1 a "0." I tried copying A1 and selecting remaining cells under A but
just got 0's.

"Toppers" wrote:

With data in column A, starting A1, this will select rows 1,11,21 etc. Put in
B1 and copy down

=INDEX(A:A,(ROW()-1)*10+1,1)

HTH

"gary53217" wrote:

I have a list of about 1,500 clients in a spreadsheet and would like to
choose every 10th one for a sample group. Any suggestions on doing so? I
have Excel 2003.
Thank you