| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete duplicates
I love this feature in excel, but it would be nice to be able to know which
ones are deleted. Some of my records are more complete than others and I would like to ensure that the more complete record is retained. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete duplicates
My limited testing seems to show that the first of each duplicate is
retained. Make sure the "more complete" records are at top of sheet. Gord Dibben MS Excel MVP On Thu, 18 Mar 2010 09:42:04 -0700, DogmaDot wrote: I love this feature in excel, but it would be nice to be able to know which ones are deleted. Some of my records are more complete than others and I would like to ensure that the more complete record is retained. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete both duplicates | Excel Discussion (Misc queries) | |||
| Delete duplicates in a row | Excel Worksheet Functions | |||
| Delete duplicates? | Excel Discussion (Misc queries) | |||
| Delete Duplicates | New Users to Excel | |||
| Delete duplicates | Excel Worksheet Functions | |||
Linear Mode
