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

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

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

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

½Ð°Ý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

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

¦^´_ 6# Hsieh


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

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

½Ð°ÝHsieh¤j¤j¡G
¤½¦¡¸ÌROW(A1)¬O«ü­þ¸Ì..?ÁÙ¦³¨C¦¸¶}³o­ÓÀÉ®×®É...¥¦³£·|¦Û°Ê­«ºâÀx¦s®æ­nµ¥«Ü¤[....½Ð°Ý¸Ó¦p¦ó¥[§Ö¥¦ªº³t«×?

TOP

½Ð°ÝHsieh¤j¤j¡G
ROW(A1)¬O«ü¶i³f«¬¸¹¸ÌªºA1...ÁÙ¬O²Î­p¼ÐÅҸ̪ºA1...?
¨S¿ù¬O¨Ï¥Î°}¦C¤½¦¡©Ò¥HÅܱo½wºC....¥i¥¦¥²¶·¨Ï¥Î°}¦C¤½¦¡¤~¯à­«·s­pºâ...¦Ó¨C¦¸¶}¦¹ÀÉ...´N·|¶]«Ü¤[...¨C°µ¤@­Ó°Ê§@¤]·|¶]«Ü¤[....³s±a¨ä¥L¶}±ÒªºEXCELÀɤ]·|Åܱo°Ê§@½wºC....½Ð°Ý¦³¤°»ò¤èªk¥i¥HÁקK¦¹±¡§Îµo¥Í...??

TOP

¥»©«³Ì«á¥Ñ jumky ©ó 2011-1-27 23:45 ½s¿è

¶â...¤F¸Ñ..ÁÂÁÂHsieh¤j¤j¸Ô²Ó¸Ñ»¡...^^¤£¦n·N«ä,¦A¦¸½Ð°Ý¤j¤j,¦]¬°§Ú¨Ï¥Î°}¦C¤½¦¡ªº¸ê®Æ¦³±Nªñ200µ§..¬O§_¦]¨Ï¥Î¤F¹L¦h°}¦C¤½¦¡...¾É­Pexcel­«ºâÀx¦s®æ®É¾ã­Ó¤å®Ñ³B²z§@·~½wºC...´N³s¦sÀɤ]¹³·í¾÷¤@¼Ë....??½Ð°Ý¬O§_¦³¸Ñ¨M¤èªk,¯à¨Ï¥Î¸Ó¤½¦¡¤S¤£­P©óÅýexcel¤@¶}±Ò´N²£¥Í§@·~½wºC²{¶H..??

TOP

¥»©«³Ì«á¥Ñ jumky ©ó 2011-1-28 13:52 ½s¿è

¶â...ÁÂÁÂHsieh¤j¤j....^^...¨º½Ð°Ý¦pªG¤£¥Î°}¦C¤½¦¡¥Î»²§UÄæ...¸Ó¦p¦ó¥Î..??

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD