±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1403  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 070300Çóµ÷¼Á306·Ö +3 26ÒªÉϰ¶ 2026-03-27 3/150 2026-03-27 17:57 by arrow8852
[¿¼ÑÐ] ѧ˶274Çóµ÷¼Á +4 LiÀîÓã 2026-03-26 4/200 2026-03-27 17:41 by ºìÓñ¼ÑÈË
[¿¼ÑÐ] 305Çóµ÷¼Á +5 ÍÛ¬¿¨¿â 2026-03-26 5/250 2026-03-27 14:01 by laoshidan
[¿¼ÑÐ] 0703»¯Ñ§Çóµ÷¼Á£¬¸÷λÀÏʦ¿´¿´ÎÒ£¡£¡£¡ +4 Æîì÷ì÷ 2026-03-25 4/200 2026-03-27 13:55 by stillstella
[¿¼ÑÐ] 322Çóµ÷¼Á +4 ÎÒÕæµÄºÜÏëѧϰ 2026-03-23 4/200 2026-03-27 13:51 by ÑîÑîÑî×Ï
[¿¼ÑÐ] 316Çóµ÷¼Á +5 Pigcasso 2026-03-24 5/250 2026-03-27 12:10 by zhshch
[¿¼ÑÐ] 303Çóµ÷¼Á +7 °²ÒäÁé 2026-03-22 8/400 2026-03-27 11:46 by sanrepian
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤¿¼Ñе÷¼Á +16 ‹üÈA 2026-03-22 16/800 2026-03-27 11:23 by ÍõЦÓîÒ»¶¨ÊÇÑо
[¿¼ÑÐ] µ÷¼ÁÇóÊÕÁô +7 ¹ûÈ»ÓÐÎÒ 2026-03-26 7/350 2026-03-27 00:26 by wxiongid
[¿¼ÑÐ] Ò»Ö¾Ô¸±±»¯Çóµ÷¼Á +3 Jsman 2026-03-22 3/150 2026-03-26 21:06 by ajpv·çÀ×
[¿¼ÑÐ] ѰÕÒµ÷¼Á +5 ¾óǿâ? 2026-03-21 8/400 2026-03-26 13:25 by 0906ljy
[¿¼ÑÐ] 299Çóµ÷¼Á +7 ijijijijλ 2026-03-21 8/400 2026-03-25 20:34 by ÈÈÇéɳĮ
[¿¼ÑÐ] ¿¼ÑÐÒ»Ö¾Ô¸ËÕÖÝ´óѧ³õʼ315£¨Ó¢Ò»£©Çóµ÷¼Á +3 sbdksD 2026-03-24 4/200 2026-03-25 18:16 by xcjcqu
[¿¼ÑÐ] 284Çóµ÷¼Á +15 Zhao anqi 2026-03-22 15/750 2026-03-25 12:51 by wht0531
[¿¼ÑÐ] 285Çóµ÷¼Á +3 AZMK 2026-03-24 3/150 2026-03-25 12:23 by userper
[¿¼ÑÐ] ²ÄÁÏר˶ÕÒµ÷¼Á +5 ¹þ¹þ¹þºðºðºð¹þ 2026-03-23 5/250 2026-03-24 19:07 by ÁËÁËÁËÁË¡£¡£
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄϺ½²ÄÁÏר317·ÖÇóµ÷¼Á +5 ըѽըѽըÊíÌõ 2026-03-23 5/250 2026-03-24 16:52 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] »·¾³Ñ§Ë¶288Çóµ÷¼Á +8 ƤƤƤ123456 2026-03-22 8/400 2026-03-23 23:47 by ÈÈÇéɳĮ
[¿¼ÑÐ] 306Çóµ÷¼Á +5 À´ºÃÔËÀ´À´À´ 2026-03-22 5/250 2026-03-22 16:17 by BruceLiu320
[¿¼ÑÐ] ²ÄÁÏѧ˶301·ÖÇóµ÷¼Á +7 Liyouyumairs 2026-03-21 7/350 2026-03-21 22:31 by peike
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û