The letters in exel are ordered like this
A B C D .... X Y Z
AA AB AC AD AE AF.... AX AY AZ
BA BB BC BD .... BX BY BZ
.
.
.
ZA ZB ZC... ZX ZY ZZ
AAA AAB AAC ... AAX AAY AAZ
Where A is the first, B the second AA the 27th etc you have to know the order of any array of letters
The letters in exel are ordered like this
A B C D .... X Y Z
AA AB AC AD AE AF.... AX AY AZ
BA BB BC BD .... BX BY BZ
.
.
.
ZA ZB ZC... ZX ZY ZZ
AAA AAB AAC ... AAX AAY AAZ
Where A is the first, B the second AA the 27th etc you have to know the order of any array of letters
Thanks!
Hi g964,
Working great now! Thanks for the cool problem...
can't understand the statemenr