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

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 ¸ö»Ø´ð

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µÄ»ØÌû

zhaozheng522

¶Ò»»¹ó±ö

ÓÅÐ㣡£¡ÓÐľÓУ¡£¡£¡ÓÅÐ㣡£¡ÓÐľÓУ¡£¡£¡ÓÅÐ㣡£¡ÓÐľÓУ¡£¡£¡ÓÅÐ㣡£¡ÓÐľÓУ¡£¡£¡

¿ÉÄÜÎÒûÃèÊöÇå³þ£¬µÚÒ»¸÷ÎÊÌâÓëµÚ¶þ¸öÎÊÌâÊÇͬһ¸öÎÊÌâµÄ£¡
5Â¥2009-02-08 13:12:18
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 342Çóµ÷¼Á +7 Mary Keen 2026-03-28 7/350 2026-03-31 20:36 by 83503ËïÀÏʦ
[¿¼ÑÐ] »¯Ñ§308·Öµ÷¼Á +11 ÄãºÃÃ÷ÌìÄãºÃ 2026-03-30 12/600 2026-03-31 19:14 by Ñî½ð½ð½ð
[¿¼ÑÐ] 070300»¯Ñ§354Çóµ÷¼Á +15 101´ÎÏ£Íû 2026-03-28 15/750 2026-03-31 17:58 by jp9609
[¿¼ÑÐ] 080500-315·Ö¸´ÊÔµ÷¼Á +9 Éϰ¶3821 2026-03-31 9/450 2026-03-31 17:29 by ÌÆãå¶ù
[¿¼ÑÐ] ÉúÎïѧ296Çóµ÷¼Á +8 ÌÀÔ²°ü 2026-03-29 12/600 2026-03-31 17:05 by 18828373951
[¿¼ÑÐ] ±¾¿Æ211ÉúÎïҽѧ¹¤³Ì085409Çóµ÷¼Á339·Ö +7 Àï×Óľyy 2026-03-29 7/350 2026-03-31 14:35 by fmesaito
[¿¼ÑÐ] 282Çóµ÷¼Á +3 ºôÎü¶¼ÊǼõ·Ê 2026-03-31 3/150 2026-03-31 10:00 by wangjy2002
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸ ÄϾ©º½¿Õº½Ìì´óѧ £¬080500²ÄÁÏ¿ÆÑ§Ó빤³Ìѧ˶£¬×Ü·Ö289·Ö +9 @taotao 2026-03-29 9/450 2026-03-30 22:29 by ÎÒÊÇС¿µ
[¿¼ÑÐ] 293Çóµ÷¼Á +3 ĩδmm 2026-03-30 5/250 2026-03-30 17:23 by Íõ±£½Ü33
[¿¼ÑÐ] 324Çóµ÷¼Á +9 hanamiko 2026-03-26 11/550 2026-03-30 14:27 by JourneyLucky
[¿¼ÑÐ] 329Çóµ÷¼Á +8 ÐÇÒ°? 2026-03-26 8/400 2026-03-30 13:41 by chemdavid
[¿¼ÑÐ] 327Çóµ÷¼Á +6 ¼³Òàê» 2026-03-29 6/300 2026-03-29 13:40 by peike
[¿¼ÑÐ] Çóµ÷¼Á +6 «lty 2026-03-25 7/350 2026-03-28 13:13 by ÌÆãå¶ù
[¿¼ÑÐ] 283Çóµ÷¼Á +7 A child 2026-03-28 7/350 2026-03-28 12:05 by zllcz
[¿¼ÑÐ] 272Çóµ÷¼Á +7 ½Å»¬µÄÊØ·¨¹«Ãñ 2026-03-27 7/350 2026-03-27 17:23 by laoshidan
[¿¼ÑÐ] 266·ÖÇó²ÄÁÏ»¯¹¤Ò±½ð¿óÒµµÈרҵµÄµ÷¼Á +4 ÍÛºôºßºôºß 2026-03-26 4/200 2026-03-27 17:02 by zhyzzh
[¿¼ÑÐ] 0856µ÷¼Á +5 ÇóÇóÈÃÎÒÓÐÊé¶Á° 2026-03-26 6/300 2026-03-27 15:12 by caszguilin
[¿¼ÑÐ] 314Çóµ÷¼Á +3 ÏªÔÆçæ 2026-03-26 3/150 2026-03-27 11:20 by sanrepian
[¿¼ÑÐ] 303Çóµ÷¼Á +6 À¶É½Ô 2026-03-25 6/300 2026-03-25 22:47 by 418490947
[¿¼ÑÐ] 347Çóµ÷¼Á +4 L when 2026-03-25 4/200 2026-03-25 13:37 by cocolv
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û