Znn3bq.jpeg
²é¿´: 426  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 0859£¬337Çóµ÷¼Á +4 ÑÐs. 2026-04-10 4/200 2026-04-11 11:34 by caotw2020
[¿¼ÑÐ] Çóµ÷¼Á +6 archer.. 2026-04-09 8/400 2026-04-11 10:55 by zhq0425
[¿¼ÑÐ] 086000µ÷¼Á +5 Ê®Æßsa 2026-04-07 5/250 2026-04-11 10:38 by ×ÏêØ×ÏÆå
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷±±¹¤Òµ´óѧ289 085602 +31 yangæÃ 2026-04-10 32/1600 2026-04-11 10:13 by onlyÖÜ
[¿¼ÑÐ] Ò»Ö¾Ô¸985»úеѧ˶380Çóµ÷¼Á +5 ¹Ø¹ØöÂð¯10 2026-04-11 5/250 2026-04-11 10:10 by ÖªÄî¡£A
[¿¼ÑÐ] 281Çóµ÷¼Á +11 ¾õµÃºÃµÄ°É 2026-04-10 11/550 2026-04-11 09:35 by ÄæË®³Ë·ç
[¿¼ÑÐ] Ò»Ö¾Ô¸211£¬»¯Ñ§Ñ§Ë¶£¬310·Ö£¬±¾¿ÆÖصãË«·Ç£¬Çóµ÷¼Á +17 ŬÁ¦·Ü¶·112 2026-04-06 20/1000 2026-04-11 00:31 by wangjihu
[¿¼ÑÐ] 326Çóµ÷¼Á +5 Shansyn 2026-04-10 5/250 2026-04-10 22:23 by Öí»á·É
[¿¼ÑÐ] ҩѧר˶µ÷¼Á +6 ? һ·Éú?»¨? 2026-04-10 7/350 2026-04-10 21:08 by zhouxiaoyu
[¿¼ÑÐ] ÉúÎïѧ308·ÖÇóµ÷¼Á£¨Ò»Ö¾Ô¸»ª¶«Ê¦´ó£©×ö¹ý·Ö×ÓʵÑé +8 ÏàÐűػá¹ââÍòÕ 2026-04-07 9/450 2026-04-10 21:03 by zhouxiaoyu
[¿¼ÑÐ] 314Çóµ÷¼Á +18 xhhdjdjsjks 2026-04-09 19/950 2026-04-10 18:53 by HPUCZ
[»ù½ðÉêÇë] Óб¬ÁÏ£¬Ò»¸öÇàÄê½ÌʦÂô·¿µÃ400Íò£¬È»ºó»»ÁËÒ»¸öËÄÇàñ×Ó +9 babu2015 2026-04-08 9/450 2026-04-10 11:43 by ËÕ¶«ÆÂ¶þÊÀ
[¿¼ÑÐ] 070300»¯Ñ§Ñ§Ë¶311·ÖÇóµ÷¼Á +18 Áº¸»¹óÏÕÖÐÇó 2026-04-04 20/1000 2026-04-09 11:18 by ßÕßÕßÕßÉßÉßÉ
[¿¼ÑÐ] ¿¼ÑÐÇóµ÷¼Á +4 ö©??? 2026-04-08 4/200 2026-04-08 21:44 by ÍÁľ˶ʿÕÐÉú
[¿¼ÑÐ] 293·ÖÇóµ÷¼Á£¬ÍâÓïΪ¶íÓï +7 ¼ÓÒ»Ò»¾Å 2026-04-07 10/500 2026-04-08 20:14 by yutian743
[¿¼ÑÐ] 281Çóµ÷¼Á +10 Ò¬×ÓÄ¢¹½ 2026-04-06 10/500 2026-04-08 11:43 by zzucheup
[¿¼ÑÐ] 325 µ÷¼Á +6 QQСϺ 2026-04-07 6/300 2026-04-07 15:17 by Ccclqqq
[¿¼ÑÐ] 338Çóµ÷¼Á +4 ÎÒÏëÉϰ¶ii 2026-04-05 4/200 2026-04-06 21:04 by ľ×Ó¾ý1218
[¿¼ÑÐ] 22408 ×Ü·Ö320£¬Ò»ÆªÂÛÎĶþ×÷£¬Á½¸ö¹úÈý£¬Çóµ÷¼Á +3 Leomulufu 2026-04-04 5/250 2026-04-05 19:04 by chongya
[¿¼ÑÐ] ÇóÉúÎïѧѧ˶µ÷¼Á¡ª¡ª364·Ö +7 ÔÆ¶äåÞÍäÖ¸ÄÏ 2026-04-04 7/350 2026-04-04 22:49 by zhyzzh
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û