Delete duplicates based on multiple column data - Mailing List

[Joni]

Dear All

Please could you help with this:
I have four mailing lists containing 27000 rows which contain school names and addresses.
I need to delete out any duplicates in each list - but the duplicates must be based on both the Name and Postcode.
There are many occasions where a school will have the same name as another, but be in different parts of the country, or have the same postcode, but be at opposite ends of the street, so they should only delete if they duplicate on both.
Example data below....I am currently doing this manually so I would appreciate help!

1. School A Sheffield SH5
2. School B Liverpool LA1
3. School A London DN2
4. School C Kent ME12
5. School B Liverpool LA1

I would expect to lose either line 2 or 5 as these are exact matches.
(Forgive my inaccurate postcodes, I've just tried to produce easy examples)

All I know how to do is use conditional formatting to show me the duplicates, but then I have to go through deciding which to keep. I have seen various hints and tips involving VB but as I know nothing about this I can't resolve the issue...
Help very welcome.

Thank you

[JBeaucaire]

The Data > Filter > Autofilter is perfect for this task.

1) Create a "key column" in your data that concatenates the school name and the post code into one cell
2) Create a "dupe check" column with a formula that counts how many times the value in each row appears in the data down to that row.
3) Use the AutoFilter to see only the rows with a dupe check value greater than 1
4) Delete all visible rows
5) Turn off the autofilter and clear your helper columns.

[Joni]

Thank you for your help so far, although I've been able to set up the data as suggested, the Countif doesn't seems to be highlight rows that aren't duplicates. I only ran it for the first 38 lines as a trial to start with, and have attached the results of this. Further help would be appreciated.

Thank you!

[martindwilson]

it should look something like this

[Joni]

All good so far, thank you for the new example.