Excel: Check if column A has any values from Column B, and delete that value from Column A

microsoft excelworksheet-function

So I have two columns in Excel with these values suppose:

Column A | Column B
---------|---------
12       | 626
241      | 129
35       | 412
412      | 88
532      | 663
626      |
723      |
88       |
932      |

What formula should I use to delete the values 88, 626 and 412 from Column A (applying the formula then going to Goto > Goto Special > Errors... and deleting rows)

Can't quite get this sorted at all!

Best Answer

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.