looking for a formula that would work like a maxif
 

Thank you so much, that worked great.

So much still to learn. :)

"Bernard Liengme" wrote:

With the times in A, the numbers in B, and a time (such as 1:00) in D1
use =MAX(IF(A1:A6=D1,B1:B6))
This is an array function and must be entered with CTRL+SHIFT+ENTER not just
Enter - Excel will enclose it in {}
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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.