ªð¦^¦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......^^

TOP

¦^´_ 17# jumky

¦pªþ¥ó
    »²§UÄæ.rar (4.25 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

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

TOP

¦^´_ 15# jumky
°}¦C¤½¦¡ªº³Ì¤jÃa³B´N¬O·|³y¦¨¹Bºâ¹L©ó½ÆÂø
«Øij¨Ï¥Î»²§UÄæ¨Ó°µ¡A³t«×·|®t«Ü¦h
¤£µM´N¥u¦³¥ÎVBA¥u¨ú±o­È
¦U¦³§Q¹ú¡A¬Ý§A­n¬Æ»ò¤è¦¡
¾Ç®üµL²P_¤£®¢¤U°Ý

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

¦^´_ 13# jumky


    {=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)))}
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),"")
³o¬q¬O¦pªG¶i³f«¬¸¹!$A$2:$A$7¨S¥X²{¦b¯S§O«¬¸¹!AÄæ¦Ó¥B¶i³f«¬¸¹!$A$2:$A$7¤]¨S¦b¥X³f«¬¸¹!AÄæ´N¶Ç¦^$A$2:$A$7ªº¦C¸¹¡A§_«h¶Ç¦^ªÅ¥Õ
³o·|²£¥Í¤@­Ó2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C
§Q¥ÎSMALL¨ç¼Æ¨ú¥X¥Ñ¤p¨ì¤jªº¼Æ¦r¡ASMALL·|©¿²¤¤å¦r
ROW(A1)­Y¦V¤U½Æ»s·|±qA1Åܬ°A2¡AA3¡AA4......
³o´N¬OSMALLªº²Ä2­Ó°Ñ¼Æ
ROW(A1)¶Ç¦^1´N¬O¨ú2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C¤¤ªº³Ì¤p­È
ROW(A2)¶Ç¦^2´N¬O¨ú2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C¤¤ªº²Ä¤G¤p­È
¥H¦¹Ãþ±À
³Ì«á¨Ï¥ÎINDIRECT¨ç¼Æ«ü¨ìÀx¦s®æ
"¶i³f«¬¸¹!A"¬O»¡­n«ü¨ì¶i³f«¬¸¹!AÄæ
SMALL¨ú±oªº­È´N¬O¦C¸¹
¨Ò¦p
2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C¤¤³Ì¤p­È¬O3
¨º»ò
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¶Ç¦^3
°t¦X "¶i³f«¬¸¹!A"&
´N±o¨ì¦r¦ê"¶i³f«¬¸¹!A3"
©Ò¥H¸ÓÀx¦s®æ´N·|±o¨ì¶i³f«¬¸¹!A3ªº­È
¾Ç®üµL²P_¤£®¢¤U°Ý

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

¦^´_ 11# jumky
ROW(A1)·|¶Ç¦^1
·|­«ºâ«Ü¤[À³¸Ó¬O¨Ï¥Î°}¦C¤½¦¡§a
­n¬Ý¾ã­Ó¤u§@ªí¤½¦¡ªº¨Ï¥Î¶q¤~ª¾¹D¤°»ò°ÝÃD
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD