Find a maximum value using XLOOKUP

[Shippior]

I want to find the maximum value in column B that corresponds to "abc" in column A. Column B has it's data in any possible order but the combination of column A and Column B is always unique. Next to that Colum B is exported as text and not as number.

Column A	Column B
abc	3
abc	2
def	6
abc	5
def	4

 

[Shippior]

By the way I do not want to use XLOOKUP per se but it was the solution direction I was getting into as MAXIFS does not work with VALUE as far as I have tried.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TAKE(SORT(FILTER(B2:B6,A2:A6="abc"),,-1),1)

 

[Shippior]

Hi & welcome to MrExcel.
How about

=TAKE(SORT(FILTER(B2:B6,A2:A6="abc"),,-1),1)

Thanks, this works. Apparently SORT isn't limited to numbers and I was too focused on MAX. Is there a way to change the title? The title does not represent the problem so if someone else also has this problem they will never find this answer.

 

[Fluff]

You're welcome & thanks for the feedback.