- ©«¤l
- 1180
- ¥DÃD
- 204
- ºëµØ
- 0
- ¿n¤À
- 1051
- ÂI¦W
- 0
- §@·~¨t²Î
- Mac.OS10.6
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2012-9-19
     
|
¦^´_ 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¦Xp¬O¥Î¨Óºâ¼Æ¦rªº,¤£¬O¥Î¨Ó§ä¤å¦r
©Ò¥H¨S¦³©ñ¦b¼Ï¯Ã¤ÀªR±M°Ïµo°Ý
Yn¦h¥[¤@ÓÄæ(¤U¤èpivot table)
´N¹³±z»¡ªº
«j±jªº¸Ü,¹³¤W¤èªº¥[¤Wformula¤]¥i.¦ý¤£«Øij³o¼Ë°µ, ¼Ï¯ÃªíÅܦ¨´¶³qªí...´N¥¢¥h¥¦¦n¥Îªº¥\¯à
³o±i¼Ï¯Ã¤ÀªRn¦A§V¤O·Q·Q...¬O§_¦³§ó¦nªº¤è¦¡¥h¸Ñ¨M...
ÁÂÁ±z |
|