How do I do de-duplication in Excel 2013, but have the ability to filter on the first occurrence?
Posted on 2014-11-06
I have an excel sheet with approximately 200K of rows in it. I have a single column that I want to de-duplicate against. When I use the default “duplicate” conditional filter in Excel 2013, it highlights all rows which are duplicates.
What I am trying to do is filter out all duplicates, however I want to identify the “first occurrence”. Hopefully this makes sense.
Does anyone know how I can go about this?