Lets try another tact. Please refer to my opening post. There are 7
lines of data for 12/21/2005. I want to find and export the HIGHEST
value and LOWEST value for the 4 columns (B, C, D, E) of cells to the
right of all dates that match 12/21/2005. So in this case, -.27 is my
highest value and -.55 is my lowest value. I then want to do the same
thing for 12/22/2005 and 12/23/2005 and so on.

Regarding the array formula, I do not know how to modify it since I'm
unfamiliar with that function. I am very new to Excel, so don't assume
I know anything. ;)


Don Guillett Wrote:
Did you modify the formula to meet your criteria? Did you enter using
ctrl+shift+enter as instructed? Give us an example of the "correct"
answer
you are looking for. OR....

--
Don Guillett
SalesAid Software

"jimbob" wrote
in
message ...

I tried copying the array formula into a col and got #VALUE. And
yes,
I'm looking for the highest HIGH and lowest LOW, which is what I
posted, twice.


--
jimbob

------------------------------------------------------------------------
jimbob's Profile:
http://www.excelforum.com/member.php...o&userid=29107
View this thread:
http://www.excelforum.com/showthread...hreadid=527714



--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=527714