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 |
#2
|
|||
|
|||
Well you could add; "R"&
=IF(D5<"","R"&MAX($B$1:OFFSET(C5,-1,0))+1,"") Ola Sandstrom |
#3
|
|||
|
|||
Hi
=IF(D5<"","R" & MAX($B$1:OFFSET(C5,-1,0))+1,"") Arvi Laanemets "Colleen B" wrote in message ... 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 |
#4
|
|||
|
|||
Collen
This may do what you want. =IF(D5<"","R" & MAX($B$1:OFFSET(C5,-1,0))+1,"") Gord Dibben Excel MVP On Mon, 21 Feb 2005 11:45:03 -0800, Colleen B wrote: 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 |
Reply |
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 |