Sorry, I meant to say 7 and 30 day maximums.

My collum headings would be something like:

Date Temp Wind Speed Precip etc.

Im not sure if that is clear enough, I hope so.

Thanks again!

"West22" wrote:

Im stumped and I hope someone can help me.

I have 30 years of daily weather data and I am trying to write a formula to
extract 7 and 30 maximums. I need to do this for several workbooks.


Maybe I need to use SQL?

Can someone help me?

Thank you tons.