本帖最后由 水中杯 于 2019-8-8 21:12 编辑 怎么提取的结果不一样呀
AP4=IF(OR(COUNTIF($B3:$G3,I3)=1,COUNTIF($B3:$G3,J3)=1),I4,"")
AQ4=IF(OR(COUNTIF($B3:$G3,I3)=1,COUNTIF($B3:$G3,J3)=1,COUNTIF($B3:$G3,K3)=1),J4,"")
拖住AQ4向后拉到BU4填充公式
BV4=IF(OR(COUNTIF($B3:$G3,AN3)=1,COUNTIF($B3:$G3,AO3)=1),AO4,"")