| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max-function with alphanumeric values?!?
the max-value of the the following entries is 02/001
01/001 01/002 01/003 02/001 I can solve this with a customized function, but I can't believe that this can't be solved with a worksheet function. Tom "Tom Ogilvy" schrieb im Newsbeitrag ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Text from Alphanumeric values | Excel Discussion (Misc queries) | |||
| Removing text from Alphanumeric values | Excel Worksheet Functions | |||
| VLOOKUP with numeric and alphanumeric values | Excel Discussion (Misc queries) | |||
| Need to test for alphanumeric value and write numeric values to ce | Excel Worksheet Functions | |||
| how do i enter alphanumeric values? | Excel Discussion (Misc queries) | |||
Threaded Mode
