Count values from one column that are in another

[danielca]

Hi,

Can somebody help me with something. I need to count how many distinct values from one column are in another. For example:

Column A	Column B
A	A
D	B
C	C
A	D
Z	E
X	F
B	G
P	H
I	I
L	J

So, if I want to count distinct values from Column A that are present in Column B, the result would be 5.

Any ideas to do it? Script or graph formula?

[Vegar]

You could use this or a variant of this expression below. 

FindOneOf([Column A], concat(total [Column B]))

I use two variants, one with aggr in the attached qvf.