If you are using this formula to tell you what the next document number
should be and you are entering that in the next blank cell in the column,
then why wouldn't your numbers be in order. Jim's formula looks at the last
cell in the column and gives you the number of that. That is certainly the
simplest.

My formula picked the highest number in the column but assumed you wouldn't
have values in the column that didn't fit your description - it also didn't
pay attention to julian date.

One thing you might look at is adding a little discipline to how you have
your data organized, then you might be able to set up a simple formula to
give you what you want.

--
Regards,
Tom Ogilvy




"Optitron" wrote in
message ...

OK, Jim, your's resulted in 71. Tom, your's resulted in #VALUE!. Here's
more info, The doc#s start in BW9. The julian date will change each
day, so as long as the result says T8XX, I will be happy, unless Julian
date works in Excel. There is also text in some of the cells in that
column when there isn't a doc#, just in case that would conflict. The
doc#s that are in that column are not in order.

This is what I need but don't know how to write it:
Take the highest value of the first four digits and the highest value
of the last two digits and tell me what the next two digits will be. I
just need this in one cell that I have frozen at the top of the page.

5275T800
5275T801
~
5298T898
5299T899
Then next number will be T800 (i'll be able to input the Julian Date)

The reason for all this is that I have to use another application that
uses the doc#s and when I need to order something I have to scan
through Column BW to find out which doc# I need to use next so they are
in sequence.


--
Optitron
------------------------------------------------------------------------
Optitron's Profile:
http://www.excelforum.com/member.php...o&userid=26729
View this thread: http://www.excelforum.com/showthread...hreadid=478472