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!