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

¨D§U

¨D§U

ªí®æ¤º¦³¤H­û¦b¾±¡ªp,½Ð¦U¦ì¤j¤j«ü±Ð,·Q¥Î¤½¦¡±N¦b¾¤ÎÂ÷¾¤H­ûÅã¥Ü,¦pªþ¥ó

¤H­û.rar (3.28 KB)

¦^´_ 4# Hsieh
ÁÂÁª©¥D,¤½¦¡¹BºâµL»~

TOP

¦^´_ 3# aa7551

D2°}¦C¤½¦¡
=IF(ROW($A1)>COUNTIF($B$2:$B$8,"Yes"),"",INDEX($A:$A,SMALL(IF($B$2:$B$8="Yes",ROW($B$2:$B$8),""),ROW($A1))))
E2°}¦C¤½¦¡
=IF(ROW($A1)>COUNTIF($B$2:$B$8,"No"),"",INDEX($A:$A,SMALL(IF($B$2:$B$8="No",ROW($B$2:$B$8),""),ROW($A1))))

¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
ª©¥D,¨S±N°ÝÃD»¡²M·¡,¬O¤wª¾A,BÄ檬ªp,,­n¨D¸ÑD,EÄæ,,©êºp,¦A¦¸³Â·Ð¤j¤j

TOP

¦^´_ 1# aa7551

B2=IF(ISNUMBER(MATCH(A2,$D:$D,0)),"Yes","No")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD