79791290

Date: 2025-10-15 14:45:22
Score: 1.5
Natty:
Report link

Does this formula return the desired result? I'm not sure if the translation to french is correct therefore i've added the english formula in addition.

=SI.NON.DISP(EXCLURE(REDUCE("";UNIQUE(B3:B32);LAMBDA(u;v;ASSEMB.V(u;v;ORGA.LIGNES(FILTRE(C3:C32;B3:B32=v);4;"");"")));1);"")

=IFNA(DROP(REDUCE("",UNIQUE(B3:B32),LAMBDA(u,v,VSTACK(u,v,WRAPROWS(FILTER(C3:C32,B3:B32=v),4,""),""))),1),"")

reduce

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