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

¥»©«³Ì«á¥Ñ kimbal ©ó 2010-7-25 02:07 ½s¿è
½Ð°Ý¦U¦ì¥ý¶i
­n±N­«½Æ²M³æ«È¤á¤¤±a¥X«È¤á¥X³f¦a§}
½Ð°Ý¢Õ¢±¡þ¢Ô¢±ªº¤½¦¡«ç»ò¼g¡H

¥t¥~°µ¦¨¼Ï¯Ã¤ÀªRªí ...
PD961A µoªí©ó 2010-7-24 19:04



    ¥ý¦^§A1ªº
twbts20100725uniqueText.zip (3.71 KB)

¦X­p¬O¥Î¨Óºâ¼Æ¦rªº,¤£¬O¥Î¨Ó§ä¤å¦r
¥u¥i¥H¦h¥[¤@­ÓÄæ(¤U¤èpivot table)
t20100725pivottabledata.zip (7.53 KB)
«j±jªº¸Ü,¹³¤W¤èªº¥[¤Wformula¤]¥i.¦ý¤£«Øij³o¼Ë°µ, ¼Ï¯ÃªíÅܦ¨´¶³qªí...
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

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

Excel 2007¦³¦¹¥\¯à
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 5# kimbal


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

TOP

¦L¶H¤¤´N¨S¦³¤F...
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

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

2# kimbal ª©¥D¤½¦¡¦A²¤Æ
{=INDEX(B:B,MIN(IF(COUNTIF(F$1:F1,B$2:B$50&""),4^8,ROW($2:$50))))&""}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

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

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD