Forum Discussion
COMPARING COLUMNS
HELLO CAN ANYONE TELL ME HOW TO COMPARE TWO COLUMNS OF DATA (ONE LONG, ONE SHORT) AND REVEAL WHAT IS MISSING FROM THE SHORT LIST PLEASE?
This formula detects any value that does not occur twice (or more) in the combined columns.
= UNIQUE(VSTACK(columnA, columnB),,TRUE)
It appears that there are entries in the shorter list B that are not in A. One way of eliminating them from the result would be to modify the formula to read
= UNIQUE(VSTACK(columnA, columnB, columnB),,TRUE)