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.....
Thanks for any help.
Brad Loomis
Morro Bay, CA
"Hold No Punches.." Rode brings you great shareware/freeware
programs with his honest opinions in this weekly column.
http://freepctech.com/rode
|