=MAX(A1:B200)

look at MIN, LARGE and SMALL as well


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"JRod" wrote in message
...
I have imported stock data including open, high, low and close. I need to
find the tops and bottoms that occur over the course of time using the
highs
and lows, however how do I find one set of data when it is now in two
columns?
--
JRod