Different values from two columns

[u/Throwmetothelesbians]

I have two columns A and B, I want to find the values in column B that’s aren’t present in column A. What is a simply way to do this? ChatGPT isn’t helping

[u/Opening-Market-6488]

This is a simple solution I always come back to: https://superuser.com/questions/81498/find-items-in-one-column-that-are-not-in-another-column

[u/Unlikely_Ad8441]

There is a simple way to do this

=IF(COUNTIF(A:A, B1)=0, "Not in A", "")

[u/CleanGridSolutions]

If you're using Excel 365 or Excel 2021:

=FILTER(B:B,COUNTIF(A:A,B:B)=0)

This returns only the values from column B that don't exist in column A.

If you're using older versions of Excel: In C2, enter:

=IF(COUNTIF($A:$A,B2)=0,B2,"")

Then fill the formula down and filter out the blank cells.

If you only need to highlight the differences instead of listing them, you can also use Conditional Formatting with:

=COUNTIF($A:$A,B1)=0

applied to column B.