- ©«¤l
- 30
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 33
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-6
- ³Ì«áµn¿ý
- 2015-2-4
|
¥»©«³Ì«á¥Ñ kaiweidevil ©ó 2012-4-8 23:49 ½s¿è
½Ð±Ð¤@¤U¦U¦ì«e½ú
§Ú¦³¤@ÓÀÉ®×°ÆÀɦW¬°.csv
§Ún¦b¸ÓÀɮפº¥[¤Jifªº¨ç¼Æ
¨Ò
§Ún¦bA1¿é¤J¬YȮɮÉA3·|¦Û°Ê¸ü¤J§Ú¦Ûqªº¸ê®Æ
§Ú¦bA3¬O¥Î =IF(ISBLANK(A1),"",VLOOKUP(A1,¬d¸ß¸ê®Æ®w,2,FALSE)) ³oÓ¤½¦¡
¦b¤@¶}©l³]©w®É³£¨S°ÝÃD¥i¬O·í§Ún¦sÀɮɷ|¥X²{
Yn«O«ù³oºØ®æ¦¡(¥ô¦ó¤£¬Û®eªº¥\¯à±N³Q±Æ°£), ½Ð«ö[¬O].
. Yn«O¦s¤u§@ªíªº©Ò¦³¥\¯à, ½Ð«ö[§_]. µM«á¦A±NÀÉ®×Àx¦s¬°³Ì·sªºExcel®æ¦¡.
. Ynª¾¹DÀx¦sªºÀɮשҥi¯à³y¦¨ªº¿ò¥¢, ½Ð«ö[»¡©ú].
1.·í§Ú«ö"¬O"®É§Ú©Ò³]©wªº¤½¦¡´N¥þ³¡¤£¨£¤F
2.§Ú»Ýnªº´N¬O.CSV©Ò¥H§Ú¤£¯à«ö§_
·Q½Ð±Ð¤@¤U§Ú¦pªGn¦b¸ÓºØ°ÆÀɦWªºEXCELÀɮפº¥[¤J¤Wzªº¤½¦¡®Én¦p¦ó¦b¦sÀɮɤ£·|³Q«c°£±¼ |
|