If your data isn't presently in a table, then format it to be a table. This will quickly include a filter button at the very best of every table column. I discovered a fresh macro that promised to automate a particularly bothersome endeavor, help save me a bunch of time https://www.customguide.com/excel/excel-remove-duplicates