Randomly Select Records
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?
|