±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1419  |  »Ø¸´: 11

yongkaijia

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

[½»Á÷] ¡¾ÇóÖú¡¿¹ØÓÚEXCELµÄÒ»¸öÎÊÌâ ÒÑÓÐ10È˲ÎÓë

¹«Ê½ÊÇ £ºÈç¹ûaÁÐÊý×ÖµÈÓÚbÁÐÊý×ÖÖÐµÄ Ò»¸ö ÔòcÁÐֵΪdÁÐÖµ¡£¡£¾Ù¸öÀý×Ó£º Èç¹ûA1µÈÓÚB1:B30ÖеÄÒ»¸ö£¬ÄÇôc1=d1¡£¡£Çë¸ßÊÖ½â´ð¡£¡£Ð»Ð»À²

[ Last edited by nono2009 on 2010-7-16 at 07:56 ]
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

resonant

ľ³æ (ÕýʽдÊÖ)

¶À×ÔΪÕþ

¡ï ¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
ÓàÔó³É(½ð±Ò+1):ÐÁ¿àÁË£¡ 2010-07-15 10:54:15
Õâ¸ö²»ÊÇ»ã±àÏÂÃæµÄÎÊÌâ°É£¿Èç¹ûÊÇÒ»°ãµÄexcelÎÊÌ⣬½¨Òéµ½¹¤¾ßÇóÖú°æ¿éÎÊ¡£
Èç¹ûÄãÐèÒªÓõ½VBAÔò²»·Á·ÅÔÚ±¾°æµÄVB×Ó°æ¿éÏÂÃæÑ¯ÎÊ¡£
½»ÅóʶÓÑ£¬ÃÍ¸ã¿ÆÑС£Á½ÊÖ×¥£¬Á½ÊÖ¶¼ÒªÓ²¡£
2Â¥2010-07-14 23:39:04
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

alexissp

½ð³æ (ÕýʽдÊÖ)

¸É»îµÄ

¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
Õâ¸ö²»ÖªµÀ¿É²»¿ÉÒÔÓÃexcel½â¾ö£¬ÓÃcµÈ¿Ï¶¨¿ÉÒԸ㶨
¼òµ¥³äʵ
3Â¥2010-07-15 08:43:08
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zflfred

Òø³æ (СÓÐÃûÆø)

¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
Õâ¸öÕæ²»»á£¬ÎÒ»³ÒÉÔÚexcelÏÂÄÜ·ñʵÏÖ
»¯¹¤³æ³æ
4Â¥2010-07-15 09:02:46
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

7888

ľ³æ (ÕýʽдÊÖ)

·Ï¶¼ÉðÊ¿

¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
¿Ï¶¨¿ÉÒÔ£¬
µ«ÊÇÎÒ²»ÖªµÀ¡£
¶«ÄÏСľ³æ
5Â¥2010-07-15 09:10:49
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

lhzhang2004

½ð³æ (СÓÐÃûÆø)

yongkaijia(½ð±Ò+1):лл²ÎÓë
ÓàÔó³É(½ð±Ò-1):ÕâÌûûʲôºÃѧϰµÄ£¬¹àË®ËùµÃ¿Û³ý£¬Ï²»ÎªÀý£¡ 2010-07-15 10:55:50
ѧϰһÏÂ
6Â¥2010-07-15 09:20:28
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

dedream

Ìú¸Ëľ³æ (ÕýʽдÊÖ)

¡ï ¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
ÓàÔó³É(½ð±Ò+1):лл²ÎÓëÓ¦Öú£¡ 2010-07-15 10:56:31
ÓÃMATCHºÍINDIRECTÁ½¸öº¯Êý
´ÓÊý¾Ýµ½½áÂÛ
7Â¥2010-07-15 10:30:29
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

yalefield

½ð³æ (ÎÄ̳¾«Ó¢)

ÀϺºÒ»Ã¶

¡ï ¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
ÓàÔó³É(½ð±Ò+1):лл²ÎÓëÓ¦Öú£¡ 2010-07-15 21:59:56
Index, Match
Offset, Match
8Â¥2010-07-15 16:31:51
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

592960253

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

¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
Õâ¸öEXCEL²»Äܽâ¾ö°É
9Â¥2010-07-15 16:41:23
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magic7004

½ð³æ (Ö°Òµ×÷¼Ò)

¡ï ¡ï
yongkaijia(½ð±Ò+1):лл²ÎÓë
ÓàÔó³É(½ð±Ò+1):ÐÁ¿à£¡ 2010-07-15 21:59:47
ÒýÓûØÌû:
Originally posted by yongkaijia at 2010-07-14 16:48:36:
¹«Ê½ÊÇ £ºÈç¹ûaÁÐÊý×ÖµÈÓÚbÁÐÊý×ÖÖÐµÄ Ò»¸ö ÔòcÁÐֵΪdÁÐÖµ¡£¡£¾Ù¸öÀý×Ó£º Èç¹ûA1µÈÓÚB1:B30ÖеÄÒ»¸ö£¬ÄÇôc1=d1¡£¡£Çë¸ßÊÖ½â´ð¡£¡£Ð»Ð»À²

ÔÚC1ÖÐÊäÈë
CODE:
   =IF(ISERROR(VLOOKUP(A1,B$1:B$30,1,FALSE)),0,D1)

¾ÍOKÁË¡£

[ Last edited by magic7004 on 2010-7-16 at 09:39 ]
Á÷Ã¥²»¿ÉÅ£¬¿ÉŵÄÊÇÁ÷Ã¥ÓÐÎÄ»¯£¬ÓÐÎÄ»¯ÓÖBHµÄÁ÷Ã¥ÎÞµÐ~~£¡
10Â¥2010-07-15 17:00:48
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ yongkaijia µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 286Çóµ÷¼Á +12 Faune 2026-04-06 12/600 2026-04-06 17:40 by dongzh2009
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸ÏÃÃÅ´óѧ£¬ÉúÎïÓëÒ½Ò©£¬×Ü·Ö272£¬±¾¿Æ211 +4 Electron1cc 2026-04-01 5/250 2026-04-06 10:45 by barlinike
[¿¼ÑÐ] 086000ÉúÎïÓëÒ½Ò©Çóµ÷¼Á +3 ÀÏÌì¾ì¹ËÖ®ÈË 2026-03-31 3/150 2026-04-05 22:24 by syh9288
[¿¼ÑÐ] ¹¤¿Æ08-»úеר˶-Çóµ÷¼Á +3 À×Å··ÉÌß 2026-04-02 3/150 2026-04-05 18:49 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 0860 Çóµ÷¼Á Ò»Ö¾Ô¸¹ú¿Æ´ó 348 ·Ö +3 WiiiP 2026-04-03 3/150 2026-04-05 17:43 by Ecowxq666£¡
[¿¼ÑÐ] ¹¤¿Æ277·ÖÇóµ÷¼Á²ÄÁÏ +8 ÉÏÁËÉÏÁËÉÏŶ 2026-04-05 9/450 2026-04-05 13:05 by wwytracy
[¿¼ÑÐ] 342Çóµ÷¼Á +3 Liang7111 2026-04-04 5/250 2026-04-04 19:47 by dongzh2009
[¿¼ÑÐ] Çóµ÷¼Á +6 Ë·Ë·»° 2026-04-02 7/350 2026-04-04 19:16 by À¶ÔÆË¼Óê
[¿¼ÑÐ] ¿¼Ñе÷¼Á +4 zybz³å³å³å 2026-04-03 6/300 2026-04-04 13:08 by zybz³å³å³å
[¿¼ÑÐ] 265Çóµ÷¼Á +20 ÁºÁºÐ£Ð£ 2026-04-01 21/1050 2026-04-04 00:38 by userper
[¿¼ÑÐ] 283Çóµ÷¼Á +3 jiouuu 2026-04-03 4/200 2026-04-03 13:28 by jiouuu
[¿¼ÑÐ] 326Çóµ÷¼Á +10 áÌáÌ×Ð 2026-04-02 10/500 2026-04-03 09:08 by ÅÁ¶ûÂíÀ­ÌØ
[¿¼ÑÐ] 366Çóµ÷¼ÁÒ»Ö¾Ô¸¶«±±´óѧ +8 ÔËÆøÀ´µÃÈôÓÐËÆÎ 2026-04-02 8/400 2026-04-02 21:39 by dongzh2009
[¿¼ÑÐ] 285Çóµ÷¼Á +8 AZMK 2026-04-02 11/550 2026-04-02 20:16 by yulian1987
[¿¼ÑÐ] Çóµ÷¼Á +7 Aniyaio 2026-04-02 7/350 2026-04-02 16:42 by zzsw+
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©¿Æ¼¼´óѧ085601²ÄÁϹ¤³ÌÓ¢Ò»Êý¶þ³õÊÔ×Ü·Ö335Çóµ÷¼Á +8 Ë«ÂíβƦÀϰå2 2026-04-02 9/450 2026-04-02 14:45 by 5896
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©¿Æ¼¼£¬085601×Ü·Ö305Çóµ÷¼Á +9 °ëÉú¹Ï£¡ 2026-04-01 11/550 2026-04-02 08:28 by Wang200018
[¿¼ÑÐ] 311Çóµ÷¼Á +10 ÀîÜÆÐÂ1 2026-03-31 10/500 2026-04-01 14:38 by chenqifeng666
[¿¼ÑÐ] 0710ÉúÎïѧÇóµ÷¼Á£¡ +6 ÐðÊöÎÄ 2026-03-31 6/300 2026-04-01 09:39 by JourneyLucky
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸±±ÁÖʳƷÓëÓªÑø095500£¬301·Ö£¬ÒѹýÁù¼¶£¬ÓпÆÑо­Àú +4 ¿ìÀÖ´¢Ðî¹Þ 2026-03-31 4/200 2026-04-01 09:26 by JourneyLucky
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û