I was able to sort of do what you're after using helper columns & a
pivot table. I added 2 columns to calculate the max of each row (MAX)
& the min of each row (MIN) respectively, and one col to pick up the
last close, DayClose (if the date in each row < equal to the date in
the next, then enter the date). I then did a pivot table with dates in
the LH col, and in the data field I put Max of Max col and the Min of
Min col, and the sum of DayClose col.

Data came out as follows:

Date Data Total
12/21/05 Max of Max -0.27
Min of Min -0.69
Sum of DayClose -0.59
12/22/05 Max of Max 0.14
Min of Min -0.73
Sum of DayClose 0.03
12/23/05 Max of Max 0.36
Min of Min -0.24
Sum of DayClose 0.03

Not exactly what you want, but close. You could reformat manually if
you needed this in rows only. I don't know whether there is a way to
get a Pivot table to place the field data in rows vs columns.

HTH

---GJC


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