I’m comparing 2 columns
some values are missing from column b (1st column)
can you please help me how to use query function to return missing values.
I know that I can use filter and match and isna function, but I was told to use query function
=QUERY(B3:B, "SELECT B WHERE B IS NOT NULL AND B NOT IN (D3:D)", 0)
New contributor
philip barbican is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.