Forum Discussion
SuzyH
May 17, 2022Copper Contributor
How to filter out duplicates in excel from multiple columns
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 earlie...
Riny_van_Eekelen
May 18, 2022Platinum Contributor
SuzyH I would use MAXIF in a helper column. Then filter for TRUE. See picture below and file attached.