| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sampling
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sampling | Excel Discussion (Misc queries) | |||
| Sampling Program | Excel Worksheet Functions | |||
| A Sampling Program | Excel Discussion (Misc queries) | |||
| Random Sampling | Excel Discussion (Misc queries) | |||
| Sampling | Excel Discussion (Misc queries) | |||
Hybrid Mode
