I was asked today to help someone dedupe their data…since I was, “good at excel”. I was flattered by their compliment, but also embarrassed because I’d never heard the term in my life. After being told it meant de-duplicate, I knew I was the man for the job! (because it literally requires a single button… the “remove duplicates” button under the data tab). And I also learned a new term: de-dupe.
So hopefully this explanation of my short-lived embarrassment helps save you from a similar situation. Meanwhile I’m going to keep calling it: remove duplicates.