Data matching (reconciliation) in MS Excel
- or -
Post a project like this$$$
- Posted:
- Proposals: 11
- Remote
- #1922755
- Expired
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
Islamabad
7454111406416199943815654001778242206002211141282114403116930518251992131815
Description
Experience Level: Expert
I have two set of data that I want to match.
Input (from two source Business property and PLC) - in two different tabs in an excel spreadsheet
Output (see spreadsheet) - six tabs
Source Business property ia about 5,000 rows and 11 columns (so you have to filled in these cells for the testing).
Source PLC is about 25,000 rows and 26 columns (so you have to filled in these cells for the testing).
However, the matching items are found on only two rows in A, and three rows in B.
I have attached a spreadsheet of the two input tabs.
The key requirements are to produce an excel formula for the matching, and transferring the matches into the 4 output tabs, without using MACROS.
Also, the formula must be efficient i.e. not taking up memory space when computing. At the moment we have a formula but it takes ages to calculate/update. To test this, you have to fill in the rows/column with data for the testing.
Controls should also be put to make sure that reconciliation/matching was correct.
I will explain in fine details if you contact me.
Input (from two source Business property and PLC) - in two different tabs in an excel spreadsheet
Output (see spreadsheet) - six tabs
Source Business property ia about 5,000 rows and 11 columns (so you have to filled in these cells for the testing).
Source PLC is about 25,000 rows and 26 columns (so you have to filled in these cells for the testing).
However, the matching items are found on only two rows in A, and three rows in B.
I have attached a spreadsheet of the two input tabs.
The key requirements are to produce an excel formula for the matching, and transferring the matches into the 4 output tabs, without using MACROS.
Also, the formula must be efficient i.e. not taking up memory space when computing. At the moment we have a formula but it takes ages to calculate/update. To test this, you have to fill in the rows/column with data for the testing.
Controls should also be put to make sure that reconciliation/matching was correct.
I will explain in fine details if you contact me.
Agu M.
95% (4)Projects Completed
5
Freelancers worked with
5
Projects awarded
24%
Last project
3 Apr 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
HI,
I need to ask you couple of questions with regards to your request. Can you message me to discuss please ? -
Can you inbox me, to discuss about this project.
603857603525
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies