a tool to compare two excel files that have a column with similar records
$30-250 USD
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?
Project ID: #4345249
About the project
Awarded to:
Hi, excel vba expert here, I am open to a good cooperation with you to come up with the best outcome.
17 freelancers are bidding on average $75 for this job
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
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.
Hi, I have experience with this project, I happily if work with you in this project. Best Regards
Hi, If you're already using Excel I would also propose an Excel-based approach. Check PM for further explanation. Sincerely, Nik.
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.
Sir, I have experience and skills to finish your project and can start right away. Feel free to ask me any question. Regards
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
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