Forum Discussion
Help, use Excel to compare two sets of values to keep the duplicates and remove the extraneous value
I have two columns on different sheets of unique numerical values. I want to take the set of values from sheet A and compare it to values on sheet B, to where I can end up finding out which values ar...
chris4153021 Depending on your Excel version, look into the XLOOKUP or VLOOKUP functions.
Lookup all values from A in B and vice versa. If a matching result is returned the value exists in the other list. If not, the value does not exist in the other list.