Alpha-Numeric Numbering

Hi,

I have an alpha-numeric numbering scheme as follows:

Cell M42 = C
-- Represents the revision letter, in this case, Rev. 'C'

I thought I could do a nest text formula, kind of like the following, but it's not working well:

=TEXT($M$42,"")&TEXT(E68+1,"##")

The intent was to drag this down the column, as I would be able to do if I had:

E68+1 by itself.

Except now, I want to have the Rev letter in front of it.

How can I modify?

Thanks

Don't use TEXT in the first part:

=$M$42&TEXT(E68+1,"##")

Hi NBVC,

This seems to work well for the first cell.

Now, in cell E68, I have "C1"
By having:

=$M$42&TEXT(Q42+1,"##")

Cell Q42 is an empty cell


Applying the, =$M$42&TEXT(E68+1,"##") function, results with "###"

How to modify?

Thanks

Can you post more representative sample of what you have and exactly in what cells, and what your expected results are? Perhaps an attached .xls sheet?

Hi,

Attached is a modified version of what I'm trying to do.

As you will see, my Rev letter is in cell F8 & the result is in cell C14

Now, I'm trying to use the same principle, but the function in C15 is not "reading" C14 properly. Is this because it's considered text?

Regardless, how do I get it to count & still be able to reference my Rev letter?


Thanks

How about?

=$F$8&TEXT(ROWS($G$8:$G8),"##")

Hi NBVC,

This last function works great!!!

Now, I just realized that I have another issue.


If I want to skip a handful of rows, such as putting headers in, how can I continue counting?

For example,

I now have my counter from C1 to C5

I skipped a handful of rows to put a header in & in this instance, to represent a different sheet. I'm using this for a Revision log.

Let's say in Cell C24 of my example file, I want to continue the count, which I should have, C6

What's the trick to do this?

Thanks again - You've been a huge help....

If none of those inserted headers begin with C, then sub the formula I gave you already with:

=$F$8&TEXT(COUNTIF($C$13:$C13,"C*")+1,"##")

copied down.

If you overwrite any with other strings, not starting with C, then the numbering will continue on below.

Hi,

This works great too, I think I need a wildcard function.

Is this it?

If I replace, "C*" within your function with "&*$F$8*&"

Sorry, I should have done that already in the formula:

=$F$8&TEXT(COUNTIF($C$13:$C13,$F$8&"*")+1,"##")

Hi NBVC,

,$F$8&"*" - Works great too!!!

Jeff - Forum Guru also assisted me & gave me the following which also works great!!!!

"*"&$F$8&"*"


Thanks to both of you....