24СʱÈÈÃŰæ¿éÅÅÐаñ    

²é¿´: 1485  |  »Ø¸´: 4

361936233

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

[ÇóÖú] Çë½ÌÒ»¸öÎÊÌ⣬ÈçºÎ½«EXCELɸѡµ½µÄÄÚÈݸ´ÖƵ½ÆäËûµØ·½£¿ ÒÑÓÐ3È˲ÎÓë

ÎÊÌâÊÇÕâÑùµÄ£ºÎÒÐèÒªÔÚExcelµÄsheet1µÄijһ¿éÇøÓòÖÐɸѡ°üº¬AµÄÐÅÏ¢£¨ÓÃCTRL+F²éÕÒÓм¸°ÙÌõ£©£¬È»ºó½«ÕâЩ°üº¬AµÄÐÅÏ¢¸´ÖƵ½sheet2ÖÐÈ¥£¬Èç¹ûÒ»ÌõÒ»ÌõµÄ¸´ÖÆÊ®·ÖÂé·³£¬ÇëÎÊÄܲ»ÄÜÓø߼¶É¸Ñ¡£¬½«°üº¬AµÄÐÅÏ¢¸´ÖƵ½ÆäËûµØ·½È¥£¿Èç¹û¿ÉÒԵϰ£¬É¸Ñ¡µÄÌõ¼þº¯ÊýÓ¦¸ÃÔõÑùд£¿´¿Ð¡°×£¬Çë´óÉñ½â»ó£¡Ð»Ð»£¡
»Ø¸´´ËÂ¥

» ÊÕ¼±¾ÌûµÄÌÔÌûר¼­ÍƼö

Ñо¿Éú¿ÆÑÐÐĵà µçÄÔʹÓÃ

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

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

Ministar123

Í­³æ (СÓÐÃûÆø)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
Ctrl+G ɸѡ²¢¶¨Î»¿É¼ûµ¥Ôª¸ñ  È»ºó¸´ÖÆ

[ ·¢×ÔСľ³æ¿Í»§¶Ë ]
×îÃÀºÃµÄʱ¹â¸ø×î°®µÄÈË¡£
2Â¥2015-03-20 00:01:01
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

361936233

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

ÒýÓûØÌû:
2Â¥: Originally posted by Ministar123 at 2015-03-20 00:01:01
Ctrl+G ɸѡ²¢¶¨Î»¿É¼ûµ¥Ôª¸ñ  È»ºó¸´ÖÆ

¿ÉÒÔ˵µÄÏêϸһµãÂð£¿ÎÒÔÚÍøÉÏÕÒÁ˲»ÉÙ·½·¨¶¼Ã»³É¹¦¡£¡£
ºÇºÇ
3Â¥2015-03-20 08:33:47
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

rsb_long

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
ÔÚexcelÖе¥¶ÀÑ¡ÔñÄãÐèÒªµÄÄÚÈÝ,·½·¨Êǰ´Ctrl¼üµÄͬʱʹÓÃÊó±êÁ¬ÐøÑ¡Ôñ²»Í¬µÄÇøÓò¾Í¿ÉÒÔ,Ctrl_C,È»ºóCtrl_Vµ½Ð±íÖÐ,»òÕßÏȸ´ÖƵ½WordÖÐ,È»ºóÔÙ´ÓWordÖÐȫѡºó,Ctrl_C,È»ºóÔÙµ½ExcelÖÐCtrl_V
4Â¥2015-03-20 22:48:49
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

deephill

Ìú¸Ëľ³æ (Ö°Òµ×÷¼Ò)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
ÎÒ½¨ÒéÄãʹÓú¯Êý£¬Ê¹ÓÃvba Ò²¿ÉÒÔ¡£ÄãµÄÎÊÌâ¼òµ¥£¬Äã¾ÍÓú¯ÊýµÄ·½·¨¡£ÎÒ²»ÖªµÀÄãÒª²éÕÒµÄA ÊǸöʲô¶«Î÷¡£
1 ÒªÊÇÊÇÊý×ֺܺð죬ÓÃifÓï¾ä¡£ÐÂÔöÒ»ÁУ¬ÓÃifÓï¾äµÃ³ö0ºÍ1µÄ½á¹û£¬ÖØÐ¸´ÖÆÕ³ÌùÈ¥µô¹«Ê½£¬¶Ô½á¹ûÁÐÅÅÐò¾Í»á¼¯ÖÐÆðÀ´£¬¼¯ÖÐɾ³ýµôÎÞÓõÄÐС£
2 ÈôAÊÇ×Ö·û£¬¾ÍÓÃfindº¯Êý£¬ÓиöÀý×Ó½éÉÜ¡£
FIND(²éÕÒµÄ×Ö·û´®£¬ÔÚÄĸö×Ö·û´®Àï²éÕÒ,´ÓµÚ¼¸Î»¿ªÊ¼²éÕÒ£©
     ×¢Ò⣺FINDº¯Êý·µ»ØµÄÊÇ×Ó×Ö·û´®ÔÚ±»²éÕÒ×Ö·û´®ÖеÄλÖã¬ÈçÔÚ"ABCD"Àï²éÕÒB£¬FIND("B","ABCD"µÃµ½µÄ½á¹ûÊÇBµÄλÖÃ2£¬Èç¹û²éÕÒ²»µ½,±ÈÈçFIND("E","ABCD"£©Ôò·µ»Ø´íÎóÖµ"#VALUE".

È»ºóÄã°´½á¹ûÅÅÐò£¬Äã°Ñ½á¹ûΪ  "#VALUE"£¬¼¯ÖÐÔÚÒ»¿é£¬Ò»Æð¾Íɾ³ýµôÁË¡£

ÄãʵÔÚ²»»áŪ£¬´«ÉÏÊý¾Ý£¬ÎÒ°ïÄãŪÏ¡£
5Â¥2015-03-21 13:29:55
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ 361936233 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[»ù½ðÉêÇë] ÔÚ¼á±ù»¹¸Ç×ű±º£µÄʱºò£¬ÎÒ¿´µ½ÁËÅ­·ÅµÄ÷»¨¡£ +4 ziyangfang 2026-08-25 4/200 2026-08-25 14:41 by ZJTJZ
[»ù½ðÉêÇë] ʲôʱºò¿ª½±£¿ +12 CrisMessi 2026-08-18 13/650 2026-08-25 14:40 by ZJTJZ
[»ù½ðÉêÇë] Èç¹û´Ë¿ÌÄãÕýÔÚΪ¹ú»ù¸Ðµ½½¹ÂÇ£¬²»·ÁÀ´ÌýÌýÕâÊס¶»ù½ðÖ®Íâ¡· +8 scalable 2026-08-24 8/400 2026-08-25 12:52 by jnhyjjm
[»ù½ðÉêÇë] ûÓÐÈκÎÏûÏ¢-ÊDz»ÊǾÍÁ¹ÁË +9 ͼÀ²Í¼À² 2026-08-24 10/500 2026-08-25 11:59 by ÄϺ£Ð¡¸ç
[»ù½ðÉêÇë] 2026¹ú×ÔÈ»º¯ÆÀ·Ñµ½ÕË +19 ÑòÑü°å 2026-08-21 22/1100 2026-08-25 10:38 by popular289
[»ù½ðÉêÇë] ½ñÌì»ù½ð»á³ö½á¹ûÂð£¿20260819 +17 kkkl_v 2026-08-19 18/900 2026-08-25 09:41 by windflowerwy
[»ù½ðÉêÇë] ÎÒÃæÉÏÍêµ°ÁË +13 ÇÒÌý»¢Ð¥ 2026-08-20 14/700 2026-08-25 09:10 by mrkang
[»ù½ðÉêÇë] ·¶½øÖоÙÒ»ÎĵÄÖÐÐÄ˼Ïë +7 Ñ׻ƹóëÐ 2026-08-22 8/400 2026-08-25 08:48 by ZJTJZ
[»ù½ðÉêÇë] Ã÷ÌìÓ¦¸Ã¿É²éÁË£¡£¿ +5 chengyan1220 2026-08-23 5/250 2026-08-24 23:28 by ÎÒ4´ó°×²Ë
[»ù½ðÉêÇë] filecode£¬4¸öjtjcÁË +14 ziyangfang 2026-08-19 17/850 2026-08-24 18:37 by ¹þ¹þ¸ò£¿
[»ù½ðÉêÇë] ½¨Òé»ù½ð·¢²¼Ìáǰ¸ø³öÃ÷È·µÄʱ¼äµã +13 kulium 2026-08-21 16/800 2026-08-24 16:27 by superceng
[»ù½ðÉêÇë] ½ñÈÕ²»·Å°ñ£¿Íø´«¹ú×ÔȻԤ¼Æ 8 Ô 27 Èտɲé½á¹û +17 ҽѧÀÏÄк¢ 2026-08-20 21/1050 2026-08-24 14:21 by refreshing11
[»ù½ðÉêÇë] ÈÃÎÒÖÐÒ»¸öÃæÉϰɣ¡ +13 ´óƼ1987 2026-08-20 16/800 2026-08-24 10:23 by ̫ɵÁË
[»ù½ðÉêÇë] ¿ÆÑй¶ùÌ«ÄÑÁË +18 ÎÒ4´ó°×²Ë 2026-08-20 19/950 2026-08-24 09:47 by ¿­¶÷¹ãÊ¢´ß»¯·ÖÎ
[½Ìʦ֮¼Ò] Ìø²ÛºóÔÚÑÐÏîÄ¿Ôõô°ì£¿ +5 ¼òµ¥»¯xn 2026-08-22 10/500 2026-08-23 12:38 by ¼òµ¥»¯xn
[»ù½ðÉêÇë] ½ñÌì·Å°ñÂ𣿠+15 ²¼²¼ºÍÒ»¶þ 2026-08-19 16/800 2026-08-23 09:55 by ÕÅ´ºÉú
[»ù½ðÉêÇë] ʱ¼ä´Á½ñÌ죬20ºÅ±äÁË +5 archvillain 2026-08-20 5/250 2026-08-22 06:12 by hui_daxiao
[»ù½ðÉêÇë] ¿´À´½ñÌì²»»á·Å°ñÁË£¿ +8 chengyan1220 2026-08-21 11/550 2026-08-21 17:52 by dcqxinyang
[»ù½ðÉêÇë] Ó¦¸ÃÊÇÏÂÖÜÈý26ÈÕ¹«²¼Á˰ɣ¿ +4 ¹þ¹þ¸ò£¿ 2026-08-21 4/200 2026-08-21 10:58 by Vivilian
[»ù½ðÉêÇë] Ã÷Ìì·Å°ñ£¿ +5 Shxjjxjkx 2026-08-18 5/250 2026-08-18 18:14 by -´ó´ó´ó´ó´ó-
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û