Hello,
I've seen to run into a problem. I am trying to delete all of the duplicate rows within an excel sheet. However, when using a filter to display only unique values or removing all duplicate values functions from excel it still leaves the original row. How would I go about deleting all the rows that contain duplicate data leaving only the unique rows. Any help is appreciated! Thanks in advance!
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
Is there a specific column that would be unique among A-G (i.e. column A is a list of unique names) or does it really depend on A+B+C+D+E+F+G being unique?
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks