B8{=IFERROR(SUM(1/COUNTIF(OFFSET(A7,,,LOOKUP(1,0/(A$1:A7=A8),ROW($1:7))-ROW()),OFFSET(A7,,,MAX(LOOKUP(1,0/(A$1:A7=A8),ROW($1:7))-ROW())))),"")
另解B2{=COUNT(0/(COUNTIF(OFFSET(A$1,,,ROW($1:7)),A$1:A7)=COUNTIF(A$1:A7,A$1:A7))/(ROW($1:7)>=LOOKUP(1,0/(A$1:A7=A8),ROW($1:7))))
另解B2{=COUNT(1/FREQUENCY(MATCH(A1:INDIRECT("A"&MAX((A2=$A$1:$A1)*ROW($1:1))),$A$1:$A1,),ROW($1:$99)))
留言
張貼留言