- =SUM({1,-1}*SUBTOTAL(9,OFFSET(A2,,,LARGE((COUNTIF(OFFSET(A31,,,ROW(1:30)-31),A2:A31)=1)*ROW(1:30),{7,8})),OFFSET(B2,,,LARGE((COUNTIF(OFFSET(B31,,,ROW(1:30)-31),B2:B31)=1)*ROW(1:30),{7,8})),OFFSET(C2,,,LARGE((COUNTIF(OFFSET(C31,,,ROW(1:30)-31),C2:C31)=1)*ROW(1:30),{7,8})),OFFSET(D2,,,LARGE((COUNTIF(OFFSET(D31,,,ROW(1:30)-31),D2:D31)=1)*ROW(1:30),{7,8})),OFFSET(E2,,,LARGE((COUNTIF(OFFSET(E31,,,ROW(1:30)-31),E2:E31)=1)*ROW(1:30),{7,8})),OFFSET(F2,,,LARGE((COUNTIF(OFFSET(F31,,,ROW(1:30)-31),F2:F31)=1)*ROW(1:30),{7,8})),OFFSET(G2,,,LARGE((COUNTIF(OFFSET(G31,,,ROW(1:30)-31),G2:G31)=1)*ROW(1:30),{7,8}))))
复制代码 真心佩服你们这些高手们,晕死,我弄了三天才过800个字
|