wild & id key comparison and add - discrepancy fin
Hello,
I have two sets of data I would like to compare. I put these two sets of data in one sheet(data tab) in two section (A & B). What I want to know is if there are any Discrepancy between these two sections of data. example
1 - What is in Part A that is not in Part B and what is in Part B that is not in Part A.
2- What is in Part A that is also in Part B that is different.
3 - What is in Part B that is also in Part A that is different.
sometimes you have to add the same values from data A to know if data A from B are different.
A
LS POWER - BROADWAY GEN FUNDING LLC
B
BROADWAY GEN FUNDING, LLC Total
A
COLUMBUS STEEL CASTINGS CO. 2ND LIEN (AKA BP METALS)
B
BP METALS AKA COLUMBUS STEEL Total
I have the information on the data in the excel doc in notes tab.
Thanks -
|