Thanks mama, but I guess I was not clear enough.

The input data is not finite and varies day to day month to month. What I
was looking for was how to search all of the 09/01/06 entries (between 300
and 1000 entries) for a max and min, then write that date and it's
corresponding min/max values - then continue to the next date in the data
09/02/06 and search all that date for min/max - write that date and the
min/max --- continue until the data runs out about 10K to 13K entries per
month... Does that make sense?

Take care

"Teethless mama" wrote:

On sheet 2

B2 =MIN(IF(Sheet1!$A$2:$A$5=Sheet2!$A2,Sheet1!$C$2:$C $5))
C2 =MAX(IF(Sheet1!$A$2:$A$5=Sheet2!$A2,Sheet1!$C$2:$C $5))

ctrlshiftenter (not just enter)
Highlight B2 & C2 and copy down as far as needed



"DDD" wrote:

Good Day:

Data Input is as follows:

A B C
Date Time Value
09/01/2006 19:25:37 8.89
09/01/2006 19:29:37 8.23
09/01/2006 19:33:37 8.14
09/01/2006 19:37:37 8.22
. . .
. . .


The data set is quite large and is continuous for one month of data. I would
like to get an output that looks like the following (on a sepearate
worksheet):

A B C
Date Min. Max.

09/01/2006 8.14 8.89
09/02/2006 6.54 9.76
09/03/2006 7.01 8.46
. . .
. . .

Thanks in advance for your assistance. DDD