My colleagues have taken over an exisiting business that lacked organization
& leadership. There were numerous client lists which have been merged onto an
Excel sheet. The dilemma now is that there are multiple duplicates of the
clients on the Excel sheet. They would like to know the easiest and most time
effecient way to delete the duplicates or merge them together so that the
client list has all pertinent info. For example, this is what their client
list may look like currently:
No. Client Address
Phone
1. Joe Schmoe 122 Ocean Ave., Newport Beach, CA 92660 (949)888-1111
2. Joe Ocean Ave. Newport Beach
(949)888-1111
3. Joe Schmoe 122 Ocean Ave., Newport Beach 92660
4. Jenny B. Sunset St., Tustin, CA

5. Jenny Brown 3 Sunset St. Tustin 92626
(714)888-1111
6. Jenny Brown 3 Sunset St. Tustin, CA 92626
(714)888-1111

FYI: They have attempted implementing Access but it still brought up the
duplicates.

There has to be an easier way than manually deleting each duplicate and
keeping only the one(s) they need. If possible, try to use "laymans" terms as
I myself am not savvy w/Excel (just helping some friends). Thanks!

Hi,
check CPearson web it has the solution you are looking for

http://www.cpearson.com/excel/Duplicates.aspx

http://www.cpearson.com/excel/deleting.htm

"guinessgirl90" wrote:

My colleagues have taken over an exisiting business that lacked organization
& leadership. There were numerous client lists which have been merged onto an
Excel sheet. The dilemma now is that there are multiple duplicates of the
clients on the Excel sheet. They would like to know the easiest and most time
effecient way to delete the duplicates or merge them together so that the
client list has all pertinent info. For example, this is what their client
list may look like currently:
No. Client Address
Phone
1. Joe Schmoe 122 Ocean Ave., Newport Beach, CA 92660 (949)888-1111
2. Joe Ocean Ave. Newport Beach
(949)888-1111
3. Joe Schmoe 122 Ocean Ave., Newport Beach 92660
4. Jenny B. Sunset St., Tustin, CA

5. Jenny Brown 3 Sunset St. Tustin 92626
(714)888-1111
6. Jenny Brown 3 Sunset St. Tustin, CA 92626
(714)888-1111

FYI: They have attempted implementing Access but it still brought up the
duplicates.

There has to be an easier way than manually deleting each duplicate and
keeping only the one(s) they need. If possible, try to use "laymans" terms as
I myself am not savvy w/Excel (just helping some friends). Thanks!