Excel: Check if column A has any values from Column B, and delete that value from Column A
Sometimes (your case for example), errors may be useful. There's function NA(), which will display #N/A error in a cell. Combining it with IF and COUNTIF will give the desired result.