Finding Maximum values (Excel 2010)

[mzalikhan]

Hi all
Here is my question. I have an hourly met data including temperature and many other parameters for whole year. I have to find the maximum daily temperature. The problem is that i have random number of observations each day. Someday i have 18 observations, someday 24 while others 15 etc.

A typical example of data is like this; in Column A (Red) is Date/Time, in B (Black) is the TMP observation.

1/1/2009 1:00 25
1/1/2009 2:00 34
1/1/2009 3:00 24
1/1/2009 7:00 25
1/1/2009 12:00 24
1/1/2009 13:00 21
1/1/2009 17:00 14
1/1/2009 19:00 15
1/1/2009 23:00 54
1/2/2009 3:00 32
1/2/2009 4:00 32
1/2/2009 10:0042
1/2/2009 12:00 52
1/2/2009 13:0013
1/2/2009 14:00 13
1/3/2009 6:00 31
1/3/2009 7:00 13
1/3/2009 13:00 45
Any kind of help in finding technique for finding Max daily TMP (i mean either macro or "dragging" and not one by one) would be appreciated.

Peace.

 

[Sektor]

=max(b:b)

 

[mzalikhan]

Thank you Sektor. But i have 10 year data for 15 observation sites. So imagine (15 sites x10 years x365 days). That is why i asked for some formula that i can drag in a parallel column, it should detect the change of date in column A and find the maximum TMP against the change in B display it in C. Later i can filter the Max TMP values against date. I hope its explained better now.

Peace.

 

[mzalikhan]

The problem is that the observations are hourly but i dont have 24 observations each day. So cant just type MAX(b:b) after each 23 rows and drag it through the column.

 

[mzalikhan]

Anybody there?