Hi there Excel Gurus.

I have a long list of data in two columns, and I want to write a formula on
a different sheet that finds the maximum of all values in column 2 that
correspond to a given character string in column 1. For example.

abc 3
bcd 5
cde 7
abc 2
def 4
abc 4
bcd 8

I need to find the maximum of all values corresponding to abc (ie. 4) or to
bcd (ie. 8) where I can enter the required string in a cell next to my
formula cell. Have tried filtering but if you use =MAX( ) on the visible date
it still uses the entire range.

Hope you get what I mean. Thanks in advance.