B2{=-LOOKUP(1,-MID(A2,MIN(FIND(ROW($1:$9),A2&1/17)),{1,2,3}))
F2=COUNTIF(B:B,E2)
G2{=SUM(N(RIGHT(SMALL(IFERROR(MID(A$2:A$16,RIGHT(SMALL(FIND(COLUMN(A:I),A$2:A$16&1/17)+ROW($2:$16)/1%,ROW($1:$15)*9-8)),{1,2,3})*1,)+ROW($2:$16)/1%%,ROW($1:$15)*3),3)-E2=0))
G2數字設定最大999{=SUM(N(RIGHT(SMALL(ISNUMBER(FIND(ROW($1:$999),TRANSPOSE(A$2:A$16)))*ROW($1:$999)+COLUMN(A:O)/1%%,ROW($1:$15)*999),4)*1-E2=0))
留言
張貼留言