Generate Random Number

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.

For random numbers, see

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

To identify duplication see

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




In article <usXSb3pnFHA.3760@TK2MSFTNGP15.phx.gbl>,
"Glenn" <nospam@yahoo.com> wrote:

> 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?