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?