In Excel 2007 -

List of random numbers are in A1:A200

in the first row of another column:
=IFERROR(SMALL(IF(FREQUENCY(A$1:A$200,A$1:A$200)0 ,A$1:A$200),ROWS($1:1)),"")

copy down.

This will give you a unique list.
--
If this post helps click Yes
---------------
Peggy Shepard


"OPer" wrote:

I am trying to extract a random sample of 100 numbers .
The problem that I'm having is that the sample keeps coming up with
duplicate numbers.

Can anyone tell me how I can eliminate these duplicates?

Any help would be appreciated