Hello,
I am not sure how many of you have used Excel Compare but for those of you looking for a tool to compare two sets of data you might want to check it out. Anyway, I do have a quick question regarding this software that I am hoping someone who uses it knows. Basically, the program works great and shows all my discrepancies between two Excel Workbooks. However, I would like it to show data that matches as well. I am using unique keys to match my data and I want to reconcile the data to assure the program accurately went through it all. I need to add up the matching data along with the discrepancy data to see if it totals my source data. I hope that makes sense. Thanks.
Shacker
I am not sure how many of you have used Excel Compare but for those of you looking for a tool to compare two sets of data you might want to check it out. Anyway, I do have a quick question regarding this software that I am hoping someone who uses it knows. Basically, the program works great and shows all my discrepancies between two Excel Workbooks. However, I would like it to show data that matches as well. I am using unique keys to match my data and I want to reconcile the data to assure the program accurately went through it all. I need to add up the matching data along with the discrepancy data to see if it totals my source data. I hope that makes sense. Thanks.
Shacker