One variation to play with ..

Assume your source records is in A1:A2000

Place in B1: =RAND()
Copy down to B2000

Then place in say, C1:
=INDEX(A:A,RANK(B1,$B$1:$B$2000))
Copy C1 down by 400 rows to C400

C1:C400 will return 400 random, non-duplicating picks
from the source within A1:A2000

Press F9 to re-generate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Critzy" wrote:
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?