Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check for duplicate items and delete them
Anyone have a way to check for duplicate cells in multiple rows and
automatically delete them? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check for duplicate items and delete them
In an adjacent column, enter this
=COUNTIF(A$2:A2,A2) where A2 is the first cell in the series you want to check. Copy this down as needed. Use AutoFilter to remove all rows where the value is 1. -- HTH, Barb Reinhardt "chanse44" wrote: Anyone have a way to check for duplicate cells in multiple rows and automatically delete them? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check for duplicate items and delete them
you can also use the advanced filter to automatically just show you the
unique records. it's under Data, Filter, Advanced filter. Highlight which column you want to filter for unique records. Click the Unique records only box to filter the duplicates then either paste the new set of data on the same column or in a new column. I suggest you paste it on a new location so you can verify if it really worked. "chanse44" wrote: Anyone have a way to check for duplicate cells in multiple rows and automatically delete them? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check for duplicate items and delete them
Thank you both so much but neither one of these worked, aagh!!!!
"Barb Reinhardt" wrote: In an adjacent column, enter this =COUNTIF(A$2:A2,A2) where A2 is the first cell in the series you want to check. Copy this down as needed. Use AutoFilter to remove all rows where the value is 1. -- HTH, Barb Reinhardt "chanse44" wrote: Anyone have a way to check for duplicate cells in multiple rows and automatically delete them? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check for duplicate items and delete them
That technique has worked for lots and lots of people.
You may want to explain why it didn't work for you. chanse44 wrote: Thank you both so much but neither one of these worked, aagh!!!! "Barb Reinhardt" wrote: In an adjacent column, enter this =COUNTIF(A$2:A2,A2) where A2 is the first cell in the series you want to check. Copy this down as needed. Use AutoFilter to remove all rows where the value is 1. -- HTH, Barb Reinhardt "chanse44" wrote: Anyone have a way to check for duplicate cells in multiple rows and automatically delete them? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return True/False to check duplicate items in a range with one for | Excel Worksheet Functions | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
Duplicate and unique items in 2 lists | Excel Discussion (Misc queries) | |||
How to get rid off duplicate items? | Excel Discussion (Misc queries) | |||
How do I do a count sum that ignores duplicate items | Excel Worksheet Functions |