±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1402  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 274Çóµ÷¼Á +15 ¹Ë¾ÅóÏҪǫÐé 2026-03-24 21/1050 2026-03-27 12:20 by 3Strings
[¿¼ÑÐ] 322Çóµ÷¼Á +3 ÎÒÕæµÄºÜÏëѧϰ 2026-03-23 3/150 2026-03-27 12:05 by ²»³Ôô~µÄ؈
[ÂÛÎÄͶ¸å] Journal of Mechanical Science and Technology +3 Russ_ss 2026-03-25 5/250 2026-03-27 10:49 by ½С¹û»­´ó±ý
[¿¼ÑÐ] 304Çóµ÷¼Á +3 ÂüÊâ2266 2026-03-27 3/150 2026-03-27 10:17 by guoweigw
[¿¼ÑÐ] 308Çóµ÷¼Á +6 īīĮ 2026-03-25 6/300 2026-03-27 09:34 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] 341Çóµ÷¼Á +7 ÇàÄûÃÊ1 2026-03-26 7/350 2026-03-27 00:19 by wxiongid
[¿¼ÑÐ] 294·Ö080500²ÄÁÏ¿ÆÑ§Ó빤³ÌÇóµ÷¼Á +4 ÁøÏª±ß 2026-03-26 4/200 2026-03-26 21:14 by XPUÀîÇì
[¿¼ÑÐ] 0703»¯Ñ§Çóµ÷¼Á +3 µ¤ÇàÄÌ¸Ç 2026-03-26 5/250 2026-03-26 20:11 by macy2011
[¿¼ÑÐ] ѧ˶274Çóµ÷¼Á +3 LiÀîÓã 2026-03-26 3/150 2026-03-26 18:32 by Ìá³ö·½·¨µÄÌá³öº
[¿¼ÑÐ] 279Çóµ÷¼Á +6 ºìÒÂÒþ¹Ù 2026-03-21 6/300 2026-03-26 18:32 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] 271Çóµ÷¼Á +6 ÉúÈçÏÄ»¨¡­ 2026-03-22 6/300 2026-03-26 16:48 by ÕÅ¿­Ê®°ËºÅ
[¿¼ÑÐ] 0856µ÷¼Á +4 ÇóÇóÈÃÎÒÓÐÊé¶Á° 2026-03-26 5/250 2026-03-26 15:54 by dick_runner
[¿¼ÑÐ] »¯Ñ§µ÷¼ÁÒ»Ö¾Ô¸ÉϺ£½»Í¨´óѧ336·Ö-±¾¿ÆÉϺ£211 +4 СÓã°®Óлú 2026-03-25 4/200 2026-03-26 10:19 by aa331100
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤328·Öµ÷¼Á +6 ¡££¬¡££¬¡££¬¡£i 2026-03-23 6/300 2026-03-25 22:30 by 418490947
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤304ÇóBÇøµ÷¼Á +3 Çñgl 2026-03-25 3/150 2026-03-25 19:03 by Ainin_
[¿¼ÑÐ] 086003ʳƷ¹¤³ÌÇóµ÷¼Á +6 íµíµ111 2026-03-24 6/300 2026-03-25 10:29 by 3Strings
[¿¼ÑÐ] ÉϺ£µçÁ¦´óѧ²ÄÁÏ·À»¤ÓëвÄÁÏÖØµãʵÑéÊÒÕÐÊÕµ÷¼ÁÑо¿Éú£¨²ÄÁÏ¡¢»¯Ñ§¡¢µç»¯Ñ§£¬»·¾³£© +4 ÎÒ°®Ñ§µç³Ø 2026-03-23 4/200 2026-03-25 00:59 by 1027_324
[¿¼ÑÐ] µ÷¼Á +4 13853210211 2026-03-24 4/200 2026-03-24 19:44 by ms629
[¿¼ÑÐ] 275Çóµ÷¼Á +6 shansx 2026-03-22 8/400 2026-03-22 15:27 by barlinike
[¿¼ÑÐ] 336Çóµ÷¼Á +5 rmc8866 2026-03-21 5/250 2026-03-21 17:24 by ѧԱ8dgXkO
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û