| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lettering rows
How do I sequencially letter rows in Excel?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Lettering | Excel Worksheet Functions | |||
| Auto Lettering Rows | Excel Worksheet Functions | |||
| Auto Lettering | Excel Worksheet Functions | |||
| How do I Reset Column lettering | Excel Worksheet Functions | |||
| Tool Bar lettering problems | Excel Discussion (Misc queries) | |||
Linear Mode
