Need to create unique pin codes

Erm... Can you explain a 4 digit code using numbers 1 to 20??

Your description is a little confusing because how do you compose 4-digit codes from the numbers 1-20? Do you mean that you have to generate 20 different unique 4-digit codes?

Here is one example. I don't know of a way to do this by formulas alone. This method requires one manual step to refresh the list.

There are three columns. The first column is a sequence number, which you can use to assign PINs to people. This column can be anything you want--names, employee numbers, account numbers. The second column is the PIN associated with that sequence number. There are 1000 unique PINs in this column (there are 1000 unique possible 4-digit PINs). The third column is random numbers. To generate a fresh set of PINs, click on the dropdown at the top of column C and select "Sort smallest to largest." The PINs will be shuffled and reassigned to the sequence numbers.

It is also possible to do this with macros, but this was a little quicker to put together.

Here's a little bit of code, which randomly generates a set of five numbers between 1-20, with no duplicate combinations.

Double click the PIN heading to add a new combination to the list.

Ah, so you don't want duplicates in each set of 5 numbers? That wasn't clear...

Let me have a look at it.

Okay - change the code to:

Please Login or Register  to view this content.

To change the number range, amend the numbers coloured red.
To change the count of number returned in the overall PIN combination, change the number coloured blue. This loops from 0, not 1, so enter one less than the value you need - so, for 5 x numbers, enter 4 here.

There's almost 2M permutations -- is there really value in listing them all?

Originally Posted by shg

There's almost 2M permutations -- is there really value in listing them all?

Yeah, that - there are 20 x 19 x 18 x 17 x 16 = 1,860,480 permutations. What do you want to do with the complete list?!

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

Originally Posted by a_dumb_fake_name

How could we update this macro if we needed this to generate PINs without sequential numbers?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread