I like J.E. McGimpsey's UDF.

You can find it he

http://www.mcgimpsey.com/excel/udfs/randint.html

Baha wrote:

hi
I want to assign random numbers from 1 to 50 to the range of A1:A20 without
repetition.I checked several related questions but really couln`t understand
how this works.
thanks for help.
--
Regards,
Baha

--

Dave Peterson