MAX, MAXA functions
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
|