How many combinations can be created with 2 letters, 2 numbers, and 2 letters?

Click For Summary
SUMMARY

The discussion centers on calculating the total number of unique combinations for a code consisting of 2 letters, 2 numbers, and 2 letters, specifically using 24 letters (ABCDEFGHJKLMNPQRSTUVWXYZ) and 8 numbers (23456789). The formula used is 24 * 24 * 8 * 8 * 24 * 24, resulting in 21,233,664 possible combinations. The user, Ryan, seeks to generate 2.5 million unique codes while acknowledging the potential for duplicates in random generation, particularly when using Excel's random functions.

PREREQUISITES
  • Understanding of combinatorial mathematics
  • Familiarity with random number generation techniques
  • Basic knowledge of Excel functions for generating random values
  • Concept of permutations and combinations in coding
NEXT STEPS
  • Research combinatorial mathematics to deepen understanding of combinations and permutations
  • Learn about Excel's RAND and RANDBETWEEN functions for generating random numbers
  • Explore methods for removing duplicates in datasets using Excel or programming languages
  • Investigate algorithms for generating unique random sequences, such as Fisher-Yates shuffle
USEFUL FOR

Software developers, data analysts, and anyone involved in generating unique codes or random sequences will benefit from this discussion.

reldridge
Messages
5
Reaction score
0
I am creating a random combination(code) for a client. I need to see what the total number of combinations there can be.

Please let me know if I am using the wrong word Combination vs Permutations.

Formula:
2 letters + 2 numbers + 2 letters
example: TR12FR

The random letters are taken from 24 values:
ABCDEFGHJKLMNPQRSTUVWXYZ

The random Numbers are taken from 8 Values:
23456789

Any help would be greatly appreciated.

Thanks
Ryan.
 
Last edited by a moderator:
Mathematics news on Phys.org


combination is right you're selecting letters, numbers and more letters:

Choices for each character of your 6 charcter code:

24 * 24 * 8 * 8 * 24 * 24 = total number of codes possible

Now if these could be rearranged then you'd have to worry about permutations to elimnate repeats in your counts.
 


Thank you -

So de-duping these down to create 2.5 million unique codes using this formula will not be an issue, sense there are 21,233,664 possibilities.
 
Last edited:


Well sense this is just a random generator out of excel the possibility of it creating a duplicate is there, so i will need to just remove dupes, or nth select down to 2.5 million unique codes.

Just needed to make sure that the 6 digit using that formula could create that many unique codes.
 


reldridge said:
Well sense this is just a random generator out of excel the possibility of it creating a duplicate is there ...

So you have a belief that "true" random would not include any dupes?

How would you create 100000 consecutive random numbers from 1 to 100 ?
 


this reminds of how new programmers used to construct a deck of randomly sorted cards.

generate a number from 0-51 check if its present in the crd deck array if so then generate another.

The better approach is to generate a sorted sequence of cards into an array and then to randomly shuffle two cards by selecting two indexes at random and swapping the cards.
 


phinds said:
So you have a belief that "true" random would not include any dupes?

No belief, was just stating that there could be duplicate codes during the random selection and i would need to remove the duplicates until reaching my goal of 2.5 unique codes...
 


Thanks for the help.
 

Similar threads

Replies
1
Views
6K
  • · Replies 20 ·
Replies
20
Views
3K
Replies
4
Views
7K
  • · Replies 2 ·
Replies
2
Views
2K
Replies
1
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K
Replies
1
Views
3K
Replies
23
Views
3K
Replies
1
Views
1K
  • · Replies 3 ·
Replies
3
Views
2K