Feb 20 2019 01:27 AM - edited Feb 20 2019 01:29 AM
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?
Feb 21 2019 11:35 AM
Hi @Nick_S,
Fortunately this is a really easy thing to do using Excel's Remove Duplicates data tool:
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.