G
Guest
I have 2 workbooks with supposedly the same data recorded by two different
users in each worksheet of the work book. I would like to compare each
seperate worksheet to find any reference numbers that appear in column D in
worksheet A that do not appear in worksheet B. A missing reference number is
not reperesented by a blank cell in sheet B it may just be different data.
What I was hoping I could do was enter a formula that will look in column d
for a match and return true or something similar if the same reference number
is found. Is this the best way or is there something easier or more simple
to do.
eg worksheet 1, of workbook A: eg worksheet 1, of workbook B:
Column D Column D
123456 123456
654321 654321
100001 199999
542313 542313
users in each worksheet of the work book. I would like to compare each
seperate worksheet to find any reference numbers that appear in column D in
worksheet A that do not appear in worksheet B. A missing reference number is
not reperesented by a blank cell in sheet B it may just be different data.
What I was hoping I could do was enter a formula that will look in column d
for a match and return true or something similar if the same reference number
is found. Is this the best way or is there something easier or more simple
to do.
eg worksheet 1, of workbook A: eg worksheet 1, of workbook B:
Column D Column D
123456 123456
654321 654321
100001 199999
542313 542313