Sage 100

Have a client with significant number of duplicate customers.  Currently, we are dumping records into Excel, then using a pivot table to locate duplicate fields.

Does any one have a more efficient way to identify suspected duplicates?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

The hard part is for your customer to define what a "duplicate" is. If there are one or more fields that - if are an exact match - you could use this Excel/Power Query method. If your match criteria is a bit "fuzzy" then Power Query provides Fuzzy Inner Joins with threshold matching options for what defines a match.

------------------------------
Dan Burleson
Software Consultant
Connex Software
------------------------------