Reputation: 63
I have two columns in a google sheet and want to retrieve the values of one of the columns that are not in the other column
Upvotes: 3
Views: 2644
Reputation: 1
try:
=FILTER(A:A; NOT(COUNTIF(B:B; A:A)))
Upvotes: 2