countif to present actual results?

[excelNewbie22]

hi,
so i have this example below,
instead of just counting how many of values from f2:h2 appears in o2:q3 i want the results to be spilled, like instead of the current results in s2:u2 1-1-0 i want it to be 13-14 and 13-15, with no blanks
how?

test
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	set1									set2
2	13	14	15	16		13-14	13-15	13-16		13	17	18	15		13-17	13-18	13-15		1	1	0
3										14	13	16	20		13-14	14-16	14-20
test

Cell Formulas
Range	Formula
S2:U2	S2	=COUNTIF(O2:Q3,F2:H2)
Dynamic array formulas.

 

[James006]

Hi,

Sorry ... but I do not understand ...
1. What is the input ?
2. what is the expected output ?

 

[excelNewbie22]

input is from a2:q2, set1 and set2
output expected is 13-14 and 13-15

 

[Fluff]

How about

=LET(a,TOROW(O2:Q3),FILTER(a,COUNTIFS(F2:H2,a)))

 

[shinigamilight]

=IF(COUNTIFS(O2:Q3,F2:H2),F2:H2,"")

 

[excelNewbie22]

thank you Fluff,
and thank you too, shinigamilight

​

 

[Fluff]

Glad we could help & thanks for the feedback.