Look at the MIN() and MAX() functions of Excel. They should do what you
want. Just select the entire range of cells to check, including future
cells. There are also an Average() function in case you want that also.
Peter
-----------------------------------------------
The NoSpin Group
[log in to unmask]
-----Original Message-----
I know there are a couple of Excel gurus on this list and since I'm a
mathematical moron I'll pose my query here. I am trying to use the Large and
Small functions,not at the same place of course, to get those values from
one column on Sheet2 to cells on Sheet1. I'm looking for High and low prices
of a large list of values. It is Column B starting at cell 2 running through
B202 at this point. The quantity of cells increases each month so it needs
to be fluid. I want those Large and Small values to be in Sheet 1, B8 for
Large and B9 for Small. I'm afraid I don't understand the Array thingy.
Mathematical moron.....
Brad Loomis
"Hold No Punches.." Rode brings you great shareware/freeware
programs with his honest opinions in this weekly column.
http://freepctech.com/rode
|