What is the max in your sample data - does 02 take precedence over any 01 in
the first two places or is the max the highest of the last 3 digits.

Can a helper column be used next to this column?

--
Regards,
Tom Ogilvy

"Tom" wrote in message
...
Coolio

I suppose that the Code-function fails... I have numbers like this:

01/001
01/002
01/003
02/001

Tom



"Colo" schrieb im Newsbeitrag
...
Hi Tom,

Here is an easy way...please use code function like =CODE(A1), so you can
use MAX function.


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


"Tom" wrote in message
...
Hi

I have a column with alphanumeric data. The max function works only with
numeric values. How to calculate the max-value of alphanumeric values?

Tom