Try these:

=MIN(A1:A100)

=MAX(A1:A100)

--
Biff
Microsoft Excel MVP


"NassauLIMan" wrote in message
...
I have a column of numbers. Instead of sorting and manually ID's the
highest
and lowest value what is the function in Excel that I can use to have it
look
at the column of numbers and tell me the highest and lowest value?

I am sure it is a simple function but for the life of me I can not find it
in the help for the program