Is there a formula or function I can use to generate 500 or so six digit random numbers? I need to assign unique six digit numbers for keypad access to a restricted area.
Thanks,
Bjohnston
Hi Bjohnston,
Formula in B2 =RANDBETWEEN(0,9)
Fill right to G2 then fill down.
Formula in H2 (and fill down) =B2&C2&D2&E2&F2&G2
Formula in I2 (and fill down) =COUNTIF(H$1:H2,H2)
That will check for duplicates. Any value greater than 1 is not unique.
Now select Column H, copy then Menu > Edit > Paste Formula Results
That will freeze the values.
Regards,
Ian.
Thanks once again. I'm old enough to remember Visicalc, but I've been away from it for many years, so this is very helpful.
Bjohnston
Six digit random number generator?
