excel - I have 2 columns with values. Trying to find which values in Column A that are not in Column B -

column has 868 rows , column b has 452 rows. how find values in column not in column b?

a quick way use helper column, let's c. can use countif() check, if() make logical:

=if(countif($b:$b,$a1)=0,"not in col. b","")

i wouldn't use entire b column, calculating/processing time, adjust range necessary. sort column c bring "not in col. b" top.

edit: ah, it's @pnut's suggestion, little more ease of reading. also, want add if($a1<>"",...) make sure blank cells don't return "not in col. b"