Forum Discussion

SuzyH's avatar
SuzyH
Copper Contributor
May 17, 2022

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?

Resources