起止數之間 各個數字不重複的總數 (14153)

日期：

C2:C6{=SUM(N(MMULT(N(FIND(MID(ROW(INDIRECT(A2&":"&B2)),COLUMN(A:F),1),ROW(INDIRECT(A2&":"&B2)))=COLUMN(A:F)),{1;1;1;1;1;1})=LEN(ROW(INDIRECT(A2&":"&B2)))))

D2:E6{=INDEX(PERCENTILE(IF(MMULT(N(FIND(MID(ROW(INDIRECT($A2&":"&$B2)),COLUMN($A:$F),1),ROW(INDIRECT($A2&":"&$B2)))=COLUMN($A:$F)),{1;1;1;1;1;1})=LEN(ROW(INDIRECT($A2&":"&$B2))),ROW(INDIRECT($A2&":"&$B2))),{0,1}),COLUMN(A1))



留言

張貼留言