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