2Äæ²Å¦XÃöÁä¦r¦b¥t¤@Äæ§@¼Ð¥Ü
- ©«¤l
- 91
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 130
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-5-14
- ³Ì«áµn¿ý
- 2020-5-17
|
¦^´_ 1# leiru
¶ñ¤JC2¡A¨ä¾l¤U©Ô
°Ñ¦Ò¬Ý¬Ý
¤½¦¡1- =IF(OR(SUMPRODUCT((LEFT(A2,LEN($E$2:$E$4))=$E$2:$E$4)*($E$2:$E$4<>""))>0,SUMPRODUCT((LEFT(B2,LEN($F$2:$F$4))=$F$2:$F$4)*($F$2:$F$4<>""))>0),"²Å¦X","")
½Æ»s¥N½X ¤½¦¡2- =IF(OR(SUMPRODUCT(COUNTIF(A2,$E$2:$E$4&"*")*($E$2:$E$4<>"")),SUMPRODUCT(COUNTIF(B2,$F$2:$F$4&"*")*($F$2:$F$4<>""))),"²Å¦X","")
½Æ»s¥N½X |
|
|
|
|
|
|