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