Thread: [Solved] Unique 3 char Alpha Numberic column
View Single Post
 
Old 03-07-2012, 01:06 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Yes, 0 to 9 gives 10 extra characters so 36^3 = 46656

A1 =ROW()-1 and fill down to A46656
B1 =MOD(A1,36)+IF(MOD(A1,36)<26,65,22)
C1 =INT(MOD(A1/36,36))+IF(INT(MOD(A1/36,36))<26,65,22)
D1 =INT(MOD(A1/36/36,36))+IF(INT(MOD(A1/36/36,36))<26,65,22)
E1 =CHAR(B1)&CHAR(C1)&CHAR(D1)


If case sensitive then you could also include lower case alpha which would then give you 238328 unique codes. I'll let you have a try at that one.
Reply With Quote