Hard core EXCEL

In Progress Posted Feb 22, 2016 Paid on delivery
In Progress Paid on delivery

In order to close our annual report we need to do some data analysis in excel. What we are looking fore, is someone how knows all about Excel functions, like VLOOKUP and more.

What we have:

- A) Excel sheet with invoice data (approx 22.000 rows)

- B) Excel sheet with order data (approx 22.000 rows)

What we need you to do, is to:

- extract data from A that is not included in B

- extract data from B that is not included in A

- extract duplicated data from A

- extract duplicated data from B if any

For someone, who knows how to do this, it should be a fairly easy and quick task. The deadline is within 1 day. So do not bid on this project unless you are very familiar with needed Excel functions and have the time to do the project today.

Excel

Project ID: #9729769

About the project

22 proposals Remote project Active Feb 22, 2016

22 freelancers are bidding on average $24 for this job

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir and i can do your job Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You More

$30 USD in 1 day
(396 Reviews)
7.6
ZedExcel

Hi there. I have read and understood the requirements of your project. I am experienced with Excel functions and formulas, including vlookups and similar ones. I would be glad to work on your project which I can comple More

$30 USD in 0 days
(35 Reviews)
7.2
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I can write 4 macros that will compare those 2 sheets and extract needed information and i can probably finish in about hour or two. If More

$25 USD in 0 days
(645 Reviews)
7.3
rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before More

$14 USD in 1 day
(114 Reviews)
6.5
RRajeshR

Hi, I am interested to work in this task. I can complete it by today. I can copy the data from a sheet to another which was not included in a sheet and remove the duplicates from the existing entries. Please con More

$30 USD in 1 day
(47 Reviews)
6.4
aminbros

A proposal has not yet been provided

$45 USD in 1 day
(9 Reviews)
5.2
mallikasomu87

7+ yrs exp in Advanced Excel. Relevant Experience: 1. Have automated excel reporting, formula analysis, charting, pivoting, dashboards, emailing from excel tasks in a quick turn around time. Project Proposal:  I More

$35 USD in 0 days
(15 Reviews)
4.7
SyaalAssistant

Hi dear provider, Ready to start now as i have 10+ years experience in Excel and can apply all formulas . Would you like to discuss more ?

$15 USD in 1 day
(36 Reviews)
4.4
Iqbal74

Good morning! My name is Iqbal Ali. I am a financial analyst. This means I spend 5 to 6 hours daily working on Excel files with Pivot Tables, lookups, graphs, conditional formatting, data validation, and other advance More

$15 USD in 1 day
(12 Reviews)
4.4
CreativeQueen

Hello, I have already done this same work. If you want so i'll give you sample my past work. please let me know, if I can support you. Thanks & Regards, Mitu Akter

$25 USD in 1 day
(24 Reviews)
3.8
xpertech07

Hello Sir, It is my great honor to apply for this job vacancy. I am very hardworking and can work effectively as fast as I can. I have excellent skills in Data Entry, Web Research and Microsoft Office and I have enoug More

$20 USD in 1 day
(22 Reviews)
3.5
moustafaa

Dear Sir/Madam, I am an expert in using excel, I use it for advanced applications. I am willing to do the required functions to view the needed results. Looking forward to work with you. Best Regards, Moustafa

$20 USD in 1 day
(4 Reviews)
3.6
Riz29

Hi.I can start now. I can do your project. I have done this type of project you can see my reviews. Kindly message me so we discuss it further. Waiting for your response. Thanks in advance

$15 USD in 0 days
(10 Reviews)
3.4
ckmalak

Hello! I am interested in this project. I have a really wide Excel knowledge and the solution should take about 30 minutes. I can do this promptly for you. I am happy to discuss more details, if required. More

$15 USD in 1 day
(2 Reviews)
1.7
velinmitev

Hello, my name is Velin. I want to try. But furst i will get the files , i will do it and if i manage then i will accept your job and youll pay me. If it is ok - send me the files.

$10 USD in 1 day
(3 Reviews)
1.7
asad090

willing to do your work in certain time and provide you with quality work . hoping for your reply. thanks

$25 USD in 1 day
(2 Reviews)
1.0
mijyos

I have a desire to help You with Your task. I promise the responsibility, focuse on the results, attention to the work and meeting the deadline.

$30 USD in 1 day
(0 Reviews)
0.0
mmatimaitis

I can finish a task like this in around 2-3 hours. My day to day job is mainly MS Excel so I am really familiar with all the needed functions. For this you need to use VLOOKUP, Data Duplicates and MATCH functions. More

$23 USD in 1 day
(0 Reviews)
0.0
aymanahmed88

I am DBA and SQl Developer Certified and have an experience more than 5 years as Developer in multinational company and have experience in data processing .....please if you accept contact me for more details

$25 USD in 1 day
(0 Reviews)
0.0