- ©«¤l
- 2
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- profesional
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2011-9-3
- ³Ì«áµn¿ý
- 2011-9-5
|
[µo°Ý] ¦p¦ó¦bexcel¥Î¨â±iªí§@¶i¥X³f¥[p½Ð°ª¤â¤£§[¸Ñ¨MÁÂÁÂ!!
¦U¦ìEXCEL°ª¤â±z¦n!
¤p§Ìn¦bEXCEL¥Î2±iªí§@¶i¥X³f,®æ¦¡¦p¤U:
(Sheet1)
A B C D
½s¸¹ «~¦W ¶i³f¶q ¥X³f¶q
001 ²£«~A 5 2
002 ²£«~B 3
003 ²£«~C
n±N¤U±ªº¸ê®Æ,¨Ì·Ó½s¸¹¦Û°Êpºâ¶i¥X³f¶q¦ÜSheet1¤W,Y¥H001²£«~A¬°¨Ò,½Ð°ÝCÄæ¶i³f¶q¤ÎDÄæ¥X³f¶q¸Ó¦p¦ó³]©w?
(Sheet2)
A B C D E
¤é´Á ½s¸¹ «~¦W ¶i³f¶q ¥X³f¶q
1/2 001 ²£«~A 4
1/3 001 ²£«~A 2
1/4 002 ²£«~B 3
1/5 001 ²£«~A 1
·q½Ð½Ñ¦ì°ª¤â¤£§[¸Ñ¨M,ÁÂÁÂ!! |
|