View Single Post
  #2   Report Post  
ExcelBen ExcelBen is offline
Junior Member
 
Posts: 4
Default

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.