Looking for a formula that would work like MAXIF
 

or this in the first row, copied down
=MAX(IF($F$2:$F$10=TIME(ROW(),0,0),$G$2:$G$10))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nicholas" wrote in message
...
I have Excel 2003, that I am trying to find the max number for a certain
set
of time.


Time,Count
1:00,14
2:00,15
3:00,20
1:00,7
2:00,8
3:00,10
etc..

I need to know what is the max value for 1:00, 2:00, 3:00,etc.

Thanks in advance.