- ©«¤l
- 7
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 16
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-5-27
- ³Ì«áµn¿ý
- 2012-6-2
|
[µo°Ý] ¦p¦ó¦b¯S©w¦ì¸m¦Û°Ê¥[¤@?
¥»©«³Ì«á¥Ñ yozcbm ©ó 2012-6-2 03:21 ½s¿è
¨Ò¦p§Ú¦³¤@°ïû¤u¸ê®Æ,°²³]§Ú·Q¦b"©m¦W"¥ªÃä¥[¤W¶¶§Ç½s¸¹
e.g.
©m¦Wxxxxxxxxxxxxx
xxxxxxxxxxxxxxx
©m¦Wxxxxxxxx
xxxxxxxx
xxxxxxxxxxxxx
xxxxxxxxxxxx
©m¦Wxxxxxxxxxxxx
xxxxxxxxxxx
xxxxxxxxx
¥[½s¸¹«áÅܦ¨:
1©m¦Wxxxxxxxxxxxxx
xxxxxxxxxxxxxxx
2©m¦Wxxxxxxxx
xxxxxxxx
xxxxxxxxxxxxx
xxxxxxxxxxxx
3©m¦Wxxxxxxxxxxxx
xxxxxxxxxxx
xxxxxxxxx
.
.
.
p.s.¨CÓ©m¦W¤¤¶¡¤§¦æ¼Æ¨Ã¤£¬Û¦P,,
§Úè¾ÇÃѤFif function,,
eg.=IF(B1="©m¦W",1,"")
¦pªG³o¼Ë¦A¦V¤U©Ôªº¸Ü¥u¯à¨CÓ©m¦W®ÇÃä¥X²{"1"
¦Ó§Ú°ÝÃD¬O¦p¦ó¦h¤@Ó"©m¦W"¥X²{´N¥[¤@?
thx so much~
¥t¥~¤@Ó°ÝÃD¬O,¦pªGexcel¤º¦³«Ü¦h¦æ¼Æªº¸ê®Æ,¦Ó§Úncopy (let say 5000ª½¦æ,n¥]¬A¾ã¾î¦æ,¤£¬OA1:A5000),,«ç¼Ë¤~¯à¤ñ¸û§Ö±¶ªº¦V¤Ucopy? (¥u¥Î¦V¤U©Ôªº¤èªk¨C¦¸copy³£«ÜºC><) |
|