P
Pree
Sorry for the respost everybody, I just assumed that because I ha
replied to my original response, people may not have seen my message.
My problem is I dohn't know how to use excel to cross-verify data.
For rows that do not match, I would like something to occur in exce
that would pinpoint this to me. Whether it tell me the list in a ne
worksheet or highlight the rows, anything.
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.
thank you so much for your help, i am so stuck
replied to my original response, people may not have seen my message.
My problem is I dohn't know how to use excel to cross-verify data.
For rows that do not match, I would like something to occur in exce
that would pinpoint this to me. Whether it tell me the list in a ne
worksheet or highlight the rows, anything.
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.
thank you so much for your help, i am so stuck