Excel Formulas / Macros

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.


Beceriler: Veri İşleme, Excel

Daha fazlasını gör: data entry, data processing, excel

İşveren Hakkında:
( 5 değerlendirme ) Auckland, New Zealand

Proje NO: #9827851



I can do it for you quickly and exactly by vba .

%selectedBids___i_period_sub_7% gün içinde 50%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(51 Değerlendirme)

Bu iş için 7 freelancer ortalamada $51 teklif veriyor


A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(305 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(53 Değerlendirme)

Hello, I am proficient with Excel and VBA and I believe I could help you with this problem. Please contact me for more information.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(8 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hi I can do this in couple of hours. Please check my profile for my skills and experience. Thanks Dalas

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(1 Yorum)