[B! microsoft][Excel] teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

teddy-g id:teddy-g

microsoftã¨Excelã«é–¢ã™ã‚‹teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã§ã©ã‚“ãªæ–‡å—åˆ—ã‹ã‚‰ã§ã‚‚æ•°å—ã ã‘ã‚’æŠ½å‡ºã§ãã‚‹æ–¹æ³•ï¼è£æŠ€ | ãƒ›ãƒ¯ã‚¤ãƒˆãƒ¬ã‚¤ã‚¢
ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã§ã€æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã ã‘ã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ã‚¨ã‚¯ã‚»ãƒ«ã§ã€ã‚»ãƒ«ã«æ–‡å—åˆ—ã¨æ•°å€¤ãŒæ··åœ¨ã—ã¦å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹å ´åˆã€æ–‡å—åˆ—ã®ä¸ã‹ã‚‰æ•°å—ã®ã¿å–ã‚Šå‡ºã—ãŸã„ã¨ã„ã†ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãã®ã‚ˆã†ãªå ´åˆã€ã©ã®ã‚ˆã†ã«ã—ã¦ã‚»ãƒ«ã®æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã®ã¿ã‚’å–ã‚Šå‡ºã›ã°ã‚ˆã„ã®ã§ã—ã‚‡ã†ã€‚æ–‡å—åˆ—ã®ä¸ã«ã€æ•°å€¤ãŒè¦å‰‡çš„ã«å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã¨ç°¡å˜ã«æŠ½å‡ºã§ãã¾ã™ãŒã€ä¸è¦å‰‡ã§æ•°å—ã®æ•°ã‚‚ä¸€å®šã§ã¯ãªã„ã¨ã€æŠ½å‡ºã™ã‚‹ã®ã¯é›£ã—ããªã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ã€ã‚»ãƒ«ã®æ–‡å—åˆ—ã‹ã‚‰ã€æ•°å—ãŒã©ã®ä½ç½®ã«ã‚ã£ã¦ã‚‚ã€æ•°å—ã®æ•°ãŒå¹¾ã¤ã‚ã£ã¦ã‚‚ã€æ•°å—ã ã‘ã‚’ç°¡å˜ã«æŠ½å‡ºã™ã‚‹æ–¹æ³•ã‚’èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚æ–‡å—åˆ—ã®å·¦ç«¯ã€ä¸ã€å³ç«¯ã§ã‚‚ç°¡å˜ã«æ•°å€¤ã®ã¿æŠ½å‡ºã§ãã¾ã™ã€‚ æ•°å—ï¼‹æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³•æ•°å—ï¼‹æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã‚’æŠ½å‡ºã—ã¾ã™ã€‚ B1ã«ã€ã€Œ325ANï½± å“å·ã€ã®æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã®ã¿æŠ½å‡ºã™ã‚‹å¼ã‚’å…¥åŠ›ã—ã¾ã—ã‚‡ã†ã€‚ æ•°å—ãŒæ–‡å—åˆ—ã®ä¸€ç•ªå·¦ç«¯ã«ã‚ã‚‹æ™‚ã€ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°LEFTãŒåŸºæœ¬ã¨ãªã‚Šã¾ã™ã€‚ LE
teddy-g 2019/05/09
ã‚°ã‚°ã‚‹ã¨ã‚ˆããƒ’ãƒƒãƒˆã™ã‚‹LOOKUPã¨LEFTã€COLUMNã‚’ä½¿ã†ã‚„ã¤ã‚ˆã‚Šä½¿ãˆã‚‹ã€‚æ•°å—ãŒæ–‡å—åˆ—ã®ã©ã“ã«å…¥ã£ã¦ã¦ã‚‚æŠ½å‡ºã§ãã‚‹ã€‚

microsoft

excel

tips
ãƒªãƒ³ã‚¯
EXCEL findã‚’å³ã‹ã‚‰(å¾Œã‚ã‹ã‚‰)æ¤œç´¢ã™ã‚‹æ–¹æ³•
EXCEL findã‚’å³ã‹ã‚‰(å¾Œã‚ã‹ã‚‰)æ¤œç´¢ã™ã‚‹æ–¹æ³•ã¯ãŠãã‚‰ãã“ã‚Œã—ã‹ãªã„ï¼ æ–‡å—åˆ—é–¢æ•°ã®é‰„æ¿ã§ã‚ã‚‹findã§ã™ãŒã€é€šå¸¸ã¯å·¦ã‹ã‚‰ã®æ¤œç´¢ã—ã‹ã§ããªã„ã§ã™ã‚ˆãã€‚ ã“ã‚Œã‚’å³ã‹ã‚‰(å¾Œã‚ã‹ã‚‰)æ¤œç´¢ã€æ™®é€šã«ã‚„ã‚‹ã¨ã§ããªã„ã‚“ã§ã™ãŒ ã‚ã‚‹é–¢æ•°ã‚’çµ„ã¿åˆã‚ã›ã‚Œã°å³ç«¯ã®æ–‡å—æ¤œç´¢ãŒã§ãã‚‹ã‚“ã§ã™ï¼ Find ã¾ãšã¯é€šå¸¸ã®å·¦ã‹ã‚‰ã ã¨ ä»Šå›žã®ä¾‹ã¨ã—ã¦ã€A3ã®æ–‡å—åˆ—ã€Œaaa-bbb-ccc-dddã€ã®æ–‡å—åˆ—ã‹ã‚‰ãƒã‚¤ãƒ•ãƒ³ã€Œ-ã€ã®æ–‡å—ä½ç½®ã‚’å–å¾—ã—ã¾ã™ã€‚ é€šå¸¸ã®Findã§å·¦ã‹ã‚‰æ¤œç´¢ã‚’è¡Œã£ãŸã¨ãã«æ•°å¼ãƒ»çµæžœã¯ã“ã†ãªã‚Šã¾ã™ã€‚ æ•°å¼ï¼š=FIND("-",A3) çµæžœï¼š4 Findã§å³ã‹ã‚‰æ¤œç´¢ã¯ã©ã†ã‚„ã‚‹ã®ï¼Ÿ æ–‡å—åˆ—ã‹ã‚‰ãƒã‚¤ãƒ•ãƒ³ã€Œ-ã€ã®ä¸€ç•ªå³ã®ä½ç½®ã‚’å–å¾—ã—ãŸã„ã¨ãçµæžœãŒ12ã«ãªã‚Šã¾ã™ã€‚ ã“ã‚Œã‚’Findã§å–å¾—ã—ãŸã„ã¨ãã€ã‚ã‚‹é–¢æ•°ã¨çµ„ã¿åˆã‚ã›ã‚‹ã“ã¨ã§å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ SUBSTITUTEé–¢æ•°ã¨LENé–¢æ•°ã‚’ä½¿ã£ã¦ã€å³ã‹ã‚‰æ¤œç´¢ã‚’å¯èƒ½ã« æ•°å¼ï¼š=
teddy-g 2019/05/09
SUBSTITUTEã®ç¬¬4ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ä½•ç•ªç›®ã«ãƒ’ãƒƒãƒˆã—ãŸã‚‚ã®ã‚’ç½®ãæ›ãˆã‚‹ã‹ã‚’æŒ‡å®šã™ã‚‹ã€‚ã“ã‚Œã‚’ä½¿ã£ã¦æœ€å¾Œã«ãƒžãƒƒãƒã—ãŸæ¤œç´¢å¯¾è±¡ã‚’ç‰¹å®šã®æ–‡å—ã«ç½®ãæ›ãˆã¦ä½ç½®ã‚’èª¿ã¹ã‚‹ã¨ã„ã†ã®ãŒãƒŸã‚½ã€‚

microsoft

excel

tips
ãƒªãƒ³ã‚¯
MS Flowã§ã‚ã‚‹ç‰¹å®šæ¡ä»¶ã®ãƒ¡ãƒ¼ãƒ«å—ä¿¡ã—ãŸã‚‰Boxã®ä¸ã®EXCELãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’1è¡ŒæŒ¿å…¥ã™ã‚‹ - Qiita
#èƒŒæ™¯ ç¤¾å†…ã®æ´¾é£ã•ã‚“ã‚„ç¤¾å“¡ï¼ˆéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼‰ãŒã€ä»¶åã‚„å·®å‡ºäººã¨ã‹ç‰¹å®šæ¡ä»¶ã®ãƒ¡ãƒ¼ãƒ«æƒ…å ±ã‚’æ‰‹ã§EXCELã®ä¸€è¦§ã«ã‚³ãƒ”ãƒšã™ã‚‹ã¨ã„ã†ä½œæ¥ã‚’æ—¥ã€…ã‚„ã£ã¦ã„ã‚‹ã¨ã„ã†é©šæ„•ã®äº‹å®Ÿã‚’çŸ¥ã‚Šã€ãã‚Œç°¡å˜ã«è‡ªå‹•åŒ–ã§ãã¡ã‚ƒã†ã‚ˆã£ã¦æ•™ãˆã¦ã‚ã’ãŸæ‰€å–œã‚“ã§ãã‚Œã¾ã—ãŸã€‚ Flowã¯è‡ªåˆ†ã§ç°¡å˜ã«ä½œã£ã¦è‡ªåˆ†ã®ä»•äº‹æ”¹å–„ã—ã¦ã„ã‘ã‚‹ã£ã¦ã®ãŒæ¥½ã—ã„ã‚ˆãã€‚ #æ¡ä»¶ ä»Šå›žã®æ‰‹é †ã¯ä»¥ä¸‹å‰æã«ã—ã¦ã¾ã™ã€‚ Office365ã®Flowï¼ˆãƒ•ãƒªãƒ¼ã§ä½œã‚Œã‚‹Microsoftã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚„AzureLogicAppsã§ã‚‚ä½¿ãˆã‚‹ï¼‰ Boxï¼ˆOneDriveã¨ã‹DropBoxã¨ã‹ä»–ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚‚ã§ãã‚‹ï¼‰ #æ‰‹é † ##Flowã‚·ãƒŠãƒªã‚ªã§ãƒˆãƒªã‚¬ã‚’ä½œã‚‹ Office365ç”»é¢é–‹ã[Flow]ã‚’ã‚¯ãƒªãƒƒã‚¯ã€ã‚‚ã—ãã¯ã‚¿ã‚¤ãƒ«ãŒãªã„å ´åˆã«ã¯[ã™ã¹ã¦ã®ã‚¢ãƒ—ãƒªã‹ã‚‰æŽ¢ã™]ã‹ã‚‰æŽ¢ã—ã¾ã™ã€‚ã‚‚ã—ãã¯Flowç›´æŽ¥é–‹ã„ã¦ãƒã‚°ã‚¤ãƒ³ã—ã¦ã‚‚OKã€‚ [ãƒžã‚¤ãƒ•ãƒãƒ¼] ï¼ž [ä¸€ã‹ã‚‰ä½œæˆ]ã‚’ã‚¯ãƒªãƒƒ
teddy-g 2019/05/09
ã“ã‚Œèªã‚“ã§å—ä¿¡ãƒ¡ãƒ¼ãƒ«ã®è‡ªå‹•è¨˜éŒ²ã‚’Flowã§ä½œã£ã¦ã¿ãŸã€‚ãã‚Œãªã‚Šã«è‹¦åŠ´ã—ãŸã€‚

Excel

excel

microsoft

office

flow

office365
ãƒªãƒ³ã‚¯
[Power BI / Excel] è¤‡æ•°ã«ã¾ãŸãŒã‚‹ Web ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹
Excel ã‚„ Power BI Desktop ã®ãƒ‡ãƒ¼ã‚¿å–å¾—ã®æ©Ÿèƒ½ã§ã‚ã‚‹ Power Query ï¼ˆãƒ‡ãƒ¼ã‚¿ã®å–å¾—ã¨å¤‰æ›ï¼‰ ã®è©±é¡Œã§ã™ã€‚ åœ°éœ‡ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ æœ€è¿‘ã€ã¾ãŸåœ°éœ‡ãŒå¤šã„ã®ãŒæ°—ã«ãªã‚Šã¾ã™ã‚ˆãã€‚åœ°éœ‡ãƒ‡ãƒ¼ã‚¿ã¯æ°—è±¡åºã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§éšæ™‚å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã€ã“ã®å…¬é–‹ãƒ‡ãƒ¼ã‚¿ã¯ã€è‰¯ã„æ„å‘³ã§ãƒ‡ãƒ¼ã‚¿ ã‚¯ãƒ¬ãƒ³ã‚¸ãƒ³ã‚°ã®ã‚µãƒ³ãƒ—ãƒ«ã«ãªã‚Šã€é•ã†æ„å‘³ã§ã¯ã€Œé›†è¨ˆã€ã‚„ã€Œãƒ¬ãƒãƒ¼ãƒˆä½œæˆã€ãªã©ã®å¾Œå·¥ç¨‹ã‚’ã‚ã¾ã‚Šè€ƒæ…®ã—ã¦ã„ãªã„ãƒ‡ãƒ¼ã‚¿ã‹ã‚‚ã—ã‚Œãªã„ã€ã¨æ„•ç„¶ã¨ã—ã¾ã™ã€‚ ä»Šå›žã®ãŠé¡Œã¨ã¯é›¢ã‚ŒãŸè©±é¡Œãªã®ã§ã™ãŒã€ã¡ã‚‡ã£ã¨ã ã‘ã”ç´¹ä»‹ã—ã¾ã™ã€‚ http://www.jma.go.jp/jp/quake/quake_local_index.html ã™ã¹ã¦ã®æ•°å—ãŒã€Œå…¨è§’ã€ã§ã™ã€‚å¤§ãã„ã€å°ã•ã„ã®åˆ¤æ–ã‚’ã™ã‚‹ãŸã‚ã«ã¯æ•°å€¤ã«ã—ãªã„ã¨æ¯”è¼ƒã§ããªã„ã®ã§ã€ã¾ãšã¯ã“ã‚Œã‚’åŠè§’ã«å¤‰æ›ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚åŒã˜ãæ—¥ä»˜ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ•°å—ã‚‚å…¨è§’ã§ã™ã€‚è‰¯ã„ã‹
teddy-g 2019/02/11
Power Queryã§ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æŒ‡å®šã™ã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨é©å½“ã«è¡¨ã¨ã‹ã¨ã£ã¦ãã‚‹ã®ã«ä¾¿åˆ©

tips

Excel

microsoft

office
ãƒªãƒ³ã‚¯
MySQLåˆå¿ƒè€…å…¥é–€è¬›åº§
ãƒ»æœ¬æ ¼çš„ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã³ãŸã„å ´åˆã¯ Javaåˆå¿ƒè€…å…¥é–€è¬›åº§ ã‚’æ¬¡ã®ã‚¹ãƒ†ãƒƒãƒ—ã¨ã—ã¦ã”æ´»ç”¨ãã ã•ã„ã€‚ ãƒ»Webç³»ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã³ãŸã„å ´åˆã¯ PHPåˆå¿ƒè€…å…¥é–€è¬›åº§ ã‚’æ¬¡ã®ã‚¹ãƒ†ãƒƒãƒ—ã¨ã—ã¦ã”æ´»ç”¨ãã ã•ã„ã€‚ ä»Šå›žã¯MySQLã«ä½œæˆæ¸ˆã¿ã®ã€ŒSampleDB040ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€ODBCãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«ç™»éŒ²ã—ã¾ã™ã€‚ç™»éŒ²ã™ã‚‹ã¨Accessãªã©ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰MySQLã«æŽ¥ç¶šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ODBCãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã¸ã®ç™»éŒ²ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«ãªã‚Šã¾ã™ã€‚ã‚‚ã—MySQLã«æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ã¦ODBCã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€æ–°ãŸã«ç™»éŒ²ãŒå¿…è¦ã§ã™ã€‚ ï¼Šä»¥ä¸‹ã®ç™»éŒ²ä½œæ¥ã‚’è¡Œãªã†ã«ã¯ã€MySQLãŒé–‹å§‹ã—ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã®ã§ã€ã”æ³¨æ„ãã ã•ã„ã€‚ ã€1ã€‘ã‚ã‚‰ã‹ã˜ã‚MySQLã‚’é–‹å§‹ã—ã¦ãŠãã¾ã™ã€‚ 1.ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’èµ·å‹•ã—ã¾ã™ã€‚ 2.ã€Œnet start mysqlã€ã¨å…¥åŠ›ã—ã€ã€ŒEnterã‚ãƒ¼ã€ã‚’æŠ¼
teddy-g 2014/02/04
MySQLã‚’EXCELã§ä½¿ã†ã«å½“ãŸã£ã¦ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ã¶ã¡è¾¼ã‚€æ–¹æ³•ã«å°±ã„ã¦

mysql

excel

windows

microsoft

office
ãƒªãƒ³ã‚¯
Datamensional - Analytics Consulting, Weather Data, Data Management
Add weather, gain a competitive edge If you still donâ€™t have a weather strategy in place, youâ€™re missing a golden opportunity.
teddy-g 2014/02/04
Excelã‹ã‚‰MySQLä½¿ã†ã¨ãã®ç´°ã‹ã„èª¬æ˜Ž

excel

database

mysql

office

microsoft
ãƒªãƒ³ã‚¯
PowerPivot for Excel 2010 å…¥é–€ç·¨ æ“ä½œã®åŸºç¤Ž
PowerPivot for Excel is anÂ add-in toÂ Excel 2010 that is used forÂ adding and integrating large amounts of data in Excel workbooks. The data that you add to the workbook is stored internally, as an embedded PowerPivot database inside the .xlsx file. You can use this database in Excel or in Power View reports. In Excel, the workbook provides all of the data visualization and interaction features. Usi
teddy-g 2014/02/04
Excelã‹ã‚‰MySQLä½¿ã†æ–¹æ³•ã€‚ä½¿ã„ã“ãªã›ãŸã‚‰ä¾¿åˆ©ãã†ã ãŒã€çµå±€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰CSVåãå‡ºã•ã›ã¡ã‚ƒã†

microsoft

office

excel

access

database

mysql
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2009/07/14/20090713the-complete-guide-to-microsofts-office-2010/
teddy-g 2009/07/14
ä¹…ã€…ã«ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆè£½å“ã«èŒãˆãŸã€‚

microsoft

office

excel

powerpoint

word
ãƒªãƒ³ã‚¯
ãƒ•ã‚£ãƒ«ã‚¿ã‚ªãƒ—ã‚·ãƒ§ãƒ³(AdvancedFilter)ã§ã®ãƒ‡ãƒ¼ã‚¿æŠ½å‡º:Excel VBAå…¥é–€
ãƒ•ã‚£ãƒ«ã‚¿ã‚ªãƒ—ã‚·ãƒ§ãƒ³(AdvancedFilter)ã§ã®ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºã€€ã€€ã€€Topã¸ ãƒ‡ãƒ¼ã‚¿ãƒªã‚¹ãƒˆã‹ã‚‰å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—ã¾ã™ã€‚ æŠ½å‡ºæ¡ä»¶ã‚’ã‚»ãƒ«ã«æ›¸ãå‡ºã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ æŠ½å‡ºæ¡ä»¶ã®æ›¸ãæ–¹ã¯Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦ç•°ãªã‚‹ã®ã§æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ Excel2002ã¯å®Œå…¨ä¸€è‡´ã€ãã‚Œä»¥å¤–ã¯å‰æ–¹ä¸€è‡´ã«ãªã‚Šã¾ã™ã€‚ è©³ã—ãã¯ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºã®æ¡ä»¶è¨å®šãŒãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦ç•°ãªã‚‹ã‚’ã”è¦§ãã ã•ã„ã€‚ expression.AdvancedFilter(Action, CriteriaRange, CopyToRange, Unique)
teddy-g 2009/02/05
ãƒ•ã‚£ãƒ«ã‚¿ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’VBAã§æ›¸ãã¨ãã®ç´°ã‹ã„è¨å®šã€‚çµæ§‹ä½¿ã†ã®ã§å‚™å¿˜ç”¨ã«ã€‚

vb

vba

excel

microsoft
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
teddy-g 2009/01/15
JSONã‚’VBAã§ä½¿ã†ã€‚

vba

excel

word

microsoft

json

jsonp
ãƒªãƒ³ã‚¯
CNET JapanBlog - ä¸å³¶è¡ãƒ»ãƒãƒƒãƒˆæ™‚ä»£ã®ãƒ‡ã‚¸ã‚¿ãƒ«ãƒ©ã‚¤ãƒ•ã‚¹ã‚¿ã‚¤ãƒ«ï¼šGoogle Office ãŒ Microsoft ã«å‹ã¦ã‚‹ç†ç”±
GoogleãŒWritelyã®è²·åŽã«ç¶šã„ã¦ã€è¡¨è¨ˆç®—ã‚¢ãƒ—ãƒªã‚’ã‚¦ã‚§ãƒ–ãƒ»ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æä¾›ã™ã‚‹äºˆå®šãŒã‚ã‚‹ã“ã¨ãŒè©±é¡Œã«ãªã£ã¦ã„ã‚‹ã€‚å½“ç„¶ã¨ã„ãˆã°å½“ç„¶ã®æµã‚Œã§ã‚ã‚‹ã€‚ å°‘ã—å‰ã«ã€ç§ã®ã‚‚ã†ä¸€ã¤ã®ãƒ–ãƒã‚°ã§ã€ã€ŒStartOffice/OpenOfficeãŒMicrosoftã«å‹ã¦ãªã„ç†ç”±ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ãŸãŒã€OpenOfficeã®æˆ¦ç•¥ã¨Googleã®æˆ¦ç•¥ã®æ ¹æœ¬çš„ãªé•ã„ã¯ã€Microsoftã®å¾Œã‚’è¿½ã„ã‹ã‘ã‚‹ã®ã‹ã€MicrosoftãŒã©ã†ã—ã¦ã‚‚è¡Œã‘ãªã„äº‹æƒ…ã®ã‚ã‚‹ã»ã†ã«çªã£èµ°ã‚‹ã®ã‹ã€ã®é•ã„ã§ã‚ã‚‹ã€‚ ãã®æ„å‘³ã§è¨€ãˆã°ã€OpenOfficeã«ã—ã‚Lindowsã«ã—ã‚ã€Microsoftã®æä¾›ã—ã¦ã„ã‚‹Officeã¨Windowsã‚’å®‰ãæä¾›ã™ã‚‹ã€ã¨ã„ã†åˆ©ç‚¹ã ã‘ãŒç›®ç«‹ã¡ã€çµå±€ã®æ‰€ã€Œå®‰ã‹ã‚ã†æ‚ªã‹ã‚ã†ã€ã¨ã„ã†è©•ä¾¡ã‚’ä¸‹ã•ã‚Œã¦ã—ã¾ã†ã€‚ ãã‚Œã«å¯¾ã—ã¦ã€Googleã¯ã€MicrosoftãŒä½œã‚ŠãŸãã¦ã‚‚ä½œã‚Œãªã„ã€ã€Œã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã®
teddy-g 2006/06/12
Excelå¥½ããªã‚“ã ã‘ã©ãªã‚ã€‚

google

microsoft

excel
ãƒªãƒ³ã‚¯
ç‘æ³¢æŠ€å¤§ãƒ»æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ å¦ç§‘
2024å¹´8æœˆ24æ—¥ åœŸæ›œæ—¥ã€æ˜¥æ—¥ã‚ãƒ£ãƒ³ãƒ‘ã‚¹ã«ã¦å¤ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚ãƒ£ãƒ³ãƒ‘ã‚¹ãŒé–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚ åˆå‰ä¸ã¯å¦éƒ¨ã®èª¬æ˜ŽãŠã‚ˆã³ã‚°ãƒ«ãƒ¼ãƒ—ã«åˆ†ã‹ã‚Œã¦ã®æ–½è¨è¦‹å¦ã€åˆå¾Œã¯ä½“é¨“æŽˆæ¥ã‚„å€‹åˆ¥ç›¸è«‡ãªã©ã‚’è¡Œã„ã¾ã—ãŸã€‚å‚åŠ ã—ã¦é ‚ã„ãŸçš†æ§˜ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ è©³ç´°ãƒšãƒ¼ã‚¸(Read More)ã§ã€å¦ç§‘ã®ä½“é¨“æŽˆæ¥ã§AIã«ã‚ˆã‚Šç”Ÿæˆã•ã‚ŒãŸçµæžœã‚’ã”è¦§ã„ãŸã ã‘ã¾ã™ã€‚ 8æœˆ4æ—¥ æ—¥æ›œæ—¥ã‹ã‚‰13æ—¥ ç«æ›œæ—¥ã«ã‹ã‘ã¦ã€ã‚¤ã‚¿ãƒªã‚¢å…±å’Œå›½ã®ãƒãƒ¼ãƒžã«ã¦é–‹å‚¬ã•ã‚ŒãŸæ¬§å·žã®è¦–è¦šéšœå®³è€…ã‚µãƒžãƒ¼ã‚ãƒ£ãƒ³ãƒ—ICCï¼ˆInternational Camp on Communications and Computersï¼‰ã«å¦ç”Ÿ5åã¨æ•™å“¡2åãŒå‚åŠ ã—ã¾ã—ãŸã€‚å‚åŠ ã—ãŸå¦ç”Ÿã¯æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ å¦ç§‘2å¹´ã®å®‰å½¦æ„›èŠ±ã•ã‚“ã€å²©æ¸•å¥å¤ªã•ã‚“ã€å·æœ¬ä¸€è¼ã•ã‚“ã€æ²³é‡ŽçŽ²é‚£ã•ã‚“ã€åŒ4å¹´ã®å‰å·è¼ªã•ã‚“ã§ã™ã€‚
teddy-g 2006/02/05
VBAã‹ã‚‰TextToSpeechã‚’åˆ©ç”¨ã€‚æ—¥æœ¬èªžã‚‚ã€‚

microsoft

excel

vba
ãƒªãƒ³ã‚¯
1