Six digit random number generator?

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

Posted on Sep 28, 2019 4:30 PM

Top-ranking reply

Yellowbox

Level 7

21,939 points

Posted on Sep 28, 2019 5:23 PM

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.

View in context

Similar questions

rand randbetween Is there a way in Numbers to use RAND or RANDBETWEEN to generate a random number but without it generating a new random number whenever any cell is changed? I want to generate a random number once and then again only if a particular cell is changed, not if just any cell is changed. Thanks for any ideas!
384 2

16 replies

SGIII

Level 8

37,550 points

Sep 29, 2019 6:55 PM in response to bjohnston

Or:

In A2, down:

=RIGHT("00000"&INT(RAND()×1000000),6)

The check for duplicates in B2, filled down:

=COUNTIF(A,A2)

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Six digit random number generator?