±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 415  |  »Ø¸´: 9
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£

zhaozheng522

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

[½»Á÷] EXCEL ÎÊÌâ

¼ÙÈ繤×÷±í1µÄBÁÐÖÐijÐÐÊý¾Ý£¨Èç:B21£©µÈÓÚÔÚ¹¤×÷±í2 µÄCÁÐÖеÄijÐÐÊý¾Ý£¨È磺C1346£©
ÄÇô¹¤×÷±í1µÄA21Ò²ÒªµÈÓÚ¹¤×÷±í2µÄB1346
¹¤×÷±í2 µÄCÁеÄÊý¾ÝÅÓ´ó»ìÂÒ£¬²»ÖªµÀ¹¤×÷±í1µÄBÁÐijÐеÄÊý¾ÝÔÚ¹¤×÷±íµÄCÁÐÖеÄÄÄÐУ¬Õ⹦ÄÜÔõôŪ£¿

» ²ÂÄãϲ»¶

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

quangel

ľ³æ (ÕýʽдÊÖ)

VBA±à³Ì²éÕÒ
×µÄ·½·¨£º
½«¹¤×÷±í1°´BÁÐÅÅÐò£¬½«¹¤×÷±í2°´CÅÅÐò£¬È»ºó¶Ô±È
2Â¥2009-02-06 13:42:17
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zhaozheng522

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

²»ÊÇÊý×Ö£¬ÊÇ·ûºÅ£¡£¡
3Â¥2009-02-06 14:35:03
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

lgm19851116

ľ³æ (ÕýʽдÊÖ)

Çå¾²µÄÅ®º¢

¡ï ¡ï
zhaozheng522(½ð±Ò+2,VIP+0):ллÄúµÄ»Ø´ð£¡¿ÉÄÜÎÒû˵Çå³þ 2-8 12:02
1¡¢¼ÙÈ繤×÷±í1µÄBÁÐÖÐijÐÐÊý¾Ý£¨Èç:B21£©µÈÓÚÔÚ¹¤×÷±í2 µÄCÁÐÖеÄijÐÐÊý¾Ý£¨È磺C1346£©
ÄÇô¹¤×÷±í1µÄA21Ò²ÒªµÈÓÚ¹¤×÷±í2µÄB1346
2¡¢¹¤×÷±í2 µÄCÁеÄÊý¾ÝÅÓ´ó»ìÂÒ£¬²»ÖªµÀ¹¤×÷±í1µÄBÁÐijÐеÄÊý¾ÝÔÚ¹¤×÷±íµÄCÁÐÖеÄÄÄÐУ¬Õ⹦ÄÜÔõôŪ£¿


»Ø1£ºÔÚ¹¤×÷±í1µÄA21ÖÐÊäÈ룺=if(B21=sheet!2C1346,sheet!2B1346,)
»Ø2£ºµ½¹¤×÷±í2µÄCÁÐËÑË÷һϣ¡
×ðÖØÉí±ßµÄÿһ¸öÈË£¬¾¡×Ô¼ºËùÄܰïÖú±ðÈË£¡Î¢Ð¦µÄÃæ¶ÔÒ»ÇУ¬ÒÔÆ½³£ÐĶԴýËùÓеÄÊÂÇ飡ӵÓÐÒ»¿Å¸Ð¶÷µÄÐÄ£¡
4Â¥2009-02-06 17:39:20
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zhaozheng522

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

¿ÉÄÜÎÒûÃèÊöÇå³þ£¬µÚÒ»¸÷ÎÊÌâÓëµÚ¶þ¸öÎÊÌâÊÇͬһ¸öÎÊÌâµÄ£¡
5Â¥2009-02-08 13:12:18
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

eb00k

Í­³æ (³õÈëÎÄ̳)

¡ï ¡ï
zhaozheng522(½ð±Ò+2,VIP+0):Äâ˵¶ÔÁË£¬ºóÃæÈ·Êµ¾ÍÓÃÕ⹦ÄÜʵÏֵģ¬Ð»Ð» 3-2 13:26
vlookup
6Â¥2009-02-13 10:13:23
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bloon

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

Áé»îÔËÓù«Ê½£¬ ¹ýÂË ¹¦ÄÜ
ºÃÏñÓиö¹«Ê½¿ÉÒÔ²éÕÒÁ½ÁÐÖ®¼ä¹²Í¬µÄÏîÄ¿
7Â¥2009-02-13 23:21:00
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

fzbxxw

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

Èç¹ûÊÇÓÃÀÏÊóÖ±½ÓÀ­µÄ£¬ÄÇô¶¼»áÒ»Ò»¶ÔÓ¦¡£×¢Òâ²é±íÒ»ÖеĹ«Ê½£¬Ò»¿´¾ÍÃ÷°×ÁË¡£
8Â¥2009-02-13 23:59:23
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wzd0604

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

ÎÒˮƽ̫µÍ£¬¿´²»¶®Â¥Ö÷˵µÄÄÚÈÝ¡£
µ±Äê·²¸ßµÄÏòÈÕ¿ûÁ¬Ò»¸öÍÁ¶¹¶¼»»²»À´£¬¿ÉÏÖÈç½ñ°ÑÈ«ÊÀ½çµÄÍÁ¶¹ÄÃÀ´Ò²¶¥²»ÉÏÈ˼ÒһƬ»¨°ê£¡
9Â¥2009-02-14 10:22:00
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

stephenking

ÔÚ¹¤×÷±í1µÄA21ÖÐÊäÈ룺=if(B21=sheet!2C1346,sheet!2B1346,)
µ½¹¤×÷±í2µÄCÁÐËÑË÷һϣ¡
10Â¥2009-02-14 10:56:25
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ zhaozheng522 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +8 Eujd1 2026-03-31 9/450 2026-03-31 17:25 by ÌÆãå¶ù
[¿¼ÑÐ] Çóµ÷¼Á +9 akdhjs 2026-03-31 10/500 2026-03-31 17:14 by zhyzzh
[¿¼ÑÐ] Ò»Ö¾Ô¸Î人Àí¹¤£¬×Ü·Ö321£¬Ó¢Ò»Êý¶þ£¬ÇóÀÏʦÊÕÁô¡£ +12 nnnnnnn5 2026-03-25 12/600 2026-03-31 16:21 by ¼Çʱ¾2026
[¿¼ÑÐ] 289Çóµ÷¼Á +6 BrightLL 2026-03-29 6/300 2026-03-31 11:22 by oooqiao
[¿¼ÑÐ] µ÷¼ÁÇóԺУÕÐÊÕ +7 º×¾¨¸ë 2026-03-28 7/350 2026-03-31 11:21 by oooqiao
[¿¼ÑÐ] 085600£¬×¨Òµ¿Î»¯¹¤Ô­Àí£¬320·ÖÇóµ÷¼Á +6 ´ó²öС×Ó 2026-03-29 6/300 2026-03-31 10:03 by ÂÈ»¯ÑÇÏõõ£
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤329·ÖÇóµ÷¼Á +5 ÕâÊÇÓÐÌ«ÑôÍÛ 2026-03-25 5/250 2026-03-31 09:59 by luoyongfeng
[¿¼ÑÐ] һ־ԸʳƷ¿ÆÑ§Ó빤³Ì083200Çóµ÷¼Á +4 XQTJZ 2026-03-30 4/200 2026-03-31 04:10 by fmesaito
[¿¼ÑÐ] 085701»·¾³¹¤³ÌÇóµ÷¼Á +11 ¶à¾ÃÉϿΠ2026-03-27 12/600 2026-03-30 21:21 by Ñо¿É®µ¼µ¼
[¿¼ÑÐ] 317Çóµ÷¼Á +8 Ê®ÏÐwx 2026-03-24 8/400 2026-03-30 21:00 by peike
[¿¼ÑÐ] 327Çóµ÷¼Á +5 С¿¨²»¿¨. 2026-03-29 5/250 2026-03-30 19:30 by Wang200018
[¿¼ÑÐ] 334·Ö Ò»Ö¾Ô¸ÎäÀí ²ÄÁÏÇóµ÷¼Á +16 ÀîÀî²»·þÊä 2026-03-26 16/800 2026-03-30 17:47 by wangjy2002
[¿¼ÑÐ] 0856Çóµ÷¼Á +8 —öèñ 2026-03-28 8/400 2026-03-30 10:00 by wzy-lxz
[¿¼ÑÐ] 071000ÉúÎïѧÇóµ÷¼Á£¬³õÊԳɼ¨343 +7 ССÌðÃæÍÅ 2026-03-25 7/350 2026-03-28 20:25 by ÌÆãå¶ù
[¿¼ÑÐ] 292Çóµ÷¼Á +14 ¶ì¶ì¶ì¶î¶î¶î¶î¶ 2026-03-25 15/750 2026-03-28 08:45 by WYUMater
[¿¼ÑÐ] 086502»¯Ñ§¹¤³Ì342Çóµ÷¼Á +6 °¢Ò̸´¹Å²»¹ý 2026-03-27 6/300 2026-03-28 07:06 by wangy0907
[¿¼ÑÐ] 265Çóµ÷¼Á +8 Сľ³æ085600 2026-03-27 8/400 2026-03-27 22:16 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄÏʦ´ó0703»¯Ñ§ 275Çóµ÷¼Á +4 RipcordÉϰ¶ 2026-03-27 4/200 2026-03-27 17:00 by zhyzzh
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á£¬Ò»Ö¾Ô¸ÄÏÅ©083200ʳƷ¿ÆÑ§Ó빤³Ì +5 XQTJZ 2026-03-26 5/250 2026-03-27 14:49 by ¿ñìÅÂóµ±µ±
[¿¼ÑÐ] »·¾³×¨Ë¶324·ÖÇóµ÷¼ÁÍÆ¼ö +5 ÐùСÄþ¡ª¡ª 2026-03-26 5/250 2026-03-26 12:05 by i_cooler
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û