åå®è¦ç»è®¡A2:A100åºåçéåä¸éå¤çåå
æ ¼æ°éï¼å
¬å¼å¦ä¸ï¼
=SUM((SUBTOTAL(3,OFFSET(A1,ROW(1:99),,))=1)*(MATCH(A2:A100&SUBTOTAL(3,OFFSET(A1,ROW(1:99),,)),A2:A100&SUBTOTAL(3,OFFSET(A1,ROW(1:99),,)),)=ROW(1:99)))
å
¬å¼ä»¥CTRL+SHIFT+ENTERä¸é®ç»æã
温馨提示:答案为网友推荐,仅供参考