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
|