²é¿´: 413  |  »Ø¸´: 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µÄ»ØÌû

wzd0604

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

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

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µÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[ÂÛÎÄͶ¸å] ÉêÇë»Ø¸åÑÓÆÚÒ»¸öÔ£¬±à¼­Í¬ÒâÁË¡£µ«ÏµÍ³ÉϵÄʱ¼äû±ä£¬¸ø±à¼­ÓÖдÓʼþÁË£¬Ã»»Ø¸´ 10+3 wangf9518 2026-03-17 4/200 2026-03-19 23:55 by babero
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤µ÷¼Á 324·Ö +10 llllkkkhh 2026-03-18 12/600 2026-03-19 14:33 by llllkkkhh
[¿¼ÑÐ] 317Çóµ÷¼Á +3 Éê×ÓÉêÉê 2026-03-19 6/300 2026-03-19 14:16 by Éê×ÓÉêÉê
[¿¼ÑÐ] Ò»Ö¾Ô¸ Î÷±±´óѧ £¬070300»¯Ñ§Ñ§Ë¶£¬×Ü·Ö287£¬Ë«·ÇÒ»±¾£¬Çóµ÷¼Á¡£ +3 ³¿»èÏßÓëÐǺ£ 2026-03-19 3/150 2026-03-19 13:36 by houyaoxu
[¿¼ÑÐ] 281Çóµ÷¼Á£¨0805£© +9 ÑÌÏ«Ò亣 2026-03-16 19/950 2026-03-19 11:42 by laoshidan
[¿¼ÑÐ] Ò»Ö¾Ô¸Ìì´ó²ÄÁÏÓ뻯¹¤£¨085600£©×Ü·Ö338 +5 ²Ì´óÃÀÅ® 2026-03-13 5/250 2026-03-19 10:44 by ÊÇСÁõѽ¡«
[½Ìʦ֮¼Ò] ½¹ÂÇ +9 Ë®±ùÔÂÔÂÒ°Íà 2026-03-13 13/650 2026-03-19 09:50 by otani
[¿¼ÑÐ] 0703»¯Ñ§µ÷¼Á£¬Çó¸÷λÀÏʦÊÕÁô +10 ÇïÓÐľ±± 2026-03-14 10/500 2026-03-19 05:52 by anny19840123
[¿¼ÑÐ] ÉúÎïѧ071000 329·ÖÇóµ÷¼Á +3 ÎÒ°®ÉúÎïÉúÎﰮΠ2026-03-17 3/150 2026-03-18 10:12 by macy2011
[¿¼ÑÐ] 0703»¯Ñ§336·ÖÇóµ÷¼Á +6 zbzihdhd 2026-03-15 7/350 2026-03-18 09:53 by zhukairuo
[¿¼ÑÐ] 334Çóµ÷¼Á +3 Ö¾´æ¸ßÔ¶ÒâÔÚ»úÐ 2026-03-16 3/150 2026-03-18 08:34 by lm4875102
[¿¼ÑÐ] 302Çóµ÷¼Á +4 С¼Öͬѧ123 2026-03-15 8/400 2026-03-17 10:33 by С¼Öͬѧ123
[¿¼ÑÐ] »úеר˶325£¬Ñ°ÕÒµ÷¼ÁԺУ +3 y9999 2026-03-15 5/250 2026-03-16 19:58 by y9999
[»ù½ðÉêÇë] ½ñÄêµÄ¹ú»ù½ðÊÇ´ò·ÖÖÆÂ𣿠50+3 zhanghaozhu 2026-03-14 3/150 2026-03-16 17:07 by ±±¾©À³ÒðÈóÉ«
[¿¼ÑÐ] 304Çóµ÷¼Á +5 ËØÄê¼ÀÓï 2026-03-15 5/250 2026-03-16 17:00 by ÎҵĴ¬Îҵĺ£
[¿¼ÑÐ] 326Çóµ÷¼Á +3 mlpqaz03 2026-03-15 3/150 2026-03-16 07:33 by Iveryant
[¿¼ÑÐ] 0856ר˶279Çóµ÷¼Á +5 ¼ÓÓͼÓÓÍ£¡? 2026-03-15 5/250 2026-03-15 11:58 by 2020015
[¿¼ÑÐ] 080500£¬²ÄÁÏѧ˶302·ÖÇóµ÷¼ÁѧУ +4 ³õʶ¿ÉÀÖ 2026-03-14 5/250 2026-03-14 21:08 by peike
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤ 323 Ó¢Ò»+Êý¶þ+Îﻯ£¬Ò»Ö¾Ô¸£º¹þ¹¤´ó ±¾È˱¾¿ÆË«Ò»Á÷ +4 ×ÔÓɵÄ_·ÉÏè 2026-03-13 5/250 2026-03-14 19:39 by hmn_wj
[¿¼ÑÐ] Ò»Ö¾Ô¸¹þ¹¤´ó²ÄÁÏ324·ÖÇóµ÷¼Á +5 ãÆÐñ¶« 2026-03-14 5/250 2026-03-14 14:53 by ľ¹Ï¸à
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û