Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 21st 05, 07:45 PM
Colleen B
 
Posts: n/a
Default 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   Report Post  
Old February 21st 05, 08:35 PM
Ola
 
Posts: n/a
Default

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

Ola Sandstrom

  #3   Report Post  
Old February 21st 05, 08:38 PM
Arvi Laanemets
 
Posts: n/a
Default

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   Report Post  
Old February 21st 05, 09:17 PM
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating number of letters in a string ... Larry Wallis Excel Worksheet Functions 4 February 17th 05 10:11 AM
How do I add an auto number to a worksheet peterm Excel Discussion (Misc queries) 1 February 1st 05 10:48 PM
assign auto number and auto date Krit Kasem Excel Discussion (Misc queries) 2 January 14th 05 02:55 AM
Create an Auto Number Metric Excel Worksheet Functions 2 December 1st 04 04:21 PM
only include cells beginning with specified character or number Spunky Excel Worksheet Functions 3 November 23rd 04 04:38 PM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017