Merge Excel Files eliminating duplicates

  • Status: Closed
  • Præmier: $75
  • Modtagne indlæg: 35
  • Vinder: EmiliaSimon

Konkurrence Instruktioner

I would like a quick macro to merge to two excel files of the same format but of different versions.
Identify the duplicates by certain columns and keep the values of the older version for the duplicate records found.

Updates 10/24/21:
1. Identify the duplicate rows with Sub ID, Patient Name, Date of Service and Total in Old from both excel files
2. For the rows found in both files, copy the status and other information from old file to new file
3. Create new excel sheet with copies data

- Prepare the utility
- Run it on the excel sheets attached
- Share the updated Excel sheet

Anbefalede Evner

Arbejdsgiverfeedback

“She is lovely. Only this is she never sleeps.. she should sleep more :) ”

Profilbillede shashikanthp09, United States.

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • techiestc
    techiestc
    • 1 måned siden

    I use python pandas , which is capable of doing same. If you are interested, I can write the script

    • 1 måned siden
  • IgeS
    IgeS
    • 1 måned siden

    Hi there, please tell us more about your requirements - macro to loops to all the sheets and copies all data from each sheet in each file; or only selects specific sheet in each file?

    • 1 måned siden
  • mf12343
    mf12343
    • 1 måned siden

    can youplease attach two sample files that needs to be merged and filtered?

    • 1 måned siden
  • abdulzabbar308
    abdulzabbar308
    • 1 måned siden

    Entry No #16
    Please Send Me Excel File

    • 1 måned siden
  • AlexDiazII
    AlexDiazII
    • 1 måned siden

    Entry #4 contains a video showing my solution.

    • 1 måned siden
  • cgullapalli
    cgullapalli
    • 1 måned siden

    Hi, Please share the file and post a project and invite. Happy to help. Thanks.

    • 1 måned siden
  • abdulzabbar308
    abdulzabbar308
    • 1 måned siden

    Hey Dear,
    Please Share The Excel Files

    • 1 måned siden
  • Shyamji2001
    Shyamji2001
    • 1 måned siden

    hii send file i want to ready for work

    • 1 måned siden
  • emilynfl
    emilynfl
    • 1 måned siden

    Hi! Kindly share the excel files we need to work on. Thanks

    • 1 måned siden
  • MateenAfaq
    MateenAfaq
    • 1 måned siden

    Hi Dear, Please share your excel files..

    • 1 måned siden
  • architachawla16
    architachawla16
    • 1 måned siden

    Hey there! I can merge your excel files and eliminate the duplicates. Please provide the files. Looking forward to a positive reply. Thank you.

    • 1 måned siden
  • shubhamkumar026
    shubhamkumar026
    • 1 måned siden

    please provide the excel files

    • 1 måned siden
  • supersystemng
    supersystemng
    • 1 måned siden

    Dear Sir, please provide the excel files

    • 1 måned siden
  • Shameemrony
    Shameemrony
    • 1 måned siden

    Dear Sir, please provide the excel files

    • 1 måned siden
  • faisal9263
    faisal9263
    • 1 måned siden

    #guaranteed

    • 1 måned siden
  • malek09
    malek09
    • 1 måned siden

    Where's the files

    • 1 måned siden
  • Jayant222
    Jayant222
    • 1 måned siden

    Hi there, I can do this for you real quick.

    • 1 måned siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!