Matching Subtotals

B

Bobby

Hello Group
I have a data sheet with hourly values. I have used subtotals to find the
monthly maximum in col AA. In columns C:Z I would like the corresponding
values to the monthly max that is found in AA.
Thanks!
 
B

Bobby

OK Ill try
A condensed example....Hourly Temp Data
Date/Time WndSpd WndDir RelHum Temp

I do subtotals for each month using Max of Temp
So the subtotal line only has the Max Temp for the month. I would like to
have the other values for that Date/Time where the max occured.
So theat when I click the 2 on the subtotals that all the data will be
filled in for the date/time of the monthly max.
Does this help?
 
B

Bobby

Thanks Peo,
With subtotals I get a matrix for the entire year that I copy/paste
elsewhere. I am not that familiar with AutoFilter, how can I still get this
matrix?
Thanks again!
 
Top