Count unique values based on critera with match in named range

[ausswe]

Hi,
I'm trying to figure out a way to count the unique number of values based on two criteria, where one criteria is dependent on a list (named range).

=SUM(--(LEN(UNIQUE(FILTER(Table1[ID];(Table1[MONTH]=$S$1)*(Table1[VALUES]=NamedRange);"")))>0))

What would the best way be to count the unique IDs for one month if ANY of the values in the table 'VALUES' match the entries in the named range ('NamedRange' in the formula).

Thanks in advance!

 

[Fluff]

How about

=SUM(--(LEN(UNIQUE(FILTER(Table1[ID];(Table1[MONTH]=$S$1)*(isnumber(xmatch(Table1[VALUES];NamedRange)));"")))>0))

 

[ausswe]

Did not see that one coming!

Thank you so much Fluff - it worked!

 

[Fluff]

You're welcome & thanks for the feedback.