[Google sheet] Check if values in list exists in another list and show them in range

**jaryszek** · 09-21-2021, 02:19 AM

hi,

i have 2 ranges:

First ("A1:A3"):
Cat,
Dog,
Elephant

Second ("B1:B3"):
Cat,
Dog

and in "C1" i want to get Elephant (it exists only in first list and not exists in second).
How can i do this in google sheet?

Thank you for help,
Best,
Jacek

**Haluk** · 09-21-2021, 03:58 AM

In C1, try this formula; (Assuming the sheet name is "Sheet1")

Note: You may need to change semicolons (;) to commas (,) depending on your locale settings in Google Sheets.

Please Login or Register  to view this content.

**rorya** · 09-21-2021, 04:26 AM

As an alternative:

=FILTER(A1:A,COUNTIF(B1:B,A1:A)=0)

**jaryszek** · 09-21-2021, 04:50 AM

Working like a charm!

Thank you,
Jacek

[Google sheet] Check if values in list exists in another list and show them in range

LinkBack

Thread Tools

Rate This Thread

Display

[Google sheet] Check if values in list exists in another list and show them in range

Re: [Google sheet] Check if values in list exists in another list and show them in range

Re: [Google sheet] Check if values in list exists in another list and show them in range

Re: [Google sheet] Check if values in list exists in another list and show them in range

Thread Information

Users Browsing this Thread

Similar Threads

Check list A for missing values in list B

Populating check box values from a list on another sheet

Way to filter an RSS feed vs a list and show only values not in that list?

[SOLVED] check if worksheet already exists when auto creating worksheets form a list

How to show the calculations if the matching values exists in the selection series of list

Check if sheet from list exists in workbook

Check if a list of Files exists Macro

Bookmarks

Bookmarks

Posting Permissions