| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Duplicates in Excel - Databases
I have put my Palm Pilot contacts in Excel. The fields are not all the same
and there are many duplicates. Not all same names are exactly identical. I want to run a formula that will automatically delete duplicates if just the names (first and last) are the same. Some info in the rest of the lines may be different for various reasons. I don't care. Rather just have one entry for everyone. Does anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting Duplicates in Excel - Databases
In Excel-Data tabData Tools Command GroupRemove Duplicates. Select the
column(s) you have duplicates in and want removed. "DColeman" wrote: I have put my Palm Pilot contacts in Excel. The fields are not all the same and there are many duplicates. Not all same names are exactly identical. I want to run a formula that will automatically delete duplicates if just the names (first and last) are the same. Some info in the rest of the lines may be different for various reasons. I don't care. Rather just have one entry for everyone. Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting (almost) duplicates in Excel | Excel Worksheet Functions | |||
| Merging duplicate entries in Excel or deleting the duplicates (Exc | Excel Worksheet Functions | |||
| Deleting duplicates in Excel | Excel Worksheet Functions | |||
| Copying data to excel and deleting duplicates | Excel Discussion (Misc queries) | |||
| Deleting duplicates | Excel Discussion (Misc queries) | |||
Linear Mode
