F3{=SUM(N(LEN(OFFSET(A$3,,MAX(ROW(A1)-1),5))-1=MMULT(N(IFERROR(CODE(MID(OFFSET(A$3,,MAX(ROW(A1)-1),5),COLUMN(A:Y),1))<CODE(MID(OFFSET(A$3,,MAX(ROW(A1)-1),5),COLUMN(B:Z),1)),)),ROW(1:25)^0)))
另解=SUMPRODUCT(N(MMULT(N(MID(OFFSET(A$3,,MAX(ROW(A1)-1),5),COLUMN(A:Y),1)<MID(OFFSET(A$3,,MAX(ROW(A1)-1),5),COLUMN(B:Z),1)),ROW(1:25)^0)=LEN(OFFSET(A$3,,MAX(ROW(A1)-1),5))-1))
留言
張貼留言