LinkBack URL
About LinkBacks
In the first empty column, let's say C2
=COUNTIF(A:A,A2) copied down.
Then filter on C for >1 and delete those rows
Does that work for you?
In the first empty column, let's say C2
=COUNTIF(A:A,A2) copied down.
Then filter on C for >1 and delete those rows
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I'm a little confused. So the row goes from A-G can you explain on how to use that range?Originally Posted by ChemistB
If you need to use all columns use COUNTIFS, in H2 copied down
=COUNTIFS($A$2:$A$1000, A2, $B$2:$B$1000, B2, $C$2:$C$1000, C2, ....)
Then Filter on >1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks