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

Končano Objavljeno pred 4 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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 Vnos podatkov Obdelava podatkov

ID projekta: #24124508

Več o projektu

73 predlogov Oddaljen projekt Aktiven pred 4 letoma/leti

Dodeljeno:

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 Več

€20 EUR v 1 dnevu
(219 mnenj)
6.9

73 freelancerjev ponuja v povprečju za €36 na tem delu

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 v 3 dneh
(132 ocen)
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 Več

€49 EUR v 1 dnevu
(862 ocen)
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 v 2 dneh
(411 ocen)
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 v 1 dnevu
(504 ocen)
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 Več

€35 EUR v 1 dnevu
(136 ocen)
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 v 7 dneh
(246 ocen)
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 v 7 dneh
(260 ocen)
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 v 1 dnevu
(373 ocen)
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 Več

€20 EUR v 1 dnevu
(249 ocen)
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 Več

€20 EUR v 1 dnevu
(400 ocen)
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 Več

€50 EUR v 3 dneh
(101 ocen)
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 Več

€50 EUR v 1 dnevu
(118 ocen)
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, Več

€50 EUR v 2 dneh
(140 ocen)
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 Več

€40 EUR v 2 dneh
(485 ocen)
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 v 1 dnevu
(211 ocen)
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 Več

€30 EUR v 7 dneh
(104 ocen)
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 Več

€25 EUR v 1 dnevu
(79 ocen)
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 Več

€20 EUR v 1 dnevu
(78 ocen)
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 v 5 dneh
(82 ocen)
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 v 1 dnevu
(26 ocen)
5.2