ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ®æ¦¡¤Æ»P¿z¿ï½Ð±Ð

[µo°Ý] ®æ¦¡¤Æ»P¿z¿ï½Ð±Ð

Dear¤j¤j¡G

¦pªþÀÉ¡A½Ð°Ñ¾\»P«ü¾É

·PÁÂ

®æ¦¡¤Æ»P¿z¿ï½Ð±Ð.zip (6.67 KB)

¦^´_ 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)

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD