Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
random number generator
I've been using the RNG and it works great... however, we need to take it one
step further. I've looked all thru previous posts, but can't figure this out. I've got 10,000 names, addresses, etc all in a spreadsheet. I need to randomly select 100 and put those names, adresses, etc into another tab. As was mentioned in another post, I could simply sort the data by my 'rng' column, but since the data constantly changes, so too would the sort order. Also, each time I press the 'delete' key it reruns my sort. Is this normal? Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
Random Number generator | Excel Worksheet Functions | |||
VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) | |||
Random Number Generator | Excel Worksheet Functions | |||
Random number generator | Excel Worksheet Functions |