CODEWITHSUNDEEP
google-sheetsfiltergoogle-sheets-formulacountingcountif
Random I.T
Random I.T

Reputation: 131

How to return data that does not exist in another column?

I have two columns namely Column A and B, I would like to return a list of names based from column that is not in column B.

Column A
---------
A
B
C
D
E


Column B
---------
E
B
A

Return
----
C
D

May I know is it possible to make such query ?

Upvotes: 2

Views: 2051

Answers (1)

player0
player0

Reputation: 1

use:

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

0

Upvotes: 3

Related Questions