|
``都到5了
AL6输入- =IF(AND(AN6:$AR6=""),IF(AND(SUM(1/COUNTIF($AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2),$AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2)))<3,SUM(QUARTILE($AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2),{0,4})*{-1,1})<>1),$AD6,""),"")
复制代码 AM6输入- =IF(AND(AN6:$AR6=""),IF(AND(SUM(1/COUNTIF($AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2),$AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2)))=2,SUM(QUARTILE($AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2),{0,4})*{-1,1})<>1),MIN(IF($AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2)<>$AD6,$AD6:INDEX($AD6:$AK6,4+COLUMN(B1)/2),99)),""),"")
复制代码 还是早上的玩法``
都是数组公式
组合键结束后
选择AL6:AM6右拉到AQ6
再下拉即可
|
|