G2:G7{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(COUNTIF(B:B,B$2:B$23)=COUNTIF(OFFSET(B$2,,,ROW($1:$22)),B$2:B$23),MMULT(COUNTIFS(OFFSET(B$2,,,ROW($1:$22)),B$2:B$23,OFFSET(C$2,,,ROW($1:$22)),H$1:J$1),10^{6;4;2})+ROW($2:$23)),ROW(A1)),2)),"")
H2:J7=IF($G2="","",COUNTIFS($B:$B,$G2,$C:$C,H$1))
F2:F7{=IF(G2="","",N(F1)+1-AND(H1:J1=H2:J2))
留言
張貼留言