Conditional MAX values

[j_Southern]

The attached workbook has three columns. The first gives the number of a machine. The second gives the cumulative times taken by the jobs run on that machine. The third shows the maximum cumulative time for each machine. I am looking for a function that will give me that third value. Something along the lines of MAX(J:J, IF(OR(I=1,I=2,I=3 4etc)) that doesnt work of course, but I hope gives an idea of what I am looking for. In any case I am looking for something more general as I cant be sure of the values in the first column. Can any one help please?
John

[Andrew-R]

In K4 try:

=MAX(INDEX(($I$4:$I$65=I4)*$J$4:$J$65,0))

And copy down.