Finding a maximum Value against criteria

[Timmy Mac1]

My data source is a large table of subjects with various values.

I have a list of unique subjects and what I want to do is return the largest value to be found against each subject in the table, ie the maximum value of the cells in COL B where the values in COL A match the cell criteria.

Can anyone help me with a formula?
Many thanks in advance

[mangesh_yadav]

Column A1:A10 has subjects and B1:B10 has values
Cell C1 has the subject for which you want to find the max
Use
=MAX(($A$1:$A$10=C1)*($B$1:$B$10))

press control + shift + enter


- Mangesh

[Timmy Mac1]

Thanks Mangesh

That does the trick!