Excel Spreadsheet Formatting & Manipulation

Here is what I need:

Let's assume I have a Microsoft Excel spreadsheet that has 100,000 names on it (Master Excel File). And then let's assume that I have another separate file with 5,000 names on it (New Data File).

What I need is to be able to remove the names from the New Data File that are duplicates of the ones in the Master Excel File. When those names have been removed from, the New Data File, I need to then create a final Excel file that has no duplicates (Scrubbed Data File). This Scrubbed Data File is the finalized spreadsheet of the remaining names from the New Data File. In other words, out of the 5,000 names, if 1,000 were already on the Master Excel File, then the Scrubbed Data File would produce 4,000 names.

I have attached a visual representation of what I need.

I would prefer to have a software where I can upload both the Master Excel File and the New Data File and it automatically creates the Scrubbed Data File that I can download.

Please only apply if you already know you can do this.

Taidot: Excel, Microsoft, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: microsoft excel spreadsheet, microsoft excel software, master excel, spreadsheet microsoft excel, excel spreadsheet, Excel Formatting, spreadsheet manipulation, microsoft data manipulation software, duplicates excel, excel 2013 visual, formatting data microsoft excel, microsoft excel 2013, excel data upload php, excel file data manipulation, php excel manipulation, excel manipulation, php create upload excel file, create master file excel, spreadsheet upload php, remove duplicates, master data manipulation, excel spreadsheet formatting, php excel upload, separate excel, excel master

Tietoa työnantajasta:
( 17 arvostelua ) SLIVER SPRING, United States

Projektin tunnus: #4274046

Myönnetty käyttäjälle:


Professional software developre with 3 year of developing experience. Please check PM. Thanks

$180 USD 7 päivässä
(4 Arvostelua)

7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$75 USD 2 päivässä
(45 arvostelua)

Hi, I can do it using a Excel macro (running on new file) or using a separate program (windows based or web based) using Visual [url removed, login to view], C#,... check PM for details. Thanks.

$50 USD 1 päivässä
(14 arvostelua)

I can provide you a nice interface in Labview to automatically get the results.

$45 USD 1 päivässä
(1 arvostelu)

Hello Sir, Ready to start work.

$50 USD 1 päivässä
(2 arvostelua)

I can do this with the CSV format. (Excel>Save As CSV)

$100 USD 1 päivässä
(1 arvostelu)

Hi, I have a lot of experience with Excel and can have this done in just a few hours. I currently dedupe data weekly for a large call centre and am confident this would be a simple process for me. Let me know if Lisää

$40 USD 1 päivässä
(0 arvostelua)

I would like to do this. Idea would be to use database import and export to remove the duplicates. let me know if want me to finish this. it will take hardly 1 hour or less.

$50 USD 1 päivässä
(0 arvostelua)