How can I choose every nth name in a spreadsheet?
Use a helper cell, number from 1 to N down the rows, select the 1 to N
cells, and copy, then Paste in starting at the first blank cell after N,
now sort on that column and then pick a group randomly, any number 1
through N.
Rechnem wrote:
I need to take a random sample of names from a spreadsheet. I would like to
choose every Nth name in the sheet. Does anyone know how to do that?
|