carlos
carlos

Reputation: 63

How can I retrieve the values in a column that are not contained in another column in google sheets

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

Answers (1)

player0
player0

Reputation: 1

try:

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

enter image description here

Upvotes: 2

Related Questions