- ©«¤l
- 10
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 17
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2013-4-21
- ³Ì«áµn¿ý
- 2013-4-24
|
§Ú°µ¤F¤@ÓÀɮצ³¤GÓ¤u§@ªí¡]DATA¤Î¦¬¤Jªí¡^
¦¬¤Jªíªº³¡¥÷¸ê®Æ³sµ²DATA
¨ä¹ê³oìÀɤ£¬O§Ú°µªº
§Ú¥u¬O·í®É(¤j·§10¦~«e)ı±o³oӫܦn¥Î´N®³¨Óקï
¦ý¬OìÀɧڤ]§Ë¥á¤F
קï«á¤@ª½Ä±±o«Ü¤£¶¶¡A¾ãÓÀÉ®×"¶]«ÜºC"
¨C¦¸¿é¤Jª÷ÃB´N¥X²{"«ºâÀx¦s®æ"
µM«án¤@ª½ºâ¨ì100%
¥§¡³£nµ¥¤WÓ¤Q´X¬íÄÁ¡A¦pªGn¿é¤J«Ü¦hª÷ÃB´Nn¤@ª½µ¥
§Ú¦³¸Õ¹L¤â°Ê¸Õºâ¡A¥þ³¡¥´¦A§¹¦A«öF9¡Aµ¥¥¦¶]§¹¤j·§nµ¥3¤ÀÄÁ@@
¦]¬°§Úק諸EXCELªíµLªk¤W¶Ç¨ì³oµ¸Ì¨Ó
©Ò¥H§Ú§â¤½¦¡¶K¨ì³o¤W±¨Ó
¦¬¤Jªí¸Ì©w¸q¸Ì°µ¤F¤GÓ¨ç¼Æ
=OFFSET(DATA!$B$1,MATCH(Á~¸ê¦¬¤J!D4,DATA!$A$2:$A$971,0),,COUNTIF(DATA!$A$2:$A$971,Á~¸ê¦¬¤J!D4))
=DATA!$C$2:$C$8
§Ú¤£ª¾¹D¬O¤£¬O¦³¿ìªk¥i¥HÅý¥¦³B²z³t«×¶¶ºZ¤@ÂI¡H |
|