T_SF

[Xlambda]

T_SF !! recursive !! tool search/find lambda, shows occurrence pattern of searching/finding an array within another array. calls AFLATTEN

=LAMBDA(a,as,sf,pa,
    LET(d,"|",sa,AFLATTEN(as),s,FILTER(sa,sa<>""),
       n,ROWS(s),x,INDEX(s,n),
       IF(n=1,ATRIM(IF(ISNUMBER(IF(sf,FIND(x,a),SEARCH(x,a))),1&d,"")&pa,d,),T_SF(a,INDEX(s,SEQUENCE(n-1)),sf,IF(ISERROR(IF(sf,FIND(x,a),SEARCH(x,a))),"",n)&d&pa))
    )
)

LAMBDA 7.0.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	T_SF Lambda recursive Tool SEARCH/FIND, shows occurrence pattern of searching/finding an array within other array
2	sample								search/find array
3	ax	b	cw	d	ez	fy			x	y	z	w
4	a	bzw	c	dzx	e	fxw		index	1	2	3	4
5	azwx	b	cyw	d	eXW	fZY
6	a	bYxWz	c	dZWx	e	fYx
7	azwyx	b	c	d	eYXWZ	f
8
9	=T_SF(A3:F7,I10:J11,,)
10	1		4		3	2		sf=0	x	y
11		3|4		1|3		1|4		(search)	z	w
12	1|3|4		2|4		1|4	2|3
13		1|2|3|4		1|3|4		1|2
14	1|2|3|4				1|2|3|4
15
16	=T_SF(A3:F7,I17:I20,1,)
17	1		4		3	2		sf=1	x
18		3|4		1|3		1|4		(find)	y
19	1|3|4		2|4						z
20		1|3		1		1			w
21	1|2|3|4
22
23	=T_SF(A3:F7,I24:L24,0,)
24	1		4		3	2		sf=0	X	Y	Z	W
25		3|4		1|3		1|4		(search)
26	1|3|4		2|4		1|4	2|3
27		1|2|3|4		1|3|4		1|2
28	1|2|3|4				1|2|3|4
29
30	=T_SF(A3:F7,I31:K32,1,)
31								sf=1	X	Y	Z
32								(find)	W
33					1|4	2|3
34		2|4		3|4		2
35					1|2|3|4
36
T_SF post

Cell Formulas
Range	Formula
A9,A30,A23,A16	A9	=FORMULATEXT(A10)
A10:F14	A10	=T_SF(A3:F7,I10:J11,,)
A17:F21	A17	=T_SF(A3:F7,I17:I20,1,)
A24:F28	A24	=T_SF(A3:F7,I24:L24,0,)
A31:F35	A31	=T_SF(A3:F7,I31:K32,1,)
Dynamic array formulas.