Forum Discussion
Use multiple cells on one sheet to delete cells with same value on another sheet
Let's say the list on Sheet A is in A2:A1000, and the list on Sheet B is in D2 and down.
In E2 (or another cell in row 2) on Sheet2, enter the formula
=ISNUMBER(MATCH(D2,'Sheet A'!$A$2:$A$1000,0))
(use the actual sheet name and range)
Fill down.
You can now filter the column with the formulas on the value TRUE.
Then delete the visible cells in column B.
Turn the filter off.
Let's say the list on Sheet A is in A2:A1000, and the list on Sheet B is in D2 and down.
In E2 (or another cell in row 2) on Sheet2, enter the formula
=ISNUMBER(MATCH(D2,'Sheet A'!$A$2:$A$1000,0))
(use the actual sheet name and range)
Fill down.
You can now filter the column with the formulas on the value TRUE.
Then delete the visible cells in column B.
Turn the filter off.
HansVogelaar fantastic! Thank you so much!!