how to eliminate duplicate numbers
Say your data is in column B from B2 thru B1000 and we want to sample 100 of
these values with no repeats.
In A2 thru A1000 enter:
=rand()
In E2, enter:
=OFFSET($B$2,MATCH(LARGE($A$2:$A$1000,ROW()),$A$2: $A$1000,0),0)
and copy down thru E101
--
Gary''s Student - gsnu200903
"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
|