G
Guest
This there a way to search for dups in an Excel database.
The database is over 2,000 rows
With a visual spot check I notice there are dups (sometimes as many as five
rows.
Part of the problem will probably be that the dups are not totally identical
One group might be
123 Main St
123 Main #220
123 E Main St
123 E Main
123 E Main Street
123 East Main Street
So it is not simply a matter of finding the an exact match. And there are
many other groups with different addresses.
Can anyone help?
The database is over 2,000 rows
With a visual spot check I notice there are dups (sometimes as many as five
rows.
Part of the problem will probably be that the dups are not totally identical
One group might be
123 Main St
123 Main #220
123 E Main St
123 E Main
123 E Main Street
123 East Main Street
So it is not simply a matter of finding the an exact match. And there are
many other groups with different addresses.
Can anyone help?