Compare ranges

 
 
With this tool you will be able to make comparaciones of formulas and values of the datas of a range.
 
In the following example , if you have:
The I11:I21 range in the sheet Beta1 of the Model workbook and u wish to buy it with the I11:I21 range of the Beta1 sheet.
 
1.- In this case we check option : compare 2 ranges
2.-Indicate workbook and range
Specify workbook , in this case the Model workbook and select range , in this case range I11:I21 of the Beta sheet.
 
For the second range , proceed just the same way.
Select the workbook and indicate for this case range I11:I21 of the Beta1 sheet.
 
 

 
3.-Click on the Do it ! button.
Finally we obtain a report with the comparacion of range1 and range2.