Relate two excel lists and extract results that only repeat once. More than 500,000 records.
€20-50 EUR
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.
Project ID: #24124508
About the project
Awarded to:
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
73 freelancers are bidding on average €36 for this job
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
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
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
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.
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
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
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
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 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
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
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
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
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
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
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
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.
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