編號 右邊依附左邊 非空 (13073)

E2=COUNTIF(A$2:A2,"<>")

F2=COUNTIFS(E$2:E2,E2,B$2:B2,"<>")

G2=COUNTIFS(E$2:E2,E2,F$2:F2,F2)

F2:G12一式=COUNTIFS($E$2:$E2,$E2,IF(COLUMN(A1)=1,$B2:$B$2,E$2:E2),IF(COLUMN(A1)=1,"<>",E2))