We have a spreadsheet at work with 1800 names and addresses on of people who have to be contacted. We are to be sent another with probably the same number of names on. Is there anyway we can check for duplicate entries?
Ideally we would be left with only names and addresses of people we have yet to contact. Incase you need to know the forenames are in one column, surnames in another, street in another, town in another, etc.
If you can help, very simple language please. I'm not very good at excel. We are not allowed to download anything either.
Add (copy and paste) the new details to the bottom of your existing table. Make sure that labels for Forenames, Surnames etc. are entered right at the top of the list (Row 1). Select all of the data, then from the Menu Data > Filter > Advanced Filter.
Click Copy to another Location. In CopyTo enter a different range (e.g. F1) that does not overlap your existing table. Tick Unique records only then click OK. This will remove duplicate entries.
How do I know which names you have not yet contacted?