Formula to display values in one column that do NOT appear in another column

Solution for Formula to display values in one column that do NOT appear in another column
is Given Below:

I want to know which values in column A do NOT appear anywhere in column B. Right now I have conditional formatting to highlight those cells, but I’d love to have a listing of the values in another column so that I don’t have to manually go through and pull the values myself.

Sample sheet is here.

try:

=FILTER(A2:A, NOT(COUNTIFS(B2:B, A2:A)))

I’m pretty sure this should do it. I put it in your sheet.

Update, sorry I misread first time.

=FILTER(A2:A,ISERROR(MATCH(A2:A,$B:$B,FALSE)))