Try this array formula** :

=MAX(IF(A1:A10="A",B1:B10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Or, this normally entered version:

=SUMPRODUCT(MAX((A1:A10="A")*B1:B10))


--
Biff
Microsoft Excel MVP


"Ryan" wrote in message
...
Hi All,

I need to calculate the Max value of A, B, and C in the following matrix.
Please help to advise which function to use:

Materials Days remain
A 7
A 10
B 4
C 5
A 5
B 8
A 2

Max (A) = ?
Max (B) = ?
Max (C) = ?

Thanks & regards,
--
Ryan L.