Help with a report

[dpiekarz]

Test1, OK, 20040409, 16:00, 16:01, 105, 9
Test1, OK, 20040409, 16:00, 16:01, 101, 8
Test1, OK, 20040410, 16:00, 16:01, 109, 7
Test1, OK, 20040410, 16:00, 16:01, 111, 11

I have a excel file that is setup as above. What i would like to do i
setup a report that shows the following.

TEST1:
Date, AVG1, AVG2
20040409, ,
20040410, ,



I want AVG1 to be the average of column F for each day if column B say
OK. AVG2 is the same for column G

This info comes from a comma delimited log file and the date field wil
continue to chang

 

[Bernie Deitrick]

dpiekarz,

Use a Pivot Table, use the Test1 parameter as your page field, OK as a row
field, Date as a row field, and AVG1 and Avg2 as your data fields set up as
columns.

HTH,
Bernie
MS Excel MVP