¦p¦ó§PÂ_¬°¦P¤@²Õ(¶i¶¥°ÝÃD¡^
- ©«¤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
|
¦^´_ 3# s7659109
¼Ð¥Üx¡G
G2¶ñ¤J¡A¨ä¾l¤U©Ô- =IF(COUNTIFS(A:A,A2,B:B,B2)=COUNTIFS(A:A,A2,B:B,B2,D:D,D2),"","x")
½Æ»s¥N½X ¼Ð¥Ü¤Ï¶À¡G
®æ¦¡¤Æ±ø¥ó
¨Ï¥Î¤½¦¡¨M©w®æ¦¡¤Æ- =COUNTIFS($A:$A,$A2,$B:$B,$B2)<>COUNTIFS($A:$A,$A2,$B:$B,$B2,$D:$D,$D2)
½Æ»s¥N½X ½d³ò¡GA2:G27 |
|
|
|
|
|
|