=COUNTA(UNIQUE(FILTER($D$2:$D$24,($A$2:$A$24=$F2)*($B$2:$B$24=COLUMN(D1)))右...
=PIVOTBY(A2:A8,B2:B8,D2:D8,LAMBDA(x,COUNTA(UNIQUE(x))),,0,,0)保持原顺序 =LET(a,A2:A...