It depends on how your data is organized. To get the minimum or maximum of a
range, you can use:

=min(a1:a100)
=max(a1:a100)

If your data is organized some other way, let us know.

--
Regards,
Fred


"Stock Help" <Stock wrote in message
...
I would like to know how to show the high value and low value of a cell that
is showing the trade by trade of a stock.