ExcelBanter - View Single Post

So what did you try?

jimbob wrote:

I can't get it to work. Maybe I wasn't clear, so here goes......

Col A has the Date, Col B has the Open for that hour, Col C has the
High (ONLY for that hour!), Col D has the Low (ONLY for that hour) and
Col E has the Close for that hour. I want to find the Low for the DAY
and the High for the DAY. To do this, all 7 lines for each day must be
compared to find the lowest low and highest high.

I am not that well versed in Excel, so let me try to say it the way I
would describe it to someone....

"For all the entries that have the same date, find the lowest low and
highest high in cells B2 thru E8, then export those values into another
col or worksheet with the appropriate date". *Note that the next date
starts on row 9, then the third date starts on row 16 and so on. There
are 7 rows of data for each DAY.

Thanks again for all your help, I really appreciate it.

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

--

Dave Peterson