79448200

Date: 2025-02-18 12:12:55
Score: 1
Natty:
Report link

Alternatively you can apply this formula.

 =IFNA(DROP(REDUCE("",SEQUENCE(ROWS(A1:A4)),
 LAMBDA(u,v,VSTACK(u,     HSTACK(CHOOSECOLS(A1:A4,v),
 UNIQUE(TOCOL(CHOOSECOLS(B1:O4,v),1)),
 BYROW(UNIQUE(TOCOL(CHOOSECOLS(B1:O4,v),1)),
 LAMBDA(x,SUM(N(SCAN(0,CHOOSECOLS(B1:O4,v),
 LAMBDA(ini,arr,IF(arr=x,ini+1,0)))=4)))))))),1),"")

fruits

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: user22566114