Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CarolAn" wrote in message
...
I would like a formula to randumly pick numbers between 1 and 45 but once a
number is picked the number won't be picked again. Is that possible?
--
Carolan