|
||||||
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 worksheet. | ||||||
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 worksheet. | ||||||
For the second range , proceed just the same way. | ||||||
Select the book 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. | ||||||