判斷數值是否大於50 (13405)

T6=LEFT(SUBSTITUTE(SUBSTITUTE(MID(SUMPRODUCT(((K6:Q6>50)+8)*100^-COLUMN(A:G)),3,99),"8",","),"09","1,"),13)

另解=N(K6>50)&","&N(L6>50)&","&N(M6>50)&","&N(N6>50)&","&N(O6>50)&","&N(P6>50)&","&N(Q6>50)

右拉 7格 第一格式結果=IF(COLUMN(A1)=1,"",",")&N(K6>50)&U6