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

[µo°Ý] ½Ð°Ý­n¦p¦ó²Î­p¤£­«½Æ¶µ¥Ø

[µo°Ý] ½Ð°Ý­n¦p¦ó²Î­p¤£­«½Æ¶µ¥Ø

½Ð°Ý­n¦p¦ó²Î­p¤£­«½Æ¶µ¥Ø(¥N¸¹³¡¥÷§Y¥i)


¹Ï¤ù1.png (12.29 KB)

¹Ï¤ù1.png

peter460191

¦^´_ 1# peter460191


    ¬O·Q±o¨ì¤£­«½Æ²M³æ¶Ü?
³o¥Î¶i¶¥¿z¿ï«Ü®e©ö´N¯à±o¨ì


µo°Ý½Ð¸Ô­z±zªº°ÝÃD
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
¶W¯Åª©¥D±z¦n!
¤£¦n·N«ä»y·N¤£²M¡A§Úªº°ÝÃD¬O¡G¦b(BÄæ)¥N¸¹Äæ¸Ìªº¸ê®Æ·|­«ÂÐ¥X²{¡A¥B¤£¯à¥Î¿z¿ïªº¤è¦¡¿z¿ï(¦]­nºû«ù­¶­±¥þ»ª)¡A§Ú·Q¦b(AAÄæ)²Î­pÄæ¸Ì·í·s¼W¥N¸¹®É¡A´N·|¦Û°Ê¥X²{¤@¦¸¥N¸¹¸ê®Æ´N¦n¤F¡A§Ë¤F¦n¤[¤£ª¾­n«ç»ò³]¤½¦¡¡A«D±`ÁÂÁ±z !
peter460191

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-12-23 19:33 ½s¿è

©w¸q¦WºÙ
x=OFFSET(Sheet1!$B$1,,,COUNTA(Sheet1!$B:$B),)
y=SUM(1/COUNTIF(x,x))
AA1°}¦C¤½¦¡
{=IF(ROW(A1)>y,"",INDIRECT("B"&SMALL(IF(COUNTIF(OFFSET($B$1,ROW(x),,COUNTA(x),),x)=0,ROW(x),""),ROW(A1))))}
¦V¤U½Æ»s
Ãö©ó¤£­«½Æ²M³æ°Q½×½Ð°Ñ¦Ò
http://forum.twbts.com/viewthread.php?tid=607&highlight=%A4%A3%AD%AB%BD%C6%B2M%B3%E6
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

·PÁ¶W¯Åª©¥D¡G
§Ú¤w¸Õ¦¨¥\¤F!
«D±`ÁÂÁ§A«üÂI¡C
peter460191

TOP

¦^´_ 5# peter460191

Ãö©ó±z´£¨ì¡A­ì¸ê®Æ¤£¥i§ó°Ê¡AµLªk¨Ï¥Î¿z¿ï
§Ú·Q±z¬O§Ñ°O¶i¶¥¿z¿ï¡A¥i±N¸ê®Æ½Æ»s¨ì¨ä¥L¦ì¸mªº¿ï¶µ
³o¼Ë¥i¥H¦bAAÄæ±o¨ìµ²ªG¡A¥BA:CÄæ¸ê®Æ¤£ÅÜ
±z¥i¹Á¸Õ¬Ý¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¶W¯Åª©¥D±z¦n!
«D±`¤£¦n·N«ä!¨S¦³¬Ý¨ì±zªº«áÄò«ü¾É¡A©Ò¥H¨Sµ¹±z¦^ÂÐ
¯uªº«D±`¤£¦n·N«ä!
Áö¤w±ß¤F¥b¦~¤§¤[
¦ýÁÙ¬O­n¸ò±z»¡ÁnÁÂÁÂ!«D±`·P¿E±z !
peter460191

TOP

«¢«¢¡A¼F®`¡I¥b¦~«á¦A¨£Åo¡I

TOP

¤@®É¥¢»~°Õ !©ç¶Õ°Õ!
peter460191

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD