'Using MAX in a Filter range in google sheets

 Column A         Column B

    Joe             23
    Tom             102
    Sally           99
    Tom             111
    Joe             67

How to I output:

Tom           111

This isn't working.

=filter(MAX(B1:B,A1:A="Tom")

I am just adding text here because it is saying most of my post is code........blah blah blah.

Solution 1:^[1]

here's how you do it with max and filter:

=FILTER(B:B, A:A="Tom", B:B=MAXIFS(B:B, A:A, "Tom"))

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	player0