Just because the format is Number doesn't mean that the values are numeric.
They can still be text.

One way to convert Text Numbers to Number Numbers is to:
select an empty cell
edit|copy
select your range (all of column C???)
edit|Paste special|check add

If that doesn't make your =max() function work, any chance you're copying your
data from a web site and getting extra characters (especially the HTML
non-breaking space character) in the cell?

If yes, then you may want to try David McRitchie's routine to clean that stuff
up:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Jonibenj wrote:

Dear Bryan,

Yes, the values are numeric. The cells are under the number
formatting.
I don't understand what you mean by a 'helper column'.

Jonathan

--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile: http://www.excelforum.com/member.php...o&userid=17048
View this thread: http://www.excelforum.com/showthread...hreadid=466699

--

Dave Peterson