How to filter out duplicates in excel from multiple columns

[SuzyH]

I have a list with claim numbers in column A. Column B contains the version number of the claim 1, 2, 3, etc. I have identified the duplicate claim numbers in A, and now need to filter out the earliest versions. For example if column B has 4 instances of a claim number I need to keep only the last (highest number) instance. Is there a way to filter for this?

[#2]

@SuzyH I would use MAXIF in a helper column. Then filter for TRUE. See picture below and file attached.