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

Well you could add; "R"&
=IF(D5<"","R"&MAX($B$1:OFFSET(C5,-1,0))+1,"")

Ola Sandstrom

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

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