Compare Items #6
Description
User selects two ranges one by one.
Then new workbook is created, and active sheet contains three ranges:
- values from first range, not present in second
- values that are present in both ranges
- values from first range, not present in second
Comparison by entire row in selection. Both ranges must be of equal width (number of columns selected).
Example 1:
First selection:
| 1 | a |
| B | b |
| 3 | z |
| 4 | d |
Second selection:
| B | b |
| 3 | c |
| 4 | d |
| 5 | a |
| 6 | a |
Result:
| 1 | a | B | b | 3 | c | ||
| 3 | z | 4 | d | 5 | a | ||
| 6 | a |
Example 2:
First selection:
| 1 | a |
| B | b |
Second selection:
| 1 |
| b |
Result:
Error message