P
Pree
Two issues:
My data is not in the same order, and cannot be filtered so that it i
in the same order. One worksheet has more rows than the other, fo
example.
And also, I need it to cross-verify two columns.
So if in worksheet A the data is,
employee1 manager mandy
employee2 manager carol
employee3 manager andy
employee4 manager andrew
and in worksheet B the data is,
employee1 manager mandy
employee3 manager andy
employee2 manager alex
employee4 manager andrew
i want it to cross-verify this type of data. and pinpoint that the dat
has discrepencies with employee2
My data is not in the same order, and cannot be filtered so that it i
in the same order. One worksheet has more rows than the other, fo
example.
And also, I need it to cross-verify two columns.
So if in worksheet A the data is,
employee1 manager mandy
employee2 manager carol
employee3 manager andy
employee4 manager andrew
and in worksheet B the data is,
employee1 manager mandy
employee3 manager andy
employee2 manager alex
employee4 manager andrew
i want it to cross-verify this type of data. and pinpoint that the dat
has discrepencies with employee2