Merge Excel Files eliminating duplicates

  • État: Closed
  • Prix: $75
  • Propositions reçues: 35
  • Gagnant: EmiliaSimon

Résumé du concours

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

Compétences recommandées

Commentaire de l'employeur

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

Image de profil shashikanthp09, United States.

Meilleures propositions de ce concours

Afficher plus de propositions

Tableau de clarification publique

  • techiestc
    techiestc
    • il y a 1 mois

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

    • il y a 1 mois
  • IgeS
    IgeS
    • il y a 1 mois

    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?

    • il y a 1 mois
  • mf12343
    mf12343
    • il y a 1 mois

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

    • il y a 1 mois
  • abdulzabbar308
    abdulzabbar308
    • il y a 1 mois

    Entry No #16
    Please Send Me Excel File

    • il y a 1 mois
  • AlexDiazII
    AlexDiazII
    • il y a 1 mois

    Entry #4 contains a video showing my solution.

    • il y a 1 mois
  • cgullapalli
    cgullapalli
    • il y a 1 mois

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

    • il y a 1 mois
  • abdulzabbar308
    abdulzabbar308
    • il y a 1 mois

    Hey Dear,
    Please Share The Excel Files

    • il y a 1 mois
  • Shyamji2001
    Shyamji2001
    • il y a 1 mois

    hii send file i want to ready for work

    • il y a 1 mois
  • emilynfl
    emilynfl
    • il y a 1 mois

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

    • il y a 1 mois
  • MateenAfaq
    MateenAfaq
    • il y a 1 mois

    Hi Dear, Please share your excel files..

    • il y a 1 mois
  • architachawla16
    architachawla16
    • il y a 1 mois

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

    • il y a 1 mois
  • shubhamkumar026
    shubhamkumar026
    • il y a 1 mois

    please provide the excel files

    • il y a 1 mois
  • supersystemng
    supersystemng
    • il y a 1 mois

    Dear Sir, please provide the excel files

    • il y a 1 mois
  • Shameemrony
    Shameemrony
    • il y a 1 mois

    Dear Sir, please provide the excel files

    • il y a 1 mois
  • faisal9263
    faisal9263
    • il y a 1 mois

    #guaranteed

    • il y a 1 mois
  • malek09
    malek09
    • il y a 1 mois

    Where's the files

    • il y a 1 mois
  • Jayant222
    Jayant222
    • il y a 1 mois

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

    • il y a 1 mois

Montrer plus de commentaires

Comment commencez des concours

  • Publiez votre concours

    Publiez votre concours Rapide et facile

  • Obtenez des tonnes de propositions

    Obtenez des tonnes de propositions De partout dans le monde

  • Attribuez la meilleure proposition

    Attribuez la meilleure proposition Télécharger les fichiers - Facile !

Publier un concours maintenant ou rejoignez-nous maintenant !