Update.
I have a solution and a remaining problem.
INTERSECTION
=LAMBDA(as,bs,LET(x,XMATCH(as,bs,0),INDEX(bs,FILTE R(x,ISNA(x)=FALSE))))
returns the intersection between two arrays.
So PRIMES becomes
=LAMBDA(n,INTERSECTION(FACTORS(n),DONOTUSE(n,{0})) )
The remaining issue is that the largest integer this can handle is 334. Very odd.
|