Excel Formulas / Macros

$50 AUD

Terminado

Publicado

hace alrededor de 8 años

$50 AUD

Pagado a la entrega

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. THANKS!

Data Processing

Excel

ID del proyecto: 9827851

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 8 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@zebracaro

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

$50 AUD en 2 días

4,9

(123 comentarios)

7,1

6 freelancers están ofertando un promedio de $51 AUD por este trabajo

@Teloquence

A proposal has not yet been provided

$50 AUD en 0 día

4,9

(334 comentarios)

7,7

@vlayausa

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

$50 AUD en 2 días

4,9

(139 comentarios)

5,8

@tranxuanhao

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 your purposes. My Services: Website design and development. Responsive website. Excel fomulas - Dashboard design -VBA Programming. Data entry -product upload-CMS- Virtual Assistant. Html-Css-javascript. PHP-Wordpress-C# Unity. Software Testing. Hire me for: - Fast turnaround time - satisfy 100%.Lifetime support. - Working everyday. - realtime responding.

$50 AUD en 1 día

4,8

(54 comentarios)

5,1

@gsanggara

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. Appreciate if we can talk thought pm before project awarded. Looking forward to hearing good news from you. Thanks & Regards, GS-Anggara

$50 AUD en 1 día

4,9

(27 comentarios)

4,2

@TianaKay

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 solutions in excel to drive optimisation. Can start immediately get this done for you quickly and accurately.

$55 AUD en 0 día