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 letternumber 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 letternumber 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 letternumber 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 