Need help on Permutation & Occurance Count

[DigitNoob]

Hello, need help from you guys on permutation.
if I have a large amount of data .. say tens of columns & hundreds of rows of it.. each with 4 digit of numbers.
And I would like to count the occurance of certain numbers and all of its permutations…
For example if i want to find out the occurance of 3589 & all its permutations, the result will show 3.
And it will list down 3859 in row 2, 3895 in row 4 & 9835 in row 12 respectively ..? (see attachment here)
Appreciate if anybody who is expert in excel can guide me along. Thanks in advance.

 

[lrobbo314]

This seems to work based on the test data. Here is a formula, for the permutations, that you will need for the final solution.

PERMUTX

=LAMBDA(
    range,repitition,
        LET(
            v,range,
            c,COUNTA(v),
            n,MID(TEXT(BASE(SEQUENCE(PERMUTATIONA(c,c),,0),c),REPT("0",c)),SEQUENCE(,c),1)+1,
            pa,INDEX(v,n),
            nj,BYROW(pa,LAMBDA(ro,TEXTJOIN(,,ro))),
            f,BYROW(nj,LAMBDA(ro,SUM(IF(LEN(ro)-LEN(SUBSTITUTE(ro,v,"")),1,0))=c)),
            IF(repitition,pa,FILTER(pa,f))
        )
)

digit_noob
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	4853	8663	7842	6681	3206	8536	2242	4201	9413	6321		Find:	3859
2	3859	1101	7626	9529	1455	1439	3076	5382	2432	1083		Permutations:	3
3	6900	1096	3577	1580	2031	7749	3840	9409	6355	9729
4	9011	9844	1443	3895	3315	7954	6946	7061	2871	1579
5	9290	6138	7628	2895	1275	2549	8228	4791	9094	8590
6	6224	1049	1056	4501	5538	9982	7761	3493	3175	3238
7	1636	6744	4396	4003	6610	9602	2192	7618	5355	2961
8	3233	2721	9227	3214	4713	3975	1858	7527	5381	5192
9	8673	4902	4538	9422	4066	8582	4559	5590	9050	4508
10	4403	9175	7578	3487	7616	2672	3075	7382	3720	5827
11	6531	5618	1025	1188	1849	3988	6624	1996	6091	6312
12	5047	6689	4680	7300	8030	4907	5897	9835	6259	4534
Sheet2

Cell Formulas
Range	Formula
M2	M2	=SUM(BYROW(PermutX(MID(M1,SEQUENCE(LEN(M1)),1),0),LAMBDA(br,SUM(--(A1:J12=CONCAT(br)+0)))))

 

[DigitNoob]

Hi fren Irobbo314, many thanks for your guidance. I paste SUM(BYROW).... formulas into worksheet but i received "#Name?" message.
Could it be the typo error? How to solve it? appreciate ur help. tq.

 

[DigitNoob]

Hi fren, also i see there is a PERMUTX & Lambda formula as mentioned above.. how to apply this ya..?
Sorry for so many questions.. as i am not expert in programming & excel. many thanks for your help. Cheers.