sorting duplicate data without removing or deleting

January 23, 2013 at 05:59:04
Specs: Windows 7
How do i extract or hightlight data that is duplicated or similar for instance - same name, same address but with some variations?

Joe Bloggs 11 Slievemoyne Park,
Joe Bloggs 11 Slievemoyne Pk,

Joe Bloggs 119 Wandsworth Road,
Joe Bloggs 119 Wandworth Road,

See More: sorting duplicate data without removing or deleting

Report •

January 23, 2013 at 07:39:09
What is this data - Word, Excel, Email addresses, Files or something else?

Always pop back and let us know the outcome - thanks

Report •

January 23, 2013 at 09:53:20
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.

Report •

January 23, 2013 at 12:32:38
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.


Report •

Related Solutions

January 24, 2013 at 01:32:03
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?

Report •

Ask Question