79498462

Date: 2025-03-10 15:32:53
Score: 1
Natty:
Report link

Here's a single formula that works using BYROW.

=BYROW(A2:D4,LAMBDA(r,TEXTJOIN(",",1,MAP(UNIQUE(TOCOL(r)),LAMBDA(_,IF(COUNTIF(r,_)>1,COUNTIF(r,_),))))))
Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: bricks96