Hi thank you for your post. But what I wanted was to get One pick of random
numbers without dups. If that is possible please let me know.

Thanks.

Max wrote:
Then just place in say, B2:
=INDEX(D$2:D$4,RANK(E2,E$2:E$4))

well, if you want a full random shuffle of the source in D2:D4, just copy B2
down to B4.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1