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

Ãö©ó¦p¦ó¤ñ¹ï¸ê®Æ¿ï¨ú¥X¤£­«ÂЪº¸ê®Æ°ÝÃD?

Ãö©ó¦p¦ó¤ñ¹ï¸ê®Æ¿ï¨ú¥X¤£­«ÂЪº¸ê®Æ°ÝÃD?

½Ð°Ý¦U¦ì¤j¤j¡G
­n¦p¦ó¤ñ¹ï¨âÄæ¸ê®Æ¿ï¨ú¥X¤£­«ÂЪº¸ê®Æ¥X¨Ó??(¸Ô¦pªþ¥ó 112.rar (1.72 KB) )

°}¦C¤½¦¡:
=INDEX(B:B,SMALL(IF((COUNTIF(A:A,B$2:B$6)=0)*(B$2:B$6<>""),ROW($2:$6),4^8),ROW(A1)))&""

TOP

¦^´_ 2# ­ã´£³¡ªL

½Ð±Ð­ã´£³¡ªL¤j¤j¡G¤½¦¡¤¤4^8ªº·N«ä¬O¤°»ò...??

TOP

¦^´_ 2# ­ã´£³¡ªL

½Ð±Ð­ã´£³¡ªL¤j¤j¡G¦³¥Î¤F°}¦C¤½¦¡...¥i¤£¾å±o¬°¤°»ò¤£¦æ,½Ð¤j¤j«ü¾É§Ú¤@¤U°ÝÃD¥X¦b­þ¸Ì..??(¸Ô¦pªþ¥ó 101.rar (9.93 KB) )

TOP

¦^´_ 3# jumky


   
4^8 = 65536
2003ª©¤u§@ªíÁ`¦C¼Æ, ¤£²Å¦X±ø¥óªÌ, ¨ú¦¹®æ¬°­È(³q±`¬°¥¼¨Ï¥ÎªºªÅ®æ)

TOP

¦^´_ 4# jumky


¨ú¥X¡e¢ÐÄ榳ªº¡D¢ÏÄæ¨S¦³ªº¡f¡A
¢ÐÄ樺´X­Ó³£»P¢ÏÄæ­«ÂСA·íµM¨S¦³²Å¦Xªº¡I¡I¡I

TOP

¦^´_ 6# ­ã´£³¡ªL

¶â~~¤F¸Ñ..ÁÂÁ­㴣³¡ªL¤j¤j:)

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD