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

IN PROGRESS
Bids
17
Avg Bid (USD)
$75
Project Budget (USD)
$30 - $250

Project Description:
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)!

Additional Project Description:
03/18/2013 at 23:04 EET
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


03/18/2013 at 23:09 EET
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

03/19/2013 at 0:14 EET
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


03/19/2013 at 9:42 EET
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?

Skills required:
Excel
Additional Files: products.xls supplier.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire nagybatonyi
$ 80
in 2 days
$ 30
in 1 days
$ 50
in 4 days
Hire Pichart
$ 70
in 1 days
$ 60
in 1 days
Hire eugene2006
$ 80
in 4 days
$ 75
in 3 days
$ 30
in 5 days
Hire VNikcevic
$ 80
in 2 days
$ 100
in 3 days