When I use your formula, it is generating only large decimal numbers that
aren't sorting correctly. Is there something to add to the formula so that
it will generate whole numbers only?

"Gary''s Student" wrote:

Say your data is in A1 thru A2000

1. in B1 thru B2000 enter:
=RAND()
2. sort columns A & B by column B
3. pick the first 400 items in column A
--
Gary''s Student
gsnu200710


"Critzy" wrote:

I need a way to randomly select 400 records from a worksheet containing
around 2000. Is there a formula or function that will do this?