16 character permutation possible???

[wacked]

Im new to Excel and was wondering if it were possible to make or find a copy/paste code that would generate 16 different characters either permutation or combination with repitition. The 16 characters consist of 6 letters (A-F)and 10 numbers (0-9)
Ive found permutation calculators but 16 is to large and will only hold 10.
Please help even if its to learn the code. Thanks

 

[Scott Huish]

Generating a 16 digit hexadecimal number with a formula is pretty easy. But you want every possible 16 digit hexadecimal number?

What version of Excel are you using?

 

[Andrew Fergus]

Hi and welcome to MrExcel!

By my reckoning there are 18000 trillion possible values. Surely you don't want all of them in a spreadsheet??? Would it be easier to state the problem you are trying to solve and we can work on that?

Andrew

 

[wacked]

Thanks for the quick reply. Yes i need every possibile hexadecimal. I believe there are 1,040,800. I am using Office 2007

 

[wacked]

Thank you Andrew. Im not sure, Ive never used a work sheet before. Basically what i need is a list of those hexadecimals and for each one i need to put 3 or 4 different columns next to it. like a name, a number and a group name. eventually i need to be able to sort these hexadecimals by group name or by number or by name with the push of a button.

 

[wacked]

Oops! I think i left out a big part of my question! LOL Did i mention that i only need 16 different hexadecimals but only in a string of 5, with repitition? Sorry bout that

 

[Andrew Fergus]

Are there 16 characters each of which contains one of a possible 16 values?

For instance from:
0000000000000000
0000000000000001
0000000000000002
etc.
to :
FFFFFFFFFFFFFFFD
FFFFFFFFFFFFFFFE
FFFFFFFFFFFFFFFF

If that is the case, then the number of possible combinations is 16^16.

Andrew

 

[Scott Huish]

So, basically just 16 random 5 digit hexadecimal numbers?

 

[Scott Huish]

If that's the case:
Prior to XL2007, you will need to load the Analysis Toolpak for this:

=DEC2HEX(RANDBETWEEN(0,1048575),5)
Copy down.

 

[wacked]

Yes that's it 16 random 5 hexadecimals