EXCEL函数公式

更新时间2021-09-30 13:24:45

=AVERAGE(SMALL(IF(COUNTIF(A2:L2,A2:L2)>1,"",A2:L2),ROW(INDIRECT(1+(SUM(1*(COUNTIF(A2:L2,A2:L2)>1))<7)&":"&12-SUM(1*(COUNTIF(A2:L2,A2:L2)>1))-(SUM(1*(COUNTIF(A2:L2,A2:L2)>1))<7)))))

相关标签:公式