How can I choose every nth name in a spreadsheet?

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

Guest

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?
 
Add a helper column with a formula of

=ROW()=INT(ROW()/n)*n

and copy down.

Filter on the TRUE values

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
try
Sub selectnrows()
'n = 3
'or
n = InputBox("how many")
Rows.Hidden = False
For i = 1 To Cells(Rows.Count, "a").End(xlUp).Row Step n
Cells(i, "a").Resize(n - 1, 1).EntireRow.Hidden = True
'MsgBox i
Next i
End Sub
 
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.
 
Back
Top