I have a worksheet similar to the following:
A B C D E
Year Month Day Hour Value
2000 1 15
2000 1 20
2000 1 11
2000 2 18
2000 2 3
2000 2 30
2000 3 14
2000 3 5
2000 3 6
The worksheet continues on including values for every hour of every day
until the present time. I want to summarize on another worksheet the maximum
value in column E for each month for each year.
Year/Month 1 2 3
2000
2001
2002
Any suggestions?