Compare 2 excel tables (A & B) using vlookup formula/pivot tables or other to identify & isolate common values in a specific column in the two tables (i.e. Policy Number X found in table A is also found in table B) and exhibit the relevant value appearing in each table (i.e. Premium of X in A & Premium of X in B).
51 freelancers are bidding on average €25 for this job
I can write a macro to output the values of premium for the same policy number in the two files. some policy numbers in the first file are not found on the second file; these will show only one value
Hi This can most certainly be done in less than an hour. In fact, I will work on it now and have it ready for you by the time you send me a message. Kind regards John
Hi Dear Client. I am expert Data Miner and Web developer. I have experienced with data mining and site crawling and automatics uploading. I can complete your job quickly and perfectly. Thanks for your time.
I can do it for you easily. I am using ActiveData for excel which is a powerful tool that let me merge & identify the duplicates instantly. Please don't hesitate to contact me for any further clarification.