Check out this page of Chip Pearson's.

Scroll down to "D", and see all the goodies he's got there concerning
duplicates.

http://www.cpearson.com/excel/topic.htm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nu-bEE" wrote in message
...
I have created a Lotto Checker, how can I stop a number from being
repeated
in the `winning number` input cell/s

I am already using validation to restrict the input from 1 to 49.

If you can assist please post back to this board.

PLEASE ALWAYS POST BACK TO THE BOARD, OTHEWRS MAY FIND THE SOLUTION
HELPFUL