Relate two excel lists and extract results that only repeat once. More than 500,000 records.

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

It is a list of companies, with more than 500 000 records per list. Each company has a unique id, that's what needs to be related.

Sheet A (old list)

Sheet B (recent list)

list A checks whether the value is in list B, if not, creates a list C with all the values that are not in list B.

The idea is to get the companies that went bankrupt, between the first list and last one.

Excel Data Entry Data Processing

Project ID: #24124508

About the project

73 proposals Remote project Active 4 years ago

Awarded to:

ESOLUTIONSSS

Hello Sir/Madam, It is my pleasure to be able to bid on your project. Right now i will start working on your project and i will complete this project with in few hours. Really very much interested to have this proje More

€20 EUR in 1 day
(219 Reviews)
6.9

73 freelancers are bidding on average €36 for this job

hdlan

Hello, I will identify and create a new file with all bankrupt companies according to your requirements. Can you please provide your files? Thank you and Best regards, Duong

€50 EUR in 3 days
(132 Reviews)
9.5
rahul62544

Hello, I am Rahul. I have gone through your project details; you need to relate two excel sheets . I am Expert in Microsoft Office and PDF's Work. I have done Similar work also which you can see on my Profile, All have More

€49 EUR in 1 day
(862 Reviews)
8.5
FINGERRPRINT

Hi there, We can compare both the list A and B, and get you the unique list in Sheet C. Clearly understand the project and The list is quite large so placing a bid of 100. Look forward to hear. Thanks DATA NATION

€100 EUR in 2 days
(411 Reviews)
8.3
P0L

Hello, I’m an Excel expert and I can match your lists. Please send me the files and contact me to discuss further details. Regards.

€50 EUR in 1 day
(504 Reviews)
8.0
hmryz

Hi, I would LOVE to start working on your spreadsheets immediatly. I will relate both sheets according to their ID company and create a list C, for the values not found on list C. I can have this done in less than an More

€35 EUR in 1 day
(136 Reviews)
7.5
konanhenry1111

I understand it well but need to do an example I can do it well. I have good experience in data entry check my reviews

€35 EUR in 7 days
(246 Reviews)
7.2
tanjirdramatist

Sir, I can do it easily to use formula. But could you tell me what's data may be not present in B column? Is it company only or unique ID? Thanks

€100 EUR in 7 days
(260 Reviews)
7.4
deepabittu

hello sir i am complete many job like excel formula related so i am give you good result please give me one chance. please visit my last project

€24 EUR in 1 day
(373 Reviews)
7.1
ksriniravi

Greetings! Because there is an unique ID, it is possible to automate this process using formulas. I can come up with list C (all records that are not in List B). Please share the files. Being a full time freelancer w More

€20 EUR in 1 day
(249 Reviews)
7.1
AnowarRatul

€20 Only ------- In just 1 Hour ------- I can make the list of unique IDs based on your data absolutely as you want by maintaining 100% accuracy ------ Excel VBA Macro Coding, Formula Generation and Automation process More

€20 EUR in 1 day
(400 Reviews)
6.8
TechnoGuruu

Hi, As per requirements, I will create filtered list C for you as per the description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and More

€50 EUR in 3 days
(101 Reviews)
6.5
mtanveer2012

Hello Sir, I can write quickly python script for excel which will compare all the 500,000 records using unique company id with 100% accuracy and very quickly and can be also reused next time if needed, please contact m More

€50 EUR in 1 day
(118 Reviews)
6.6
finecodervw

Hi, Keen to work on this project. I went through the project description. I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, SUMIF, Left, Right, Index Match, drop down, filters, More

€50 EUR in 2 days
(140 Reviews)
6.7
tmoi06

Hello Sir, I am 100% confident that I can execute the project with good quality. For better clarification, you can also have a look at several feedbacks that I have earned so far on Freelancer. Thanks Ayan NB: Like More

€40 EUR in 2 days
(485 Reviews)
6.6
best4best

Hi, I can compare both the sheets A and B using formulas and show the companies, which are not found in sheet B into sheet C with 100% accuracy in less than 1hour. Regards

€20 EUR in 1 day
(211 Reviews)
6.6
gayuh

Hello, I can extract the list of companies from sheet A that are not found in sheet B (companies that went bankrupt) based on the unique id of each company. I will write a macro to perform the process automatically, t More

€30 EUR in 7 days
(104 Reviews)
6.1
narsim3128

NOTE : I CAN COMPLETE THIS IN AN HOUR With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed few pr More

€25 EUR in 1 day
(79 Reviews)
6.2
rumarahman

I have 10 years experience with Data Processing in Excel. I work with: Excel Data Processing Data Collecting (Using Macro) MS Office VBA Excel VBA Macro Automation User Forms Data Analyzing PivotTable Char More

€20 EUR in 1 day
(78 Reviews)
5.8
chetandc

Hey there, I can do it. > Send me more details so we can go further. Give me one chance to give my service and make you Happy. I`m ready to create history with you!. Feel free to contact me anytime.

€80 EUR in 5 days
(82 Reviews)
5.7
reubengi

Hi there, I can sort and clean your excel list to het the list of companies that went Bankrupt. I can give you the list before the end of today. Regards Reuben

€20 EUR in 1 day
(26 Reviews)
5.2