Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I choose every nth name in a spreadsheet?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I choose every nth name in a spreadsheet?
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) "Rechnem" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I choose every nth name in a spreadsheet?
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 -- Don Guillett Microsoft MVP Excel SalesAid Software "Rechnem" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can 0 be used in the Choose function | Excel Worksheet Functions | |||
How do I choose first value greater than 0? | Excel Worksheet Functions | |||
Choose Function | Excel Discussion (Misc queries) | |||
can i get excel to choose every 10th entry in a spreadsheet | Excel Worksheet Functions | |||
Choose. | New Users to Excel |