ÎÊÌâÒÑ¿ªÆô
(ÆÕͨÎÊÌâ)
´ó¼ÒÔÚд·ÖÎö±¨¸æ»ò´¦ÀíÊý¾Ýʱͨ³£Óõ½µÄEXCELº¯Êý¶¼ÓÐÄÄЩ£¿
ÎҸоõ×Ô¼º×î³£ÓõľÍÊÇÒ»¸öVLOOKUP,»¹ÓÐSUM AVERAGE RIGHT LEFT COUNTIF ,ÔÙÓоÍÊÇÕÛÏßͼµÄÖÆ×÷ÁË£¬¸Ð¾õ×Ô¼ºµÄ±¨¸æˮƽºÜµÍ£¬ÏëÇëÎÊ´ó¼Òƽʱ¶¼ÓÃÄÇЩº¯Êý£¬´ó¸Å½²½²Óô¦£¬Ò»ÆðÀ´·ÖÏíһϣ¬Ð»Ð»°¡£¡
ÌáÎÊÕß: µÂÈ«ÌìºÏdt ÌáÎÊʱ¼ä: 2013-01-24
• ÉÏ´ÎÊÐÇøGSMÀÍøµÄʱºò³öÏÖ¸öÆðºôʧ°Ü£¬Íû°ïæ·ÖÎöһϠ2011-01-09
• ×öCÍøµÄºǫ́·ÖÎöÓ¦¸Ã¿´ÄÄЩ×ÊÁÏ£¿ 2011-01-08
• TDµô»°ÔÒò·ÖÎö£¬Çë¸ßÊÖÖ¸µã 2011-01-07
• 23G²Ù×÷£¬GÍø¡úTDÖ®ºó£¬Î»ÖøüнáÊøºóÒƶ¯Ì¨1ÃëÄÚ·¢ËÄ´ÎRRC CONNECTION RELEASE£¬Ã¿´Î¶¼Èç´Ë£¬ÊÔ·ÖÎöÔÒò 2011-01-07
• ÇóGSMºÍGPRSµÄ·²â·ÖÎö°¸Àý 2011-01-06
• ¸÷λÐֵܽãÃã¬ÇëÎÊÍøÓÅÒªÏòºǫ́·ÖÎö·¢Õ¹£¬ÒªÑ§Ï°Ê²Ã´¶«¶«£¿ÎÒ¸Õ¸ÕÍøÓÅÈëÃÅ£¬ºÜ¶à²»¶®£¡ 2011-01-05
• ÏÖÔÚÐèÒª×öÒ»¸öÍøÂç²å»¨¶ÔÍøÂçÖÊÁ¿Ó°ÏìµÄ·ÖÎö£¬Ö÷ÒªÊÇÇл»³É¹¦ÂÊÉϵÄÓ°Ï죬´óÏÀÃǸøµãÒâ¼û£¬Ô½ÏêϸԽºÃ°¡ 2010-12-23
• ´Ó²âÊÔÈçºÎ×öµ½ºǫ́·ÖÎö°¡£¬×î¶ÌÒª¶à¾ÃÄØ£¿ 2010-12-22
• ×öCÍøµÄºǫ́·ÖÎöÓ¦¸Ã¿´ÄÄЩ×ÊÁÏ£¿ 2011-01-08
• TDµô»°ÔÒò·ÖÎö£¬Çë¸ßÊÖÖ¸µã 2011-01-07
• 23G²Ù×÷£¬GÍø¡úTDÖ®ºó£¬Î»ÖøüнáÊøºóÒƶ¯Ì¨1ÃëÄÚ·¢ËÄ´ÎRRC CONNECTION RELEASE£¬Ã¿´Î¶¼Èç´Ë£¬ÊÔ·ÖÎöÔÒò 2011-01-07
• ÇóGSMºÍGPRSµÄ·²â·ÖÎö°¸Àý 2011-01-06
• ¸÷λÐֵܽãÃã¬ÇëÎÊÍøÓÅÒªÏòºǫ́·ÖÎö·¢Õ¹£¬ÒªÑ§Ï°Ê²Ã´¶«¶«£¿ÎÒ¸Õ¸ÕÍøÓÅÈëÃÅ£¬ºÜ¶à²»¶®£¡ 2011-01-05
• ÏÖÔÚÐèÒª×öÒ»¸öÍøÂç²å»¨¶ÔÍøÂçÖÊÁ¿Ó°ÏìµÄ·ÖÎö£¬Ö÷ÒªÊÇÇл»³É¹¦ÂÊÉϵÄÓ°Ï죬´óÏÀÃǸøµãÒâ¼û£¬Ô½ÏêϸԽºÃ°¡ 2010-12-23
• ´Ó²âÊÔÈçºÎ×öµ½ºǫ́·ÖÎö°¡£¬×î¶ÌÒª¶à¾ÃÄØ£¿ 2010-12-22
ÎÊÌâ´ð°¸
( 4 )
VLOOKUP,±à¼ºê£¬ÐÐÁÐת»»µÄ²å¼þ£¬¸÷ÖÖɸѡµÄ¼¼ÇÉ
»Ø´ðÕߣº
xhy1331
»Ø´ðʱ¼ä£º2013-01-24 12:30
15 9
³ýÁËÄã˵µÄÄǼ¸¸öº¯ÊýÍ⣬ÓÐʱÓõ½16½øÖƺÍ10½øÖÆת»»£¬±ÈÈçCI/LAC£»ÖÁÓÚ×ÊÁÏûÓÐ
»Ø´ðÕߣº
happy2369@163.c
»Ø´ðʱ¼ä£º2013-01-24 13:52
15 9
countif if left
»Ø´ðÕߣº
chukui116
»Ø´ðʱ¼ä£º2013-01-25 10:13
15 9
»ù±¾ÉϾÍÊÇÕâЩº¯ÊýÁË£¬ÆäËüµÄÒ»°ãÓõÄÏ൱ÉÙ¡£
»Ø´ðÕߣº
zhangshiqin
»Ø´ðʱ¼ä£º2013-01-25 18:53
15 12
ÈȵãÎÊÌâ
¸ü¶à¾«²Ê
ÁªÏµÎÒÃÇ - ÎÊͨÐÅר¼Ò | Powered by MSCBSC Òƶ¯Í¨ÐÅÍø © 2006 - |