Alphanumeric Sequencing

[adodd81802]

Hi,

I'm not completely sure Excel is the best for this, and i do appreciate what limit this could go up to, but i'm currently trying to create a sequence of Letters and Numbers in roughly the following

AAAAA0
AAAAA1
AAAAA2 etc to AAAAA99

then AAAAB0
AAAAB1
AAAAB2 etc to AAAAB99

and so on progressing the letters as if i was counting by numbers. I dont want numbers in the letter sequence so even up to ZZZZZ99, i have tried a few things and the best i could get going was the letters only.

Any help is appreciated.

[Bob Phillips]

Put AAAA00 in A1, add this UDF

Please Login or Register  to view this content.

and then input =NextInSequence(A1) in A2 and copy down

[adodd81802]

Hi Thanks for your response, i have put the code in and entered the information into the cells however i get the #NAME? result, i may have missed something silly here

[MickG]

This is a basic Code, with a stop, for testing:-

Please Login or Register  to view this content.

Regards Mick

[adodd81802]

Hi Mick,

Thank you, this worked for me. In the even i may want to add to make it a 6 letter; 2 number combo or even 7 letter; 2 number combo etc what alterations to the code will i need to make?

Thanks

EDIT

on 2nd look it appeared to work but a few errors came up,

originally had 5 a's and the number sequence then progressed to 4 a's and number sequence, i hope to get this to the point where its zzzzz99 technically incorporating every possible 5 letter combination combined with every number from 0-99. i think its about 12 million combinations or more i've been told. but nevertheless!

apologies if i have not made clear i am looking to make

aaaaa0
aaaaa1 (up to)
aaaaa99 then
aaaab0
aaaab1 (up to)
aaaab99
all the way to
aaaaz99

then
aaaba1
aaaba2
aaaba3 (up to 99)
aaabb1
aaabb2
aaabb3

and so on. sorry i thought it was a simple code but the numbers seem to be throwing it off a little.

[adodd81802]

sorry make that a 5 letter; 2 number, 6 letter; 2 number, 7 letter; 2 number etc

[MickG]

Try this:-
For More letters you jut need to add more loops as per loops:- n1 to to n5
This is a lot of cells and would be quicker if you placed Results into an array, but you would not see the sheet result until the code was completed.

Please Login or Register  to view this content.

Regards Mick