Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have read a previous post and thought I could figure this out, but I'm having a hard time understanding what I should do. I have a large list of filtered data. After I filtered the data, I copied and pasted it to a new worksheet. I would like Excel to randomly extract every 50th record (or 100th record, just examples), and create a new list. Is there a way to do this? Do I have to copy and paste the data each time I filter and start the random selection on a different worksheet? Thanks for any suggestions! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Randomly Select Records | Excel Worksheet Functions | |||
how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
I want Excel to randomly select a name from a list | Excel Worksheet Functions | |||
randomly select numbers | Excel Discussion (Misc queries) | |||
randomly select value WITHOUT changing | Excel Worksheet Functions |