View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DDD DDD is offline
external usenet poster
 
Posts: 24
Default Easy for the experts: Lookup,index,match....

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