²é¿´: 4197  |  »Ø¸´: 14
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£

hehe2002

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

¡ï ¡ï ¡ï ¡ï ¡ï
ÀäÔÂ5565(½ð±Ò+5,VIP+0):·Ç³£¸Ðл£¡ 11-13 11:17
¡°°Ñ¶ººÅÇ°ÃæµÄ×Ö·û´®ÌáÈ¡³öÀ´¡±µÄ¾ßÌå²½Ö裺
1.Ñ¡ÔñAÁУ¬¸´ÖÆ£¬ÔÚ¼Çʱ¾ÀïÕ³Ìù£¬±£´æÎª1.txt
2.´ò¿ªExcel£¬Ñ¡Ôñ¡°Êý¾Ý¡±-¡°µ¼ÈëÍⲿÊý¾Ý¡±-¡°µ¼ÈëÊý¾Ý¡±£¬°ÑÎļþÀàÐ͸ijÉËùÓУ¬ÔÙÑ¡ÖÐÄǸö1.txt
3.Ñ¡ÖС°·Ö¸ô·ûºÅ¡±£¬¡°ÏÂÒ»²½¡±
4.°Ñ¡°¶ººÅ¡±ºÍ¡°¿Õ¸ñ¡±¹³ÉÏ£¬¡°ÏÂÒ»²½¡±
5.¡°Íê³É¡±£¬¡°È·¶¨¡±
6.´ËʱµÄAÁоÍÊÇÄãÔ­À´AÁÐÀﶺºÅÇ°ÃæµÄÊý¾Ý£¬ÄÃÈ¥½øÐбȽϰɣ¬×¢Òâǰºó˳Ðò£¬¿É±ð´íÁË¡«
11Â¥2009-11-13 10:57:33
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

hehe2002

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

¸ÕÍü˵ÁË£¬ÕâÀïµÄ¡°¶ººÅ¡±Ö¸µÄÊÇÎ÷ÎĵĶººÅ£¬ÒªÊÇÄãԭʼÊý¾ÝÀïÓÐÖÐÎĶººÅµÄ»°£¬¿ÖÅ»¹ÒªÔÚµÚ4²½Àï¡°ÆäËû¡±ÄÇÀï¼ÓÉÏ¡°£¬¡±¡£ÊÔÊÔ£¬¿´¿´ÐÐÁ˲»£¿
12Â¥2009-11-13 11:00:21
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÀäÔÂ5565

ľ³æ (Ö°Òµ×÷¼Ò)

лл£¡
ÄÇôVLOOKUPÓ¦¸ÃÓÃÔõÑùµÄ¹«Ê½ÄØ£¿
13Â¥2009-11-13 11:16:45
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

hehe2002

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

·½±ãµÄ»°£¬¸øÎÒһЩÊý¾ÝºÃ²»£¿ÎÒ×ö²âÊÔÓ㬼¸Ê®¸ö¾ÍÐÐ
14Â¥2009-11-13 11:42:37
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

hehe2002

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

¡ï ¡ï ¡ï
ÀäÔÂ5565(½ð±Ò+3,VIP+0):·Ç³£¸Ðл£¡ 11-13 13:31
×öºÃÁË£¬ÄãÊÔÊÔ£º
1.AÁдæ·ÅÄãÔ­À´BÁеĹؼü×Ö£¬BÁдæ·ÅÄãÔ­À´AÁеÄÈ«Ãû£¬CÁдæ·ÅÄãÓÃtxtµ¼³öµÄ¶ººÅǰµÄÊý¾Ý£¬DÁÐʹÓÃÒÔϹ«Ê½£º
D1ÀïÃæÊäÈ룺    =IF(C1="","",VLOOKUP(C1,$A$1:$B$9999,2,FALSE))
»Ø³µÒÔºóÓ¦¸ÃÄÜ¿´µ½¶ÔÓ¦µÄ½á¹û£¬Èç¹ûC1ÔÚAÁÐÀïÃæÓУ¬ÔòD1ÏÔʾB1µÄÄÚÈÝ£¬Èç¹ûûÓÐÔòÏÔʾ¡°#N/A¡±¡£(×¢£ºÄǸö$9999ÄãÒª¸ù¾ÝÄãµÄÐкŽøÐе÷Õû£¬ÌîÄãÊý¾Ý×î´óµÄÐкÅ)
2.Ñ¡ÖÐDÁУ¬Ctrl+D£¬¸ÃÁоͶ¼Ó¦ÓÃD1µÄ¹«Ê½ÁË£¬¶øÇÒÊǸ÷×Ô¶ÔÓ¦¸÷×ÔÐеÄ
3.Ctrl+AȫѡÕû¸ö¹¤×÷±í£¬¡°Êý¾Ý¡±-¡°ÅÅÐò¡±£¬Ñ¡Ôñ¡°ÁÐD¡±¡¢½µÐò£¬È·¶¨¡£´ËʱɾµôÇ°ÃæÓС°#N/A¡±µÄÐУ¬ºóÃæ¶¼ÊÇ·ûºÏÄãÌõ¼þµÄÄÚÈÝÁË¡£ÐèÒªµÄ»°£¬´ÓBÁи´ÖƳöÀ´¾ÍÐС£
4.Èç¹ûÄã¶Ô½á¹ûÊý¾ÝµÄ˳ÐòÓÐÒªÇ󣬱ÈÈçÒª±£³Ö³õʼµÄ˳Ðò£¬Ö»ÊÇÈ¥³ýûÓõÄÊý¾Ý£¬¿ÉÒÔ¼Ó¸öEÁУ¬ÔÚÓÐÊý¾ÝµÄÐÐÀïÃæË³ÐòÌî³ä1¡¢2¡¢3¡­¡­µÈ×ÔÈ»Êý£¬ÔÚµÚ3²½ÖèÍê³ÉºóÔÙ¶Ô¡°ÁÐE¡±½øÐÐÒ»ÏÂÅÅÐò¾ÍOKÁË£¡

Õâ¸ö²½Öè±È½Ï¶à£¬²»ÖªµÀÎÒ˵Ã÷°×ÁËÂð
15Â¥2009-11-13 13:23:25
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ ÀäÔÂ5565 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 328Çóµ÷¼Á£¬Ó¢ÓïÁù¼¶551£¬ÓпÆÑо­Àú +3 ÉúÎ﹤³Ìµ÷¼Á 2026-03-17 7/350 2026-03-18 20:41 by Wangjingyue
[¿¼ÑÐ] Ò»Ö¾Ô¸985£¬±¾¿Æ211£¬0817»¯Ñ§¹¤³ÌÓë¼¼Êõ319Çóµ÷¼Á +7 Liwangman 2026-03-15 7/350 2026-03-18 20:08 by walc
[¿¼ÑÐ] Ò»Ö¾Ô¸Öйúº£Ñó´óѧ£¬ÉúÎïѧ£¬301·Ö£¬Çóµ÷¼Á +4 1ËïÎò¿Õ 2026-03-17 4/200 2026-03-18 17:59 by fivewind
[¿¼ÑÐ] 354Çóµ÷¼Á +3 Tyoumou 2026-03-18 5/250 2026-03-18 16:41 by Tyoumou
[¿¼ÑÐ] 334Çóµ÷¼Á +3 Ö¾´æ¸ßÔ¶ÒâÔÚ»úÐ 2026-03-16 3/150 2026-03-18 08:34 by lm4875102
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤Çóµ÷¼Á +6 Ϊѧ666 2026-03-16 6/300 2026-03-17 20:15 by peike
[¿¼ÑÐ] 326Çóµ÷¼Á +5 Éϰ¶µÄСÆÏ 2026-03-15 6/300 2026-03-17 17:26 by ruiyingmiao
[¿¼ÑÐ] 290Çóµ÷¼Á +6 ¿×Ö¾ºÆ 2026-03-12 11/550 2026-03-17 14:41 by ÖÜÖÛÖÛ77
[¿¼ÑÐ] ¿¼Ñе÷¼Á +3 ä¿ya_~ 2026-03-17 5/250 2026-03-17 09:25 by Winj1e
[¿¼ÑÐ] 274Çóµ÷¼Á +5 ʱ¼äµã 2026-03-13 5/250 2026-03-17 07:34 by ÈÈÇéɳĮ
[¿¼ÑÐ] ҩѧ383 Çóµ÷¼Á +3 ҩѧchy 2026-03-15 4/200 2026-03-16 20:51 by Ôª×Ó^0^
[¿¼ÑÐ] 333Çóµ÷¼Á +3 ÎÄ˼¿Í 2026-03-16 7/350 2026-03-16 18:21 by ÎÄ˼¿Í
[»ù½ðÉêÇë] ÏÖÔÚÈçºÎ»Ø±ÜÈ¥ÄêµÄijһ¸öר¼Ò£¬²»ÖªµÀÃû×Ö +3 zk200107 2026-03-12 6/300 2026-03-14 17:13 by zk200107
[¿¼ÑÐ] ²ÄÁÏ080500µ÷¼ÁÇóÊÕÁô +3 Ò»¿Åmeteor 2026-03-13 3/150 2026-03-14 10:54 by peike
[¿¼ÑÐ] 330Çóµ÷¼Á +3 ?½´¸øµ÷¼Á¹òÁË 2026-03-13 3/150 2026-03-14 10:13 by JourneyLucky
[¿¼ÑÐ] ²ÄÁϹ¤³Ìµ÷¼Á +9 ßäßä¿Õ¿Õ 2026-03-12 9/450 2026-03-13 22:05 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] 311Çóµ÷¼Á +3 ¶¬Ê®Èý 2026-03-13 3/150 2026-03-13 20:41 by JourneyLucky
[˶²©¼ÒÔ°] 085600 260·ÖÇóµ÷¼Á +3 Ìì¿Õ»¹ÏÂÓêô 2026-03-13 5/250 2026-03-13 18:46 by Ìì¿Õ»¹ÏÂÓêô
[¿¼ÑÐ] ²ÄÁÏר˶350 Çóµ÷¼Á +4 Íõ½ð¿Æ 2026-03-12 4/200 2026-03-13 16:02 by ruiyingmiao
[¿¼ÑÐ] 081200-11408-276ѧ˶Çóµ÷¼Á +3 ´Þwj 2026-03-12 4/200 2026-03-12 19:33 by Çóµ÷¼Ázz
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û