ÎÊÌâÒÑ¿ªÆô (ÆÕͨÎÊÌâ)
excel±íÔÚͨÐÅ·½ÃæµÄÓÃ;
¿ÉÒÔ·¢·ÝÏêϸͨÐűر¸µÄexcel±í¹¦ÄܵÄÁ¬½ÓÂð
ÌáÎÊÕß: ÔÚ·ÉÏ¡¤¡¤¡¤  ÌáÎÊʱ¼ä: 2011-08-20    
 
  ÎÒÒª»Ø´ð£º
 

  ÇëÏÈ µÇ¼ »ò ×¢²á ÔٻشðÎÊÌâ

¸ü¶à ͨÐÅ Excel Ïà¹ØÎÊÌâ
ÎÊÌâ´ð°¸ ( 24 )

Ö±½ÓËÑEXCELµÄʹÓÃ°É Ö÷ÒªÓõÄÊÇһЩ¹«Ê½ ºêµÈ

»Ø´ðÕߣº n657257     »Ø´ðʱ¼ä£º2011-08-21 00:16    

6        2        


Õâ¸öÓõĺܶ࣬¸÷¸ö²¿ÃÅÓв»Í¬µÄ²àÖص㣬ÓÐ×öͳ¼ÆµÄ£¬ÓзÖÎöµÄ£¬ÓÐ×ö±¨¸æµÄ£¬·´Õý»ù±¾¹¦ÄÜ¡¢¹«Ê½ÕÆÎÕÁ˾ÍûÎÊÌâ¡£&)*(&#*K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ


»Ø´ðÕߣº yumenfeng6     »Ø´ðʱ¼ä£º2011-08-21 00:35    

5        3        


Èç¹ûÓÅ»¯Ã»ÓÐExcel,¾ÍÏñÆû³µÃ»ÓÐÁË»úÓÍ¡£4fadsK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
zcv545%K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº decwcx     »Ø´ðʱ¼ä£º2011-08-21 00:35    

6        3        


òËÆûÓУ¬µÈÂ¥Ö÷×öÁ˾ÍÖªµÀÁË

»Ø´ðÕߣº shadowllxzz     »Ø´ðʱ¼ä£º2011-08-21 00:58    

5        3        


ÓÃ;ºÜ´ó£¬±ÈÈçɸѡ£¬ÅÅÐòµÈ»ù±¾¹¦ÄÜ£¡3dsaf12zK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
f8e342ÊÇ43K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº 4GͨÐÅ     »Ø´ðʱ¼ä£º2011-08-21 04:41    

2        5        


ÒªÏ뾫ͨEXCEL£¬VBA±ØÐëҪѧ£¬ÂÛ̳¶¼Óи÷·½Ãæ×ÊÁϵġ£*($(ŶK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
http://www.mscbsc.com/bbs/forum-87-1.html


»Ø´ðÕߣº jingpengtao     »Ø´ðʱ¼ä£º2011-08-21 08:05    

2        5        


Óô¦Ì«¶àÁË£¬ÓÈÆä¶Ô¸ãÍøÓŵÄÀ´Ëµ»21fds3a21fK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº zxz8105     »Ø´ðʱ¼ä£º2011-08-21 08:52    

2        5        


vlookup ÓõıȽ϶àµÄ¡£¡£

Ö÷Òª»¹ÊÇȡһЩָ±ê°É²21f3dsaf12zK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ


»Ø´ðÕߣº nuptlml     »Ø´ðʱ¼ä£º2011-08-21 10:05    

4        6        


²»»áÓÃexcelÄãÓÀÔ¶²»ËãÊÇ×öÓÅ»¯µÄdsfds1faK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
afd5a4f8eK:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
1354afd5K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº ¸Ð¾õ     »Ø´ðʱ¼ä£º2011-08-21 10:55    

4        4        


ÎÒÃǾÍÊÇ×ö͸ÊÓ±í¶øÒÑ£¬ÓõIJ»¶à#*(ÎÒ)$#@322K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº yotry     »Ø´ðʱ¼ä£º2011-08-21 10:56    

7        3        


ÓÃ;̫¶àÁË£¬Èç¹ûÄã×öϵͳ£¬¾ÍÊǸú±í´ò½»µÀ£¬Ï£ÍûÂ¥Ö÷ÄܺúÃѧÕâ¸ö£¡²»21fds3K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
*(&#*K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº danggangqiang     »Ø´ðʱ¼ä£º2011-08-21 11:01    

3        6        


àÅ ÓÈÆäÊǺǫ́ ûÁËÕâ¸ö¼¸ºõ¾Í·ÏµôÁË ±Ø±¸°¡ ÓÃ;µÄ»°Ö÷Òª¾ÍÊǺ¯Êý ͼ±í ɸѡµÈµÈ ¸ù¾Ý²»Í¬·Ö¹¤ÓÐËù²»Í¬«oitre432K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº buptwzz     »Ø´ðʱ¼ä£º2011-08-21 13:02    

3        4        


Ö÷ҪʹÓúêºÍº¯Êý£¬µ½ÍøÉÏËÑÒ»ÏÂexcelµÄº¯ÊýÓëºê¾Í¿ÉÒÔÁË89Î÷7K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
&%#*(ÎÒK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº ÎÒÊǵÂÒ¯     »Ø´ðʱ¼ä£º2011-08-21 18:43    

3        4        


×÷ÓúܴóµÄ£¬ºÃ¶àѧ³¤ÒÔ¼°¹ýÀ´È˶¼ÊÇÕâÑùÌáʾÎҵİ¡¡£¡£Â¥Ö÷Ò²ÒªÖØÊÓ°¡¡£×¢ÒâÊǺ¯ÊýÒÔ¼°ºêµÄÔËÓÃ*(&#*($(Ŷ*K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº cstx520     »Ø´ðʱ¼ä£º2011-08-21 20:59    

3        4        


×÷ÓúÜÇ¿´ó ºÜ±ØÐëµÄ5a4f8e3K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
1fkjhfjK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº yaochunhua1985     »Ø´ðʱ¼ä£º2011-08-22 09:17    

3        4        


if 
vlookup 
match 70874*$#K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
index af12zcvK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
row oejµÀh$#$K:JFD()$#±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
columnouierpoejµÀhK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
average 0874*$#(K:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
sumif kjlurewK:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
sumifs oejµÀh$K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
countif 
countifs K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
count #(ô$*@#(_K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
counta (*)#$K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
µÈµÈ
jlureK:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº lxl810618862     »Ø´ðʱ¼ä£º2011-08-22 09:51    

3        4        


EXCELÔÚ¹¤×÷ÖеÄ×÷ÓÃÌ«´óÁË¡£¸÷¸ö²¿ÃÅ£¬¸÷ÖÖ¹¤×÷¶¼»áÓõ½£¬»ù±¾µÄ¹¦ÄܱÈÈçÅÅÐò¡¢Í³¼Æ¡¢É¸Ñ¡¡¢×ª»»µÈµÈ£¬¶¼¿ÉÒÔ°ïÖúÎÒÃǶÔÊý¾Ý½øÐд¦Àí£¬µÃ³öÓÐÀûµÄ½á¹ûºÍ½áÂÛ¡£Õâ¸ö¹¤¾ßµÄʹÓÃˮƽһ°ã¶¼ÊÇÔÚʵ¼ùÖнø²½µÄ£¬ÓõöàÁË£¬Óöµ½ÎÊÌâÁ˾ͻáÏëÔõô×ö£¬È»ºó¾ÍÈ¥²é£¬¾Í¶®ÁËitre43289Î÷K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ


»Ø´ðÕߣº readread000     »Ø´ðʱ¼ä£º2011-08-22 10:56    

7        8        


ÏëѧһЩvbµÄ֪ʶ£¬Õâ¸öºÜÓÐÓᣡ£¡£Å¬Á¦ÖУ¡ds3a2K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
f12zcv545%#(K:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº zhugeyingju     »Ø´ðʱ¼ä£º2011-08-22 13:10    

2        5        


·Ç³£ÓÐÓð¡¡£±àÂë¿Ú42ÊÇ4K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
4fads13¶«oitK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº sunhaonanaini     »Ø´ðʱ¼ä£º2011-08-22 23:16    

7        5        


×÷ÓúÜÇ¿´óµÄ*&#%kcK:JFD(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
vlookup£»@s4fads13¶K:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
͸ÊÓ£»$#ʲ21f3dsaK:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ɸѡ£»@#(_@s4fadK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
·ÖÁУ»K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
fkjhfjouierpK:JFD()$#_*(±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ


»Ø´ðÕߣº ¹Ô¹ÔèèŮ     »Ø´ðʱ¼ä£º2011-08-23 11:23    

4        5        


¶àÁËÈ¥ÁË£¬×î³£¼ûµÄ¾ÍÊÇvlookup¡£¶«oitre4328K:JFD()$#_*±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº byg_234     »Ø´ðʱ¼ä£º2011-08-23 14:19    

7        7        


ÍøÓÅÀïÃæѧ»áVBAÊÇÒ»¸ö·Ç³£Óгɾ͸кÍʹÓõĶ«Î÷£¬¼´Ê¹ÒÔºó²»×öÍøÓÅÁË£¬ÄÜÊÇÒ»ÏîºÜ²»´íµÄ¼¼ÄÜ¡£
http://club.excelhome.net/forum.php¶*&#%K:JFD±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ºÜ¶àÊÓƵ£¬Ñ§Ï°±È½Ï¿ì
43289Î÷K:JFD()±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº ×£ÎÒºÜ˧     »Ø´ðʱ¼ä£º2011-08-23 20:10    

6        5        


½¨ÒéÈ«ÃæµÄѧϰofficeÈí¼þfd5a4f8eK:JFD()$±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ
ioK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº wsat273     »Ø´ðʱ¼ä£º2011-08-30 11:53    

7        4        


vlookup£¬countif£¬Êý¾Ý͸ÊÓ±í£¬É¸Ñ¡£¬ÅÅÐò£¬»¹ÓнøÖÆ»»Ëã¡£urewioK:JFD()$#_±¾ÎÄÀ´×ÔÒƶ¯Í¨ÐÅÍøwww.mscbsc.com,°æȨËùÓÐ

»Ø´ðÕߣº cdcdccd213     »Ø´ðʱ¼ä£º2011-09-02 10:36    

5        6        

ÖйúͨÐÅÈ˲ÅÍø | ½­ËÕͨÐÅÈ˲ÅÍø | ɽ¶«Í¨ÐÅÈ˲ÅÍø | Î人ͨÐÅÈ˲ÅÍø | Õ㽭ͨÐÅÈ˲ÅÍø | ºþÄÏͨÐÅÈ˲ÅÍø
ÖÐÒÆÌúͨÓÐÏÞ¹«Ë¾½­ÃÅ·Ö¹«Ë¾ Ƹ£ºÎ¬»¤Ö¸±ê¹Ü¿ØÖ÷¹Ü
ÐèÇóÈËÊý£º1 ÈË µØµã£º½­ÃÅÊÐ
ÉϺ£î£îìÖÇÄܿƼ¼ÓÐÏÞ¹«Ë¾ Ƹ£ºËÄ´¨Òƶ¯Åµ»ùÑǸºÔðÈË
ÐèÇóÈËÊý£º1 ÈË µØµã£ºÑÅ°²ÊÐ
±±¾©ÒËͨ»ªÈð¿Æ¼¼ÓÐÏÞ¹«Ë¾ Ƹ£ºÇåÔ¶ÊÐÒƶ¯»ªÎª4/5Gϵͳר¼Ò¼¶
ÐèÇóÈËÊý£º1 ÈË µØµã£ºÇåÔ¶ÊÐ
ÖØÇìÐÅ¿ÆͨÐŹ¤³ÌÓÐÏÞ¹«Ë¾ Ƹ£ºËÄ´¨°ÍÖÐ-IMCÕÐƸ
ÐèÇóÈËÊý£º1 ÈË µØµã£º°ÍÖÐÊÐ
º¼Öݶ«ÐÅÍøÂç¼¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£º²×ÖÝ-¸ß/ÖÐ/³õ¼¶-ÍøÓŹ¤³Ìʦ
ÐèÇóÈËÊý£º30 ÈË µØµã£º²×ÖÝÊÐ
ÄϾ©»ªËտƼ¼ÓÐÏÞ¹«Ë¾ Ƹ£ºÍøÂçÓÅ»¯¹¤³Ìʦ
ÐèÇóÈËÊý£º5 ÈË µØµã£ºÌì½òÊÐ
¹ã¶«ÄÏ·½Í¨ÐŽ¨ÉèÓÐÏÞ¹«Ë¾ Ƹ£ºº£ÄϺǫ́ÓÅ»¯
ÐèÇóÈËÊý£º10 ÈË µØµã£ºº£¿ÚÊÐ,ÈýÑÇÊÐ
Ö麣ÊÀ¼Í¶¦Àû¿Æ¼¼¹É·ÝÓÐÏÞ¹«Ë¾ Ƹ£ºÊµÑéÊÒͨÐÅÉ豸°²×°Î¬»¤(Ë«ÐÝ£©
ÐèÇóÈËÊý£º1 ÈË µØµã£ºº¼ÖÝÊÐ
Õã½­Ê¡Óʵ繤³Ì½¨ÉèÓÐÏÞ¹«Ë¾ Ƹ£ºÉÂÎ÷ÓÜÁÖÒƶ¯5Gϵͳ¹¤³Ìʦ
ÐèÇóÈËÊý£º5 ÈË µØµã£ºÏÌÑôÊÐ,ÓÜÁÖÊÐ
³É¶¼ÆìѶͨÐż¼ÊõÓÐÏÞ¹«Ë¾ Ƹ£ºÄÏÄþ/ÎàÖÝ/±±º£ÕÐͶËß²âÊÔ¡¢ºǫ́
ÐèÇóÈËÊý£º12 ÈË µØµã£ºÄÏÄþÊÐ,ÎàÖÝÊÐ,±±º£ÊÐ,ºÓ³ØµØÇø,ÁøÖÝÊÐ
ÈȵãÎÊÌâ
¸ü¶à¾«²Ê

ÁªÏµÎÒÃÇ - ÎÊͨÐÅר¼Ò Powered by MSCBSC Òƶ¯Í¨ÐÅÍø  © 2006 -