The attached Excel spreadsheet has large data. Each entry has a Group ID (last column in data). There are multiple entries for the same Group ID. I am wanting an Excel formula that will remove all duplicate entries and combine all unique data into a single entry for a Group ID.
It should be noted that for duplicate Group ID entries, some columns in the row have unique data and some columns have duplicate data. Where unique data exists - this needs to be retained but combined into a single Group ID entry.
The formula will need to (1) identify duplicate group IDs, (2) filter against each Group ID for data that is unique and data that is duplicate, (3) remove all duplicate data, (4) retain all unique data, (5) combine remaining data into one entry for a single Group ID.
This is a formula that I will need to use on an ongoing basis.
I have highlighted some duplicate entries in the attachment.
I can do it for you quickly and exactly by vba .
Bu iş için 7 freelancer ortalamada $51 teklif veriyor
Hi there! I'm a web developer.I'm get bachelor IT certificate on 2013.I have 3+ year in web development.I provide services with enthusiasm, creativity, pay until you are satisfied with my quality services and reach yo Daha Fazla
Hello, I am proficient with Excel and VBA and I believe I could help you with this problem. Please contact me for more information.
Hello, I am interesting to your project and placed bid for your consideration. With my experience in excel formulas and macro I am confident that I will able to complete your project as per timeline and requirement. A Daha Fazla
Local Australian with extensive excel/vba experience in an reporting and analytics. Ive worked as an operations analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating automated solu Daha Fazla
Hi I can do this in couple of hours. Please check my profile for my skills and experience. Thanks Dalas