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 book 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 book and range | ||||||
| Specify book , in this case the Model book and select range , in this case range I11:I21 of the Beta sheet. | ||||||
| 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. | ||||||
|