Conditional Filtering: remove duplicates only when both columns are duplicates (Excel 2019)

Occasional Visitor

Dear community,


I have downloaded observation data of insect species and want to delete duplicates of coordinates in Excel 2019, but only if the year is the same as well. If the year of observation is different, I don't want to remove these duplicates. 'Coordinates' and 'year of observation' are in separate columns. Is there any fast way to do this?

1 Reply

Hi @Nick_S,


Fortunately this is a really easy thing to do using Excel's Remove Duplicates data tool:

  • Highlight your data
  • Click on Data > Remove duplicates
  • Ensure year and coordinates are checked
  • Click OK

Excel will automatically delete the duplicates. Please note, since Excel deletes the data, you may want to first make a copy of the sheet before using remove duplicates to preserve your original data.


2-21-2019 1-32-14 PM.jpg


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies