Remember Me?

 Colleen B Posts: n/a 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

 Ola Posts: n/a =IF(D5<"","R"&MAX(\$B\$1:OFFSET(C5,-1,0))+1,"")

Ola Sandstrom

 Arvi Laanemets Posts: n/a 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

 Gord Dibben Posts: n/a 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

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Larry Wallis Excel Worksheet Functions 4 February 17th 05 10:11 AM peterm Excel Discussion (Misc queries) 1 February 1st 05 10:48 PM Krit Kasem Excel Discussion (Misc queries) 2 January 14th 05 02:55 AM Metric Excel Worksheet Functions 2 December 1st 04 04:21 PM Spunky Excel Worksheet Functions 3 November 23rd 04 04:38 PM

All times are GMT +1. The time now is 09:30 PM. Copyright ©2004-2021 ExcelBanter.