| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
database - looking for dups
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dups from 2 worksheets | Excel Worksheet Functions | |||
| highlight dups in one of two columns | Excel Worksheet Functions | |||
| Validation - no dups and text length requirement | Excel Worksheet Functions | |||
| limit validation list to prevent dups | Excel Discussion (Misc queries) | |||
| Identifying Dups in different ranges | Excel Worksheet Functions | |||
![sos-DC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
