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.
=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.