I have a spreadsheet with multiple columns. The first is the master and the 4 or 5 others contain data that I would like to eliminate from the master. How would I perform this function?
ie:
Column 1 Column 2 Column 3
---------------|-------------|--------------|
| | |
test 1 | test 2 | test 2 |
test 2 | test 4 | test 1 |
test 3 | | |
test 4 | | |
test 5 | | |
I would like to remove test 1,2 & 4 from column 1 because they were found in Column (n)