wild & id key comparison and add - discrepancy fin
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.
LS POWER - BROADWAY GEN FUNDING LLC
BROADWAY GEN FUNDING, LLC Total
COLUMBUS STEEL CASTINGS CO. 2ND LIEN (AKA BP METALS)
BP METALS AKA COLUMBUS STEEL Total
I have the information on the data in the excel doc in notes tab.