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!

Please post some sample data

Regards,
--
AP

"Bobby" a écrit dans le message de
...
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!

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?


"Ardus Petus" wrote:

Please post some sample data

Regards,
--
AP

"Bobby" a écrit dans le message de
...
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!

Apply autofilter instead, find the top value and it will show the date/times
as well


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Bobby" wrote in message
...
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?


"Ardus Petus" wrote:

Please post some sample data

Regards,
--
AP

"Bobby" a écrit dans le message de
...
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!

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!

"Peo Sjoblom" wrote:

Apply autofilter instead, find the top value and it will show the date/times
as well


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Bobby" wrote in message
...
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?


"Ardus Petus" wrote:

Please post some sample data

Regards,
--
AP

"Bobby" a écrit dans le message de
...
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!