Thread: Can auto number (or OFFSET) include letters?
View Single Post
  #2   Report Post  
Ola
 
Posts: n/a
Default
Well you could add; "R"&
=IF(D5<"","R"&MAX($B$1:OFFSET(C5,-1,0))+1,"")

Ola Sandstrom

Reply With QuoteReply With Quote