sorting duplicate data without removing or deleting

January 23, 2013 at 05:59:04
Specs: Windows 7

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,


See More: sorting duplicate data without removing or deleting

Report •


#1
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 •

#2
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.
Ed.

Report •

#3
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.

Stuart


Report •

Related Solutions

#4
January 24, 2013 at 01:32:03

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?

Report •


Ask Question