Try this:
None array enter

=MAX(INDEX((A1:A7="A")*B1:B7,))

or
=SUMPRODUCT(MAX((A1:A7="A")*B1:B7))



"Ryan" wrote:

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.