cross querytabel like

[lpvdsteen]

it must be easy, but I am staring at the screen a bit blank
excel 365 in this case
Ik have 2 columns, 0ne with, say, functions, one with, say, roles, both are multiple in the columns, but the match should only exist once or not
I want a table with header functions, rows vertically and a 1 (of x or other marking) when there is a match.
Then, to make it more complex, if that is at all possible, based on a diffent variable, the selection of roles an functions may vary, als in number. These roles and functions i fill with a filter so these are automatically filled out

So, how do I get the 1's in place? I tried a sort of double filter: =FILTER(($A:$A*0)+1,($A:$A=E$1)*($B:$B=$D3),"") but not to the desired effect.

 

[Alex Blakenburg]

I am not sure I fully understand where you are at but see if this does what you need.
An XL2BB would have been useful. It would have also given visibility over what this means

These roles and functions i fill with a filter so these are automatically filled out

If you don't want to see 0's you can either use an If statement or just suppress them with a custom format.
If you don't want to know if something is > 1 then use an If statement to return "" or "X"

Note: Your profile says Excel 2016 but you are clearly using 365, you might want to update your profile.

Book1
	A	B	C	D	E	F	G	H	I
1	funct	Role		SELECTION
2	adm1	add
3	adm	del			adm	asb	cb	bg	lm
4	asb	rem		add	0	1	1	0	0
5	asb	add		del	1	0	0	0	0
6	lm	rem		chg	0	0	0	0	0
7	cb	add		rem	0	1	0	0	1
8	adm1	del		sav	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
E4:I8	E4	=COUNTIFS($A$2:$A$8,E$3,$B$2:$B$8,$D4)

 

[lpvdsteen]

Thanks Alex, My profile is correct, but in this case, i use 365. That's why i expressly mentioned that in mij questio
The countifs will do it, and do do it, the problem however being that they don't fill out; i will have to do that myself.
That's why i was looking at a possibility usen an array like function for this (and a reason for using the 365 version)

But thanks for thinking along

 

[Alex Blakenburg]

Do have a dynamic array formula in the func & role heading areas