| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can auto number (or OFFSET) include letters?
From another post I found a formula to automatically number a cell if there
was data in the cell next to it (for example, if there's data in D5 in the following formula, then D6 will produce a number). =IF(D5<"",MAX($B$1:OFFSET(C5,-1,0))+1,"") My question is, is it possible to do auto numbering just like this formula does, but so that the product is not just a number such as 1 or 2 but a letter-number combo such as R1, R2 etc.? (the letter would always be the same). Thanks! Colleen B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating number of letters in a string ... | Excel Worksheet Functions | |||
| How do I add an auto number to a worksheet | Excel Discussion (Misc queries) | |||
| assign auto number and auto date | Excel Discussion (Misc queries) | |||
| Create an Auto Number | Excel Worksheet Functions | |||
| only include cells beginning with specified character or number | Excel Worksheet Functions | |||
Threaded Mode
