Merge Excel Files eliminating duplicates

  • Status: Closed
  • Prize: $75
  • Entries Received: 33
  • Winner: EmiliaSimon

Contest Brief

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

Recommended Skills

Winner
Featured Contest
Post a Contest Like This

Employer Feedback

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

Profile image shashikanthp09, United States.

Public Clarification Board

  • techiestc
    techiestc
    • 2 years ago

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

    • 2 years ago
  • IgeS
    IgeS
    • 2 years ago

    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?

    • 2 years ago
  • mf12343
    mf12343
    • 2 years ago

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

    • 2 years ago
  • abdulzabbar308
    abdulzabbar308
    • 2 years ago

    Entry No #16
    Please Send Me Excel File

    • 2 years ago
  • AlexDiazII
    AlexDiazII
    • 2 years ago

    Entry #4 contains a video showing my solution.

    • 2 years ago
  • cgullapalli
    cgullapalli
    • 2 years ago

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

    • 2 years ago
  • abdulzabbar308
    abdulzabbar308
    • 2 years ago

    Hey Dear,
    Please Share The Excel Files

    • 2 years ago
  • Shyamji2001
    Shyamji2001
    • 2 years ago

    hii send file i want to ready for work

    • 2 years ago
  • emilynfl
    emilynfl
    • 2 years ago

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

    • 2 years ago
  • MateenAfaq
    MateenAfaq
    • 2 years ago

    Hi Dear, Please share your excel files..

    • 2 years ago
  • architachawla16
    architachawla16
    • 2 years ago

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

    • 2 years ago
  • shubhamkumar026
    shubhamkumar026
    • 2 years ago

    please provide the excel files

    • 2 years ago
  • supersystemng
    supersystemng
    • 2 years ago

    Dear Sir, please provide the excel files

    • 2 years ago
  • Shameemrony
    Shameemrony
    • 2 years ago

    Dear Sir, please provide the excel files

    • 2 years ago
  • faisal9263
    faisal9263
    • 2 years ago

    #guaranteed

    • 2 years ago
  • malek09
    malek09
    • 2 years ago

    Where's the files

    • 2 years ago
  • Jayant222
    Jayant222
    • 2 years ago

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

    • 2 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!