LET+LAMDBA循环求求大神正解
=LET(A,COUNTA(Sheet1!A:A),B,IFERROR(TAKE(HSTACK(Sheet1!A:D,Sheet1!F:G,Sheet1!H:H+Sheet1!L:L,Sheet1!P:P),A),0),C,DROP(DROP(UNIQUE(Sheet1!B:B),1),-1),D,GROUPBY(CHOOSECOLS(B,1),CHOOSECOLS(B,3,4,5,6,7,8),SUM,3,1,,CHOOSECOLS(B,2)=CHOOSEROWS(C,1)),E,LET(F,LAMBDA(X,Y,IF(X=0,Y,F(X-1,HSTACK(CHOOSECOLS(B,3,4,5,6,7,8),SUM,3,1,,CHOOSECOLS(B,2)=CHOOSEROWS(C,X),Y)))),F(COUNTA(C),"")),E)
这套公式,变量D结果是正常的,变量E结果错误,是因为LET函数的作用域问题吗,求大神给出正解,谢谢