I have a large spreadsheet that has some duplicates in it. However, some of the duplicates should remain. If line 1 & 2 are identical in column D & E then one line should be removed. If they are not identical then the line should be skipped. Any suggestions?
seems like this oughta work:
Formula:
Please Login or Register to view this content.
note it is only looking at consecutive lines (i.e. line 1 & 2) ... if there are nonconsecutive duplicates (i.e. line 1 & 3) these will not be deleted.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Sort by Columns D and then E
put a formula in a row two of a new column like =if(and("D1"="D2","E1"="E2"),1,"") and fill down
copy paste the values
then sort by this new column
Delete anything with a 1 in the new column.
This is best done with a macro.
So what columns is your data in and which column is the best place to put this equation?
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks