Hi
How do i extract or hightlight data that is duplicated or similar for instance - same name, same address but with some variations?example:
Joe Bloggs 11 Slievemoyne Park,
Joe Bloggs 11 Slievemoyne Pk,Joe Bloggs 119 Wandsworth Road,
Joe Bloggs 119 Wandworth Road,
What is this data - Word, Excel, Email addresses, Files or something else? Always pop back and let us know the outcome - thanks
Examine each file and hilite the info you want to keep. Copy/paste (you can also drag/drop if your hand is steadier than mine) it where you wish and you can delete anything else.
Ed.
That's fine Ed if it is a plain text file. Try doing that with Excel worksheet or an Access database and you will soon end up in a mess. Without knowing the format the data is in the question is impossible to answer.
SQL has a query that is particularly designed for this situation but the data needs to be in a structured data base, not an unstructured form like a text file.
Stuart
Hi
Sorry should have said it is an excel spreadsheet! I know its easy to delete duplicates only the thing is i need to eliminate all BUT duplicates - i need to show all duplicates for compliance reporting. I tried conditional formating but it only extracts exact duplications. Is there anything else I can do to shortcut this?
