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

[µo°Ý] ½Ð°Ý¥Î¼Ï¯Ãªí±N­«½Æ²M³æ«È¤á¤¤±a¥X¥X³f¦a§}ªº¤½¦¡¤Î­×¥¿

[µo°Ý] ½Ð°Ý¥Î¼Ï¯Ãªí±N­«½Æ²M³æ«È¤á¤¤±a¥X¥X³f¦a§}ªº¤½¦¡¤Î­×¥¿

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-1 17:43 ½s¿è

½Ð°Ý¦U¦ì¥ý¶i
­n±N­«½Æ²M³æ«È¤á¤¤±a¥X«È¤á¥X³f¦a§}
½Ð°Ý¢Õ¢±¡þ¢Ô¢±ªº¤½¦¡«ç»ò¼g¡H

¥t¥~°µ¦¨¼Ï¯Ã¤ÀªRªí­n¦p¦ó±N"¦X­p"ªº¦a¤è§ï¦¨"¥X³f¦a§}"
ÁÂÁ¦U¦ì¥ý¶i

¦^´_ 2# kimbal

ÁÂÁª©¥D
­ì¨ÓF2ªº¤½¦¡¦³RUN{INDEX(namels,SMALL(COUNTIF(MATCH($A$2:$A$21,namels,0)=ROW()-1,ROW()-1,""),ROW()-1))}
¦ý¬ORUN¥X¨Óªºµ²ªG¤£¹ï...©Ò¥HÁÂÁ±zµ¹ªº¤½¦¡

    ¥t¥~°µ¦¨¼Ï¯Ã¤ÀªRªºªí³æ¬O³Ì¤è«K..ª½±µ­«½Æªº¦a¤è³£¥i¥H¾ã¦X
§Úª¾¹D¦X­p¬O¥Î¨Óºâ¼Æ¦rªº,¤£¬O¥Î¨Ó§ä¤å¦r
©Ò¥H¨S¦³©ñ¦b¼Ï¯Ã¤ÀªR±M°Ïµo°Ý

­Y­n¦h¥[¤@­ÓÄæ(¤U¤èpivot table)
´N¹³±z»¡ªº
«j±jªº¸Ü,¹³¤W¤èªº¥[¤Wformula¤]¥i.¦ý¤£«Øij³o¼Ë°µ, ¼Ï¯ÃªíÅܦ¨´¶³qªí...´N¥¢¥h¥¦¦n¥Îªº¥\¯à
³o±i¼Ï¯Ã¤ÀªR­n¦A§V¤O·Q·Q...¬O§_¦³§ó¦nªº¤è¦¡¥h¸Ñ¨M...
ÁÂÁ±z

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-1 17:44 ½s¿è

¸Õ§¹¼Ï¯Ãªº³¡¤À±N«È¤á©M¥X³f¦a§}©ñ¦bª©­±³]¸m"¦P¦C"«á
¤ÀªRªí¥i±o¨ì¬Û¹ïÀ³ªº¥X³f¦a§}
¦ý¬O¸ê®Æ°Ï·|¬O¤@¤j¬qªÅ¥Õ
½Ð°Ý¬O§_¦³¥ý¶i¥i«ü¾É¸ê®ÆªÅ¥Õªº³¡¤À¸Ó¦p¦ó­×¥¿?
ÁÂÁÂ...

TOP

¦^´_ 5# kimbal


    ©Ò¥Hª©¥Dªº·N«ä
2003´N¨S¨ä¥Lªº¤è¦¡¸Ñ¨M¤F¶Ü?
ÁÂÁ±z....

TOP

¦^´_ 7# kimbal

ª©¥DÁÂÁ±z
¤£¹L¦]¬°³o±iªíªºÄæ¦ì¶·¨D¨S¦³³]­­
¦b¸Õ§¹¼Ï¯Ãªº³¡¤À±N«È¤á©M¥X³f¦a§}©ñ¦bª©­±³]¸m"¦P¦C"«á
¸ê®Æ°Ïª©­±³]¸m©Ô¤J¥X³f¤é´Á·í§@­pºâ­È
­ì¸ê®ÆªÅ¥Õªº³¡¤À´N¤£·|¬OªÅ¥Õ....
ÁÂÁ±zªº¦^¤å

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-1 17:45 ½s¿è
2# kimbal ª©¥D¤½¦¡¦A²¤Æ
{=INDEX(B:B,MIN(IF(COUNTIF(F$1:F1,B$2:B$50&""),4^8,ROW($250))))&""}
zz5151353 µoªí©ó 2010-7-31 20:26



    ÁÂÁÂZZª©¥D±zªº¤½¦¡
¥i¥H©µ¦ù°ÝÃD¶Ü?
¤µ¤Ñ­Y¥X³f«È¤á·h®a§ï¦a§}
¦ý¬O¤½¦¡§PÂ_¤´¥H²Ä1¦¸¥X²{ªº¦a§}¬°¥D...¥i¥H­×¥¿¤½¦¡©Î¬O¼W¥[Äæ¦ì¥h§P§O¶Ü?
ÁÂÁ±z..

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-1 18:02 ½s¿è

¦^´_ 11# zz5151353


    ÁÂÁÂZZª©¥D
¹ï¤£°_ ¯uªº«Ü©êºp°Ý¿ù¤F....
§Ú¬O­n°Ý¦a§}¬O¤§«á(¨C¦¸§ó·sªº)
ÁÂÁ±z....




¤£¹L¸Õ¥Î§ï¦¨MAXµª®×¤£·|¨º»ò²³æ§a...©Ò¥H¬O"ªÅ¥Õ"
A.gif

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD