ããå·¥å ·/åæ
ããExcel 2003
ããæ¹æ³/æ¥éª¤
ãã1.å¦ä¸æ¯ä¸ä¸ªExcelå·¥ä½èä¸çä¸¤å¼ è¡¨ï¼åå«ä¸ºSheet1åSheet2ï¼ä¸é¢åå«ä»¥è¡¨1å表2æ¥ä»£æ¿ãç°å¨è¦æ表2ä¸çè¯ææç»©å¯¼å ¥å°è¡¨1ä¸ï¼ä½æ¯ä»å¾ä¸å¯ä»¥çåºè¡¨1å表2åå并ä¸ä¸ä¸å¯¹åºï¼
ãã2.éä¸è¡¨1ï¼éä¸C2åå æ ¼ï¼å³è¯æ项ç®ä¸ç¬¬ä¸ä¸ªè¦å½å ¥çæ绩ãéæ©âæå ¥âå½æ°âå½ä»¤ï¼
ãã3.å¨âæéæ©ç±»å«âä¸éæ©âæ¥æ¾ä¸å¼ç¨âï¼
ãã4.å¨å¯¹åºçâéæ©å½æ°âä¸éæ©âVLOOKUPâï¼ç¹å»ç¡®å®ï¼
ãã5.å¨åºç°çâå½æ°åæ°âé¢æ¿ç¹å»ç¬¬ä¸ä¸ªé项ç®å¤´å¤çæé®ï¼
ãã6.ç¹å»âå¼ ä¸âååï¼å³âA2âåå æ ¼ï¼è¡¨ç¤ºè¦æ¥æ¾âå¼ ä¸âçæ绩ï¼ç¹å»ä¸é¢çæé®åå°é¢æ¿ä¸ï¼
ãã7.ç¹å»ç¬¬äºä¸ªé项ç®å¤´å¤çæé®ï¼
ãã8.éä¸è¡¨2ï¼åæ¶éæ©AååBåï¼ç¶åç¹å»ä¸é¢çæé®ï¼
ãã9.å 为å¨è¡¨2ä¸è¯ææ绩å¨ç¬¬äºåï¼æ以第ä¸é¡¹å¡«å ¥æ°åâ2âï¼
ãã10.第å项ç´æ¥å¡«å ¥â0âå³å¯ï¼ç¹å»ç¡®å®ï¼
ãã11.çå°è¡¨1ä¸å¼ ä¸çè¯ææ绩åºç°äºæ°å¼ï¼è¯¥æ°å¼ä¸è¡¨2ç¸åï¼
ãã12.éä¸C2åå æ ¼ï¼ç¨å¡«å æä¸æï¼ææçè¯ææ绩就ä»è¡¨2å¡«å ¥è¡¨1ä¸å»äºã