Looking for a formula that would work like 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.
 
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))
 
or this in the first row, copied down
=MAX(IF($F$2:$F$10=TIME(ROW(),0,0),$G$2:$G$10))
 
Back
Top