Filter by maximum value in a field/column using Advanced Filter in Excel

I need to filter a field by maximum value, but I need to use advanced filtering in order to show the result in another sheet. I tried using max, > etc alone but didn't work.

The field in question is numeric and I need to show the row that contains the maximum value in that column. I know how to filter text and how to use <, >, <=, >=, and and or conditions, but I can't figure out how to do things like max, min etc.

I can't use a Pivot Table since I need to filter by another column by contains text and I'm using wildcards, and I already searched inside all pivot table options and could not find anything to filter rows by text, so that's why I'm using advanced filtering. I'm using Excep 2002.

the key is to create a formula that returns TRUE/FALSE.

In G2 I put:

=A2=MAX($A$2:$A$15)

Then in the advanced search I add my List Range: A1:B15

Then I include G1 and G2 in my Criteria Range. G1 must be blank.

I decided to copy to D1:E1.