- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 14
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-6
|
¦^´_ 1# jj369963
°ÝÃD1¡G¨Ó·½¸ê®Æ«e«á·|¦³§¨´í¡A¦p¦ó§R°£
D2=IF(LEFT(A2,1)<>" ",A2,TRIM(A2))
°ÝÃD2¡G¦p¦ó¥Î®æ¦¡¤Æ³]©w¡A¼Ð°O2Ä檺°ß¤@È¡A¦p¥k(¥Î¤½¦¡®M¥Î¦b®æ¦¡¤Æ¡A«D¤â°Ê)
D2®æ¦¡¤Æ³]©w : =COUNTIF($D$2:$E$18,D2)=1
°ÝÃD3¡G¦p¦ó¥Î®æ¦¡¤Æ³]©w¡A¼Ð°O2Ä檺«½ÆÈ¡A¦p¥k(¥Î¤½¦¡®M¥Î¦b®æ¦¡¤Æ¡A«D¤â°Ê)
D2®æ¦¡¤Æ³]©w : =AND(COUNTIF($D$2:$D$18,D2)<>0,COUNTIF($E$2:$E$18,D2)<>0)
°ÝÃD4¡G¦p¦ó¿z¿ï¥X2ÄæÓ§Oªº°ß¤@È
F2=IF(COUNTIF($D$2:$E$18,$D2)=1,$D2,"")
°ÝÃD5¡G¦p¦ó¿z¿ï¥X2Ä櫽ÆÈ
H2=IF(AND(COUNTIF($D$2:$D$18,D2)<>0,COUNTIF($E$2:$E$18,D2)<>0),D2,"")
®æ¦¡¤Æ»P¿z¿ï½Ð±Ð-A.zip (8.74 KB)
|
|