a tool to compare two excel files that have a column with similar records

Completed Posted Mar 18, 2013 Paid on delivery
Completed Paid on delivery

I need a tool to compare two excel files that have a column with similar records

The 2 excel files wil have only one column with similar records all other columns may be different.

I need to be able to add 2 excel files and the application would give me tools to compare the values in each row of each excel file according the similer column that they have.

I need the comparison results to be very clear for me and even better if i can have additional comparison filters.

I do not care if you do it in microsoft access or if you create a program from scratch or if you take an open source like kdiff3 and adjust it to compare excel files, I am using windows 7 and windows 8

While you are creating it i would like to test it and see if it does what i need!

I am willing to give up to 100$ for this project.

If there is already an application for this 2 excel files comparison that does all that i want and that costs less than 50$ then i will give 20$ to the person that will give me this information and this project would be considered done for me (I will have first to test the suggested application)!

i need to compare two rows that have a similar column as a key lets say and find the differences in the other columns of these row

i need to be able to compare 2 excel files that each excel has about 20000 rows. Both excel files have a column with exactly similar values that are like a primary key for each spreadsheet. But not all 2 excel files have the similar rows - some may be missing in the one and some in the other

if in a row of a product (excels will have products) with the same primary key there is a column lets say price then i will not only want your tool to show me the difference i will also need to know which has the biggest value of the two excels

Both excel files will be in UTF-8 (without bom) because ot the Greek characters that they are containing and must be in utf-8 because after the comparison i will have to create a new excel file that will be converted to txt (in csv format) for uploading it to our server.

I need the tool to be as easy as possible for me to help me mass update columns after presenting me the differences

I have attached 2 files

The first column of each file is lets say the unique primary key for each spreadsheet

I need your comparison tool to present me the differences for each row that is similar in both spreadsheets but also to tell me what is the difference and indicate me the bigger value

So since column A is similar for both spreadsheets i need to compare column AI from products.xls with column E from supplier.xls

A programmer gave me an idea that i could also have a function or a button whatever that when i click on it, it would automatically merge the price column to one of the excel files by using the highest value from both files! Can you also do this for me?

Excel

Project ID: #4345249

About the project

17 proposals Remote project Active Mar 19, 2013

Awarded to:

seaanddream

Hi, excel vba expert here, I am open to a good cooperation with you to come up with the best outcome.

$30 USD in 5 days
(6 Reviews)
2.9

17 freelancers are bidding on average $75 for this job

nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. I plan to complete the project v More

$80 USD in 2 days
(39 Reviews)
5.4
pierreho

Hi teochris, Have a look at my PM. Regards

$30 USD in 1 day
(24 Reviews)
4.8
ethicalboy

Hi, I am an excel expert, what type of comparison do you mean?

$50 USD in 4 days
(22 Reviews)
4.4
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I send you attachment via PM.

$70 USD in 1 day
(13 Reviews)
3.8
Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert =============== More

$60 USD in 1 day
(8 Reviews)
3.5
eugene2006

I interested in your project

$80 USD in 4 days
(7 Reviews)
3.2
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$75 USD in 3 days
(1 Review)
3.1
VNikcevic

Hi, If you're already using Excel I would also propose an Excel-based approach. Check PM for further explanation. Sincerely, Nik.

$80 USD in 2 days
(1 Review)
2.8
bubu77

Hi, Access/Excel expert having 8+ years of IT experience. I can do the job for you. Please see your PM for sample and more details.

$100 USD in 3 days
(1 Review)
2.0
srdas2012

Hi,Please check PMB

$35 USD in 1 day
(1 Review)
1.6
omaralieissa

hi, i have done similar project, check my review to see it.

$90 USD in 3 days
(0 Reviews)
0.0
damwlod

Sir, I have experience and skills to finish your project and can start right away. Feel free to ask me any question. Regards

$100 USD in 3 days
(0 Reviews)
0.0
Concept39

Hello, I get the job done!

$100 USD in 2 days
(0 Reviews)
0.0
silvacorp

Hi, I work in Analytics and Decision support, creating advance Excel VBA reports. I can have this done for you within a day. Thanks Marco

$90 USD in 1 day
(0 Reviews)
0.0
basicinfo123

Hi teochris, Thanks for posting such a great opportunity. I have thoroughly gone through your requirement and would like to bid for this project which exactly matches our skill-set. We have worked earlier on s More

$100 USD in 10 days
(0 Reviews)
0.0