Compare Items

[navferty]

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

[uom42]

Очень специфическая задача. Есть пример из реальной практики применения?