You could use this formula: =MAX(IFERROR(E2:E15000,0))

It must be "array-entered", that is, by pressing Ctrl-Shift-Enter rather
than just Enter.

--
Jim
"Dave F" wrote in message
...
I have a column of data, E:2:E15000. These data are either numbers,
text, or logical errors.

I want to find the maximum value of the numbers in this column. Both
MAX and MAXA give #VALUE! errors, presumably because of the text and
logical errors in this column.

Is there another function that will return the maximum value?

Dave