Maximum hourly temperature of the day

mzalikhan said:

Hi everybody. I have a 10 year daily meteorology data. Met parameters are recorded hourly. So i have 24 readings of temperature a day. What i want is to extract

1- Maximum Daily temperature

2- Temperature at 7:00 AM

How can i do that?

Peace.

Click to expand...

Try this...

Times in column A and temps in column B.

D2 = 7:00 am

Array entered**:

=MAX(IF(A2:A100=D2,B2:B100))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

I imagine you probably have 10's of 1000's of records. This method is more efficient...


Formula entered in D4:

=DMAX(A1:B10,B1,D1:D2)

Thanks T.Valko
Actually i got the 7:00 AM data by simply using filter.

However mean while i just came to know that some date/time data is missing.

So now before going to extract daily maximum, i think i have to fill up the missing date/time rows???