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

 

[wacked]

Ive installed the analysis toolpak, and pasted the code. Wow it works! Thanks both for your help! Can all million hexadecimals generate themselves or do i have to expand them manuely and do i use one column or use both coumns and rows? Because i would like to add a name to each one.
Also can they be ranked though not a nessecity.

 

[Scott Huish]

Since you are running a version of Excel prior to XL2007, it will take 16 columns to list them all. If you want to do that, do you just want to list them all in order?

 

[Scott Huish]

In A1:
=DEC2HEX((ROW()-1)+((COLUMN(A1)-1)*65536),5)

Copy to A1:P65536

​

 

[wacked]

Since you are running a version of Excel prior to XL2007, it will take 16 columns to list them all. If you want to do that, do you just want to list them all in order?

I am running Excel 2007 that came with Office Enterprise 2007 if that helps

 

[Scott Huish]

Then you don't need to load the Analysis Toolpak, the functions are built into XL2007 and later.

If you are not running in Compatibility Mode, then in A1:

=DEC2HEX(ROW()-1,5)

Copy down.

Otherwise, use the previous solution.

 

[wacked]

I dont know how you figured this out or even how Excel reads that code but it works! Its exactly what i was looking for. Thank you

 

[wacked]

Would anyone happen to know how to spread those numbers onto different worksheets as copy and pasting doesnt work. Id like to be able to spread these out to where work sheet number1 is just all 1's another work sheet is for the 2's etc etc or however i want to spread them being that its a lot of permutations for one page.

 

[Scott Huish]

Copy and Paste Special Values

 

[Scott Huish]

As to how it works:

ROW() with no arguments returns the row number.

So in cell A1, it would return 1, we are going to subtract 1 from this because we want to start from 0.

DEC2HEX converts a decimal number into a hexadecimal number

The 5 at the end of this indicates that we want 5 hexadecimal places in the number.

When the formula is copied down, it increases the row number and therefore the result.

 

[wacked]

As to how it works:

ROW() with no arguments returns the row number.

So in cell A1, it would return 1, we are going to subtract 1 from this because we want to start from 0.

DEC2HEX converts a decimal number into a hexadecimal number

The 5 at the end of this indicates that we want 5 hexadecimal places in the number.

When the formula is copied down, it increases the row number and therefore the result.

Very informative, thanks!