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

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!
467 2

16 replies

SGIII

Level 8

37,930 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?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up