±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1418  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 0703»¯Ñ§ +14 ÄÝÄÝninicgb 2026-04-04 15/750 2026-04-06 08:32 by zhangdingwa
[¿¼ÑÐ] 0703µ÷¼Á +12 ʰ¾ÁÒ¼ 2026-04-04 13/650 2026-04-06 06:26 by houyaoxu
[¿¼ÑÐ] ²ÄÁÏר˶(0856) 339·ÖÇóµ÷¼Á +10 ¹þ¹þ¹þ¶ì¹þ¹þ¹þ 2026-04-04 10/500 2026-04-05 18:51 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 0817»¯Ñ§¹¤³ÌÓë¼¼ÊõÇóµ÷¼Á£¬Ò»Ö¾Ô¸Öк£Ñó319 +13 lv945 2026-04-04 13/650 2026-04-05 18:14 by Öí»á·É
[¿¼ÑÐ] 313Çóµ÷¼Á +5 º£ÈÕº£ÈÕ 2026-04-04 5/250 2026-04-05 15:52 by jndximd
[¿¼ÑÐ] ²ÄÁϹ¤³Ì310ר˶µ÷¼Á +13 ÀÌÀÌÎÒ¡­. 2026-04-04 14/700 2026-04-05 09:01 by À´¿´Á÷ÐÇÓê10
[¿¼ÑÐ] 323Çóµ÷¼Á +8 Àî¼ÑÀÖ1 2026-04-04 8/400 2026-04-04 22:26 by hemengdong
[¿¼ÑÐ] 277¹¤¿ÆÇóµ÷¼Á +7 1915668 2026-04-04 7/350 2026-04-04 17:21 by °¡¿¡£¡
[¿¼ÑÐ] 289-Çóµ÷¼Á +4 ÕâÀïÊÇ_ 2026-04-03 4/200 2026-04-03 14:23 by 1753564080
[¿¼ÑÐ] Çóµ÷¼Á +9 akdhjs 2026-03-31 11/550 2026-04-03 13:32 by akdhjs
[¿¼ÑÐ] Ò»Ö¾Ô¸ÏÃÃÅ´óѧ²ÄÁϹ¤³Ìר˶354ÕÒµ÷¼Á£¡£¡£¡ +8 ±´ß±µ±µ 2026-03-30 8/400 2026-04-03 09:41 by hypershenger
[¿¼ÑÐ] Ò»Ö¾Ô¸9³õÊÔ366 ±¾Ë«·ÇÇóµ÷¼Á +4 ÔËÆøÀ´µÃÈôÓÐËÆÎ 2026-04-02 4/200 2026-04-02 09:56 by guanxin1001
[¿¼ÑÐ] ¡¾Çóµ÷¼Á¡¿ÐÂÄÜÔ´²ÄÁϱ¾¿Æ£¬Ò»Ö¾Ô¸211£¬³õÊÔ321 +6 Çóµ÷¼ÁѧУ£¬ 2026-04-02 6/300 2026-04-02 09:41 by Çç¿Õ210210
[¿¼ÑÐ] 304Çóµ÷¼Á +12 ËØÄê¼ÀÓï 2026-03-31 15/750 2026-04-01 22:41 by peike
[¿¼ÑÐ] 285Çóµ÷¼Á +11 AZMK 2026-04-01 11/550 2026-04-01 22:40 by peike
[¿¼ÑÐ] 296Çóµ÷¼Á +4 Íô£¡£¿£¡ 2026-03-31 7/350 2026-04-01 22:04 by ¿Í¶ûÃÀµÂ
[¿¼ÑÐ] 339Çóµ÷¼Á +5 zjjkt 2026-03-31 5/250 2026-04-01 09:18 by JourneyLucky
[¿¼ÑÐ] 085601 329·Öµ÷¼Á +6 yzsa12 2026-03-31 6/300 2026-03-31 15:23 by yanflower7133
[¿¼ÑÐ] Ò»Ö¾Ô¸Öк£Ñó320»¯Ñ§¹¤³ÌÓë¼¼Êõѧ˶Çóµ÷¼Á +8 ÅûÐÇºÓ 2026-03-30 8/400 2026-03-31 08:53 by lbsjt
[¿¼ÑÐ] 083000»·¾³¿ÆÑ§Ó빤³Ìµ÷¼Á£¬×Ü·Ö281 +4 ³È×Ó£¨Ê¤Ò⣩ 2026-03-30 4/200 2026-03-31 00:44 by Linzejun
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û