looking for a formula that would work like a maxif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top