The formulas work!
In returned workbook, into columns J:K new values for both columns are calculated. In cell N1 FALSE indicates, that there are differences with values in original table - so copy values from J2:K17 into D2:E17 (Use PasteSpecial>Values to copy only values, not formulas!)
When after that in N1 the formula returns TRUE, then there aren't any duplicate rows in D2:E17 anymore, otherwise repeat coping values from J2:K17 into D2:E17.
|