random number generator

[Guest]

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!!!

 

[Guest]

Some functions are going to recalculate every time you make a change on your
document if you have autocalculate on. If you are going to move the 100 over
why can't you calculate and then immediatley move them over. You could run
the random bit and then copy the random numbers and 'paste
special'....'values' into a new column. This would leave the random numbers
in a column and not the formula and thus the numbers would not change after a
recalculation.

 

[Tushar Mehta]

For options that don't (and for options that do) redo the random list with
each calculation, see
Random Selection
http://www.tushar-mehta.com/excel/newsgroups/rand_selection/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions