Generate Random Number

[Glenn]

Hi,

I have a list of 5 digit numbers that are codes which are already in use.

I'd like to generate a list of random 5 digit numbers to use for new codes,
but I need to make sure they aren't on my original list.

Could someone tell me how to generate a random 5 digit number in a cell? I
just want a whole number, no decimals. And, how do I make sure the number
isn't on my original list?

Thanks.

 

[JE McGimpsey]

For random numbers, see

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

To identify duplication see

http://cpearson.com/excel/duplicat.htm