| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Increment by Letter not Number
I was wondering if there is a way to make a formula increment to the next
letter character instead of the next number. For instance... =IF(B3="","",A2+1) will give me 1, 2, 3, 4 etc... but what if I want to go by letters or even add letters to the end? =IF(B3="","",IF(B3<B2,A2+1,A2&"a")) where A2 is either 0 or 1 =IF(B3="","",IF(B3<B2,A2+1)) where A2 is either A or AA or 1A or A1 Well, Thanks In Advance, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula copy paste down in a sheet but change row letter increment | Excel Discussion (Misc queries) | |||
| formula converting number to column letter 26 | Excel Worksheet Functions | |||
| Help to write a formula using a letter value and a number value | Excel Worksheet Functions | |||
| change headers from letter to number/number to letter | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Threaded Mode
