mardi 1 octobre 2019

Google Sheets: How to select elements of a column of which a corresponding columns contains elements that are in a given list?

I have a surprisingly tricky problem to solve in Google Sheets, which must be not too hard, but somehow I don't manage. It is a large sheet, but it boils down to the following:

Two Google Sheet columns:

Data 1  Data 2      
aa    2008              
bb    2008              
cc    2009              
dd    2010          
ee    2011          
ff    2012          
bb    2013          
gg    2014          
cc    2015          
hh    2016          
ii    2017      

(Mark: there are re-occuring elements in column 1)

The problem: I have a sublist, a column containing a bunch of elements, say: aa, bb and cc

I want a filter to create a list with all the years which "contain" (at least) one of the elements in this list. In this example (using Uniqe) that would result in the list [2008, 2009, 2013, 2015]

I have tried Filter / Error / Match / Lookup / Vlookup, but I just cannot manage.

I have searched the fora a lot but cannot find this particular situation. Anyone an idea how to tackle this in Google Sheets?

Aucun commentaire:

Enregistrer un commentaire