縱橫加總等於輸入數 (13252)

C2:F8=TEXT(INDEX(FREQUENCY(ROW(INDIRECT(SUM($B$1:$B1)+1&":"&SUM($B$2:$B2))),SUBTOTAL(9,OFFSET($C$1,,,,{1,2,3}))),COLUMN(A1)),"0;;")



留言