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

¦³Ãö¦Û°ÊÅܦâ¤Î³Ñ¾l¸ê®Æ°ÝÃD?

¦³Ãö¦Û°ÊÅܦâ¤Î³Ñ¾l¸ê®Æ°ÝÃD?

½Ð°Ý¤j¤j¡G
¸Ó¦p¦ó¦b¶i³f«¬¸¹¸ò²Î­p¼ÐÅÒÄæ¸Ì³]¤½¦¡?
¸Ô¦pªþ¥ó Book1.rar (2.23 KB)

¦^´_ 1# jumky
°ÝÃD1¡G
¶i³f«¬¸¹A2³]©w®æ¦¡¤Æ±ø¥ó
=COUNTIF(¥X³f«¬¸¹!$A:$A,$A2)>0
¦V¤U½Æ»s®æ¦¡
°ÝÃD2¡G
²Î­pA2°}¦C¤½¦¡¦V¤U½Æ»s
{=INDIRECT("¶i³f«¬¸¹!A"&SMALL(IF((COUNTIF(¯S§O«¬¸¹!A:A,¶i³f«¬¸¹!$A$2:$A$7)=0)*(COUNTIF(¥X³f«¬¸¹!A:A,¶i³f«¬¸¹!$A$2:$A$7)=0),ROW($A$2:$A$7),""),ROW(A1)))}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°ÝHsieh¤j¤j..
¬OÅý´å¼Ð°±©óA2Äæ¦ì,µM«á¦A¦Ü®æ¦¡/³]©w®æ¦¡¤Æ±ø¥ó¸Ìªº±ø¥ó¤@¿ï¾Ü¤½¦¡¬°...=COUNTIF(¥X³f«¬¸¹!$AA,$A2)>0¶Ü?..¥i¬O¥¦·|¥X²{"¤£¯à¦b®æ¦¡¤Æªº·Ç«h¤¤°Ñ·Ó¨ì¨ä¥L¤u§@ªí©Î¬¡­¶Ã¯"ªº°T®§?
¥t¥~..¦b²Î­p¿é¤J°}¦C¤½¦¡...¤W­±«ö§¹ENTERÁ䤣·|¥X²{µ²ªG....´NÁÙ¬O¤½¦¡...??
¤£¦n·N«ä..§Ú¤Ó²Â¤F....¯à§_½Ð¤j¤j»¡©ú¸Ó¦p¦ó¾Þ§@¤~¹ï...??

TOP

¦^´_ 3# jumky
©êºp!§Ñ°O2003ª©·|¦³¦¹­­¨î
¥u­n§â¥X³f«¬¸¹!A:A©w¸q¦WºÙ

µM«á¦b®æ¦¡¤Æ±ø¥ó¤Þ¥Î¦W¸q§Y¥i

¦Ü©ó°}¦C¤½¦¡½Ð¬Ý©³¤U³sµ²¤å³¹
http://forum.twbts.com/thread-1277-1-1.html
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    Hsieh¤j¤j±z¦n¡G
§Ú¤w¸g·Ó±z»¡ªº©w¸q¦WºÙ..¥iÁÙ¬O¤@¼Ë¥X²{"¤£¯à¦b®æ¦¡¤Æªº·Ç«h¤¤°Ñ·Ó¨ì¨ä¥L¤u§@ªí©Î¬¡­¶Ã¯"ªº°T®§?
§Ú§â¥Îªº©ñ¦bªþ¥ó...ÁٽФj¤j«üÂI... Book1.rar (2.28 KB)

TOP

¦^´_ 5# jumky
¶i³f«¬¸¹!A2³Q¿ï¨úª¬ºA¤U¿é¤J¡A¦p¹Ï

µM«á¦A¥Î½Æ»s®æ¦¡¨ê¡A¦V¤U½Æ»s®æ¦¡
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    Hsieh¤j¤j±z¦n¡G§Ú·Ó±z»¡ªº¾Þ§@³]®æ¦¡¤Æ±ø¥ó..¥i·í«ö¤U½T©w®É´N·|¥X²{¿ù»~°T®§.¦p¤U¡G
   

TOP

¦^´_ 7# jumky

¤O°¨À°À°¦£!
½Ð§A¬Ý²M·¡¤½¦¡
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ jumky ©ó 2011-1-17 22:42 ½s¿è

¦^´_ 8# Hsieh


    Hsieh¤j¤j..¤£¦n·N«ä...¦]¬°§A²Ä¤@¦¸poªº¤½¦¡¸ò²Ä¤G¦¸ªº¤£¤@¼Ë...§Ú¥H¬°³£¤@¼Ë´N¤@ª½¥Î±z²Ä¤@¦¸poªº....²{¦b¥i¥H¤F...ÁÂÁ±z....¤£¦n·N«ä.Åý±z¶O¤ß¤F...

TOP

Hsieh¤j¤j¡G
¯à§_³Â·Ð±z¸ÑÄÀ¤@¤U{=INDIRECT("¶i³f«¬¸¹!A"&SMALL(IF((COUNTIF(¯S§O«¬¸¹!A:A,¶i³f«¬¸¹!$A$2:$A$7)=0)*(COUNTIF(¥X³f«¬¸¹!A:A,¶i³f«¬¸¹!$A$2:$A$7)=0),ROW($A$2:$A$7),""),ROW(A1)))}¸Ìªº¤½¦¡·N«ä...¦]¬°·Q¨ä¥Lªí®æ¤]¯à¾Ç¥H­P¥Î....½Ð¤j¤j«üÂI...^^...¥t¥~¸Ì­±ªºROW($A2:$A$7)¤ÎROW(A1)¬O«ü²Î­pªº¼ÐÅҸ̶Ü.. ??

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD