Delete duplicates based on if multiple Column data is the same

[stein7]

Hey All,

I am using a macro that imports raw data from one sheet called “Daily Input”, to another Sheet called “Database” where it is stored neatly and organized.

I need to incorporate logic to delete dups. Where, if in Sheet "Database" 2 or more rows have identical data in Column A, C, F, G, H (Date, Client, Side, Size, Item Code), it is clearly a dup, so the macro delete those duplicate rows from Sheet "Database" and only keep one unique row. My data in "Database" starts on Row 3 and last row is dynamically increasing

The real spread sheet I am using has +20,000 rows so Looping could make the code runtime long, scripting dictionaries or other ways may work best I just can’t figure it out…

Many thanks Excel Forum community!

[Fluff13]

How about

Please Login or Register  to view this content.

[stein7]

Thanks for looking at this Fluff, this is definitely the way I want to go about it. Code breaks and doesn't work... FYI to clarify the code only needs to run on Sheet ("Database"), and delete dups based on the column data (1, 3, 6, 7, 8). The first row of data on Sheet Database is row 3 and ast row is dynamically increasing.... Praying you can hlep me with this last bit to get it working.

[Fluff13]

Ok, how about

Please Login or Register  to view this content.

[stein7]

Hi Fluff, I was praying you can help me do one last thing. In the same sheet, before I run this code that deletes dups.

I am trying to aggregate the data based on if column A, C, F, H are the same, meaning if there are multiple rows with values in those columns that are the same than I want to aggregate it into one row.. while aggregating, the newly formed row would take the SUM of column G, and Weighted Average in column I ([col G times col I] divided by sum of col g)... I am asking you because you are using scripting dicitonaries which is the way to go about this, however I am not too familiar with how to do them....

Would be forever greatful if oyu had any ideas

[Fluff13]

This will sum col G

Please Login or Register  to view this content.

I haven't done anything about col I, because from what I can see the prices don't change.