±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 422  |  »Ø¸´: 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µÄ»ØÌû

bloon

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

Áé»îÔËÓù«Ê½£¬ ¹ýÂË ¹¦ÄÜ
ºÃÏñÓиö¹«Ê½¿ÉÒÔ²éÕÒÁ½ÁÐÖ®¼ä¹²Í¬µÄÏîÄ¿
7Â¥2009-02-13 23:21: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µÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 359Çóµ÷¼Á +7 µËµËµËÊéÊé 2026-03-25 7/350 2026-03-31 23:15 by fs26jie
[¿¼ÑÐ] µ÷¼ÁÍÆ¼ö +7 Ç徯714 2026-03-26 8/400 2026-03-31 22:12 by 544594351
[¿¼ÑÐ] 311Çóµ÷¼Á +7 ÀîÜÆÐÂ1 2026-03-31 7/350 2026-03-31 18:10 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 070300Ò»Ö¾Ô¸211£¬312·ÖÇóµ÷¼ÁԺУ +12 С»ÆÑ¼±¦ 2026-03-30 12/600 2026-03-31 17:53 by 544594351
[¿¼ÑÐ] 266·Ö£¬Çó²ÄÁÏÏà¹Ø×¨Òµµ÷¼Á +10 ÍÛºôºßºôºß 2026-03-30 12/600 2026-03-31 11:00 by ÐÜÒ»µ¶
[¿¼ÑÐ] һ־ԸʳƷ¿ÆÑ§Ó빤³Ì083200Çóµ÷¼Á +4 XQTJZ 2026-03-30 4/200 2026-03-31 04:10 by fmesaito
[¿¼ÑÐ] 281Çóµ÷¼Á +5 ÑÇ¿ËÎ÷good 2026-03-26 7/350 2026-03-30 20:42 by dophin1985
[¿¼ÑÐ] 334·Ö Ò»Ö¾Ô¸ÎäÀí ²ÄÁÏÇóµ÷¼Á +16 ÀîÀî²»·þÊä 2026-03-26 16/800 2026-03-30 17:47 by wangjy2002
[¿¼ÑÐ] 332Çóµ÷¼Á +6 @MZB382400 2026-03-28 6/300 2026-03-30 16:57 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 070305¸ß·Ö×Ó»¯Ñ§ÓëÎïÀí 304·ÖÇóµ÷¼Á +12 c297914 2026-03-28 12/600 2026-03-29 16:21 by Serene1974
[¿¼ÑÐ] 081200-11408-276ѧ˶Çóµ÷¼Á +6 ´Þwj 2026-03-26 6/300 2026-03-29 01:11 by hanserlol
[¿¼ÑÐ] ÊýÒ»Ó¢Ò»271ר˶£¨085401£©Çóµ÷¼Á£¬¿É¿ç +7 ǰÐбØÓйâ 2026-03-28 8/400 2026-03-28 23:22 by Сľ³ætim
[¿¼ÑÐ] 11408Èí¼þ¹¤³ÌÇóµ÷¼Á +3 Qiuѧing 2026-03-28 3/150 2026-03-28 21:50 by zhq0425
[¿¼ÑÐ] Ò»Ö¾Ô¸ÏÃÃÅ´óѧ»¯Ñ§Ñ§Ë¶307Çóµ÷¼Á +10 y7czhao 2026-03-26 10/500 2026-03-28 14:23 by ÌÆãå¶ù
[¿¼ÑÐ] 292Çóµ÷¼Á +14 ¶ì¶ì¶ì¶î¶î¶î¶î¶ 2026-03-25 15/750 2026-03-28 08:45 by WYUMater
[¿¼ÑÐ] 340Çóµ÷¼Á +5 jhx777 2026-03-27 5/250 2026-03-28 04:18 by fmesaito
[¿¼ÑÐ] µ÷¼Á +3 Àî¼Îͼ¡¤S¡¤Â· 2026-03-27 3/150 2026-03-27 11:19 by wangjy2002
[¿¼ÑÐ] Ò»Ö¾Ô¸¼ª´ó071010£¬316·ÖÇóµ÷¼Á +3 xgbiknn 2026-03-27 3/150 2026-03-27 10:36 by guoweigw
[¿¼ÑÐ] »¯Ñ§µ÷¼ÁÒ»Ö¾Ô¸ÉϺ£½»Í¨´óѧ336·Ö-±¾¿ÆÉϺ£211 +4 СÓã°®Óлú 2026-03-25 4/200 2026-03-26 10:19 by aa331100
[¿¼ÑÐ] Çóµ÷¼Á +3 ÀîÀî²»·þÊä 2026-03-25 3/150 2026-03-25 13:03 by cmz0325
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û