Make a list of the numbers you want and use this ARRAY formula that must be
entered using ctrl+shift+enter.

=MAX(IF($F$2:$F$10=F2,$G$2:$G10))
--
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.