Comparing two Excel .xls files and generating an Excel .xls Output File
We need an application that compares two Excel .xls input files (see samples) and generates a specific Excel .xls output file (see sample).
Keys for comparison: Prospect Name, Prospect Company, Prospect Email, Prospect Phone, Prospect Fax, Prospect Address
(The data of the other columns can be identically.)
If one or more of the key data is identical, the entry should be listed in a specific category in the output file named: “Double Entry“. The unique entries are listed in the category called „Unique Entry“. The output file must look exactly like the provided sample including the colors.
This application must be written in PHP so that it can ran on a web server.
We pay by paypal.