Thread: Lettering rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Lettering rows

Tobycat wrote:
How do I sequencially letter rows in Excel?


Two solutions were provided yesterday (assuming "Tobycat" and "Mollycat" are the
same person)...

=MID(ADDRESS(1,ROW()),2,LEN(ADDRESS(1,ROW()))-3)

and

=IF(ROW()932230,"B",IF(ROW()475254,"A",""))&
IF(ROW()18277,CHAR(64+MOD(INT((ROW()-18279)/17576),26)+1),"")&
IF(ROW()702,CHAR(64+MOD(INT((ROW()-703)/676),26)+1),"")&
IF(ROW()26,CHAR(64+MOD(INT((ROW()-27)/26),26)+1),"")&
CHAR(64+MOD(ROW()-1,26)+1)


If those aren't sufficient, please provide more details about what you need.