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 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?
1 Reply
Sort By
- Riny_van_EekelenPlatinum Contributor
SuzyH I would use MAXIF in a helper column. Then filter for TRUE. See picture below and file attached.