I have a report that I'm trying to remove duplicate rows but I was the macro to look all the columns before deleting the entire duplicate row. I have looked at different macros and they delete rows based on one column but that doesn't work for me because in my data a lot of the columns are the same. I just want the ones that are true duplicates to be deleted.
Concatenate all columns into one and use that column as the basis for you comparison.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
The problem is that I need all the columns separated since I run couple of other macros to get specific information for later use. I usually just manually remove the duplicate row but its very time consuming.
No one said to adjust the existing data - simply create a new column that is a concatenation of the others.
(this concatenation column need not be permanent - it could be created temporarily at run time and exist purely for sake of duplicate removal)
I'm not really sure how to do that.
Post a small yet representative sample file that reflects both "before" & "after"
The premise is quite simple - if you have data in Columns A:D and want to delete duplicate rows (duplicate means A:D are the same) then you create Column E which is a concatenation of A:D ... where the values in E are the same you have duplicates.
ok I concatenated the columns I 'm trying to use this formula to delete the duplicates but it keeps deleting the whole sheet. My concatenated column is BA.
Please Login or Register to view this content.
Last edited by Leith Ross; 10-22-2010 at 06:31 PM. Reason: Addded Code Tags
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks