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

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

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

gary53217 wrote on Thu, 26 Apr 2007 11:22:08 -0700:

g "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

The old trick of making a helper column on the far right,
filling it with RAND(), sorting and using the first 150 might
work.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

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

That did it. Thanks much.
Gary

"Toppers" wrote:

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