Completed

Excel task

Hello There,

I have a couple of to create a simple bank reconciliation template. Two sets of data need to be reconciled - (based on 1 criterion) means all non-pared items should be identified and summaries into 2 columns: un pared i(unique) items from 1 data set and un pairs from the second. Better a formula, but macros will work too.

f.e. you have two data set

1

2

3

4

and

2

3

4

5

so as are result of this task you will have 2 products.

Matched - 2,3,4,

Un -matched 1,5

Thanks!

Skills: Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic

See more: excel convert column multiple columns, excel refresh data resize columns, excel data entry macros, how to create a task tracker in excel, weekly task list template excel, daily task sheet for employee, excel task tracker template xls, daily task list template for work, project task list template excel, excel task tracker template, free excel task tracker template, excel proficiency exam macros, excel 2007 export macros amazon, excel inputting data macros, excel copy data macros, excel vba referencing macros add, vba excel task mapping sheet, excel phone number macros, excel data form macros, excel macro calc macros

About the Employer:
( 0 reviews ) San Bruno, United States

Project ID: #18936141

Awarded to:

ksriniravi

Greetings! I can write a macro for the requirement. I can create 2 new different Sheets (Matched and Umatched) or if it is OK with you 3 new Sheets Matched, Unique 1 and Unique 2 so that it is easier to reconcile. More

$30 USD in 1 day
(175 Reviews)
6.8

13 freelancers are bidding on average $26 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$50 USD in 1 day
(328 Reviews)
7.9
prameswara

Hello Sir I can do make macro for your sample case Sir :) i can identify data is match and un match like your sample please give me this job and im able to start working right now and finish in few hour Thank you More

$30 USD in 0 days
(357 Reviews)
7.1
TonmoyRoy111

Hello client I understand the logic completely. I can build the macro for you which will solve tthe purpose. Please contact me. Roy

$30 USD in 1 day
(308 Reviews)
6.7
mariusalex86

Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable freelancer, focused on quality and completing projects on time. I have good knowledge of Excel. Kindly conside More

$17 USD in 1 day
(88 Reviews)
5.8
lightingdavid

Hello. I have checked your project description and that's easy for me. I 'm sure i can give you perfect result. Contact me please. Thank you.

$25 USD in 0 days
(41 Reviews)
5.5
pm9887

Hi, As per given details Its data entry task. I have great experience in all kind of backend support I am good in lead generation, internet research, market research, data entry, data processing and all kind of backe More

$30 USD in 2 days
(53 Reviews)
5.4
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam More

$25 USD in 1 day
(23 Reviews)
4.7
nvchien94

Hello there, I am an Excel expert and also an management accountant. I understand bank statement and can help you to compare dataset. Please share me detail data, I can start right now. Thanks

$15 USD in 5 days
(43 Reviews)
4.4
paulodayto08

Hi Good Day! I've done a lot of work like this one before. I can help you to complete this project with high quality. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool t More

$30 USD in 1 day
(18 Reviews)
3.6
gellievale92

I have been working as an accounting clerk for more than 7 years now and I have been doing reconiciliation of financal statements as a major part of my job. I guarranty that I will be able to have this project done in More

$10 USD in 1 day
(1 Review)
0.7
camanojvaryani

i am a qualified chartered accountant having expertise in book keeping, accountant & reconciliation projects i am also expert in ms excel and have already done such type of reconciliation work in ms excel. relate More

$35 USD in 1 day
(0 Reviews)
0.0
eriksongpealoza

Hello, my name is eriksong peñaloza, I am an electronic engineer, I have experience in the use of office resources. I did not do my first job in this area on the freelancer platform, but if you give me the opportunity More

$10 USD in 1 day
(0 Reviews)
0.0