[B! excel] satohiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

satohi id:satohi

excelã«é–¢ã™ã‚‹satohiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

æŽ¡ç”¨è©¦é¨“å•é¡ŒãŒæµå‡º?!ã‚³ãƒ¬ãŒå®Ÿéš›ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€ŒExcelã‚¹ã‚ãƒ«ã®ãƒ†ã‚¹ãƒˆã€ã - ã‚ãƒ£ãƒªã‚¿ã‚¹LINQãƒžã‚¬ã‚¸ãƒ³
ãƒ›ãƒ¼ãƒ > ãƒ–ãƒã‚° > ãƒ¬ãƒãƒ¼ãƒˆ > æŽ¡ç”¨è©¦é¨“å•é¡ŒãŒæµå‡º?!ã‚³ãƒ¬ãŒå®Ÿéš›ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€ŒExcelã‚¹ã‚ãƒ«ã®ãƒ†ã‚¹ãƒˆã€ã æŽ¡ç”¨è©¦é¨“å•é¡ŒãŒæµå‡º?!ã‚³ãƒ¬ãŒå®Ÿéš›ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€ŒExcelã‚¹ã‚ãƒ«ã®ãƒ†ã‚¹ãƒˆã€ã ã€ŒExcelã‚¹ã‚ãƒ«ã€ã¯äº‹å‹™è·ã®æ±‚äººã§æ±‚ã‚ã‚‰ã‚Œã‚‹ã“ã¨ãŒå¤šã„æ¡ä»¶ã§ã™ã€‚ã§ã‚‚å…·ä½“çš„ã«ã©ã®ç¨‹åº¦ã®ã‚¹ã‚ãƒ«ãŒå¿…è¦ãªã®ã‹ã€è‡ªåˆ†ã¯ã‚¹ã‚ãƒ«ãŒã‚ã‚‹ã¨è¨€ãˆã‚‹ã®ã‹ã€ç–‘å•ã«æ€ã†ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä»Šå›žã¯ç‰¹åˆ¥ã«ã€å®Ÿéš›ã«ä¼æ¥ãŒæŽ¡ç”¨è©¦é¨“ã§ä½¿ã£ã¦ã„ã‚‹ãƒ†ã‚¹ãƒˆã‚’å¤§å…¬é–‹ï¼ã“ã“ã•ãˆæŠ¼ã•ãˆã¦ãŠã‘ã°ã€ã‚ãªãŸã‚‚å ‚ã€…ã¨ã€ŒExcelä½¿ãˆã¾ã™ã€ã¨è¨€ãˆã¾ã™ã‚ˆï¼ ï¼ˆ1ï¼‰åŸºæœ¬ã®é–¢æ•°ã§ã€Œåˆè¨ˆã€ã€Œæ§‹æˆæ¯”ã€ã€Œæœ€å¤§å€¤ã€ã€Œæœ€å°å€¤ã€ã‚’æ±‚ã‚ã‚‹ ã€å•é¡Œã€‘ ä»¥ä¸‹ã®åˆè¨ˆãƒ»æ§‹æˆæ¯”ï¼ˆå…¨ä½“ã®ä½•ï¼…ã‹ï¼‰ãƒ»æœ€å¤§å€¤ãƒ»æœ€å°å€¤ã‚’ã‚‚ã£ã¨ã‚‚åŠ¹çŽ‡ã‚ˆãå›žç”ã—ã¦ãã ã•ã„ã€‚â€»é»„è‰²ã®æž å†…ã®ã¿ã‚’å¤‰æ›´ã—ã¦ãã ã•ã„ã€‚æž ã‚’è¿½åŠ ã™ã‚‹ã®ã¯NGã§ã™ã€‚ ã€å›žç”ã€‘ Aã¨Bã®åˆè¨ˆã‚„æ§‹æˆæ¯”ã‚’æ±‚ã‚ã¾ã™ã€‚ãã®å¾Œã€ãã‚Œãžã‚Œã®æœ€å¤§å€¤ãƒ»æœ€å°
satohi 2018/04/13
EXCEL
ãƒªãƒ³ã‚¯
Excel(ã‚¨ã‚¯ã‚»ãƒ«)æ—¥æœ¬ä¸€ã‚„ã•ã—ã„ãƒžã‚¯ãƒè¬›åº§
ã‚¯ãƒ©ã‚¹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã£ãŸå®Ÿç”¨ãƒžã‚¯ãƒ ã‚¯ãƒ©ã‚¹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ä½¿ã„æ–¹ãŒã‚ã‹ã‚Œã°ã¨ã¦ã‚‚ä¾¿åˆ©ãªä»•çµ„ã¿ã§ã™ã€‚ ã‘ã‚Œã©ã‚‚ãªã‹ãªã‹ãã‚Œã‚’ä½¿ã£ã¦ã„ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã„ã¾ã›ã‚“ã€‚ ä½¿ã„é“ãŒåˆ†ã‹ã‚‰ãªã„ã¨ã‹ã€ä½¿ã‹ãªãã¦ã‚‚ä½•ã¨ã‹ãªã‚‹ã¨ã„ã†ã®ãŒç†ç”±ã®ã²ã¨ã¤ã§ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯å®Ÿéš›ã«ä½¿ã†äº‹ã®ã§ãã‚‹ã‚³ãƒ¼ãƒ‰ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ æ£è¦è¡¨ç¾ã¯ã©ã†ã„ã†ã‚‚ã®ã§ã™ã‹ï¼Ÿ æ£è¦è¡¨ç¾ã¯ã€ç‰¹å®šã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã«ä¸€è‡´ã™ã‚‹æ–‡å—åˆ—ã‚’è¦‹ã¤ã‘ã‚‹ãŸã‚ã®ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é›»è©±ç•ªå·ã®ãƒªã‚¹ãƒˆã®ç‰¹å®šã®ç•ªå·ã‚’æŠ½å‡ºã—ãŸã‚Šã€è¨˜å…¥ãƒŸã‚¹ã®ã‚ã‚‹ç•ªå·ã‚’æŽ¢ã—ãŸã‚Šã™ã‚‹ã®ã«å½¹ã«ç«‹ã¤ä¾‹ã‚’ã¿ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã‚¯ãƒ©ã‚¹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®åŸºç¤Žã¨ä½¿ã„æ–¹1 ã‚ã‚‹ç¨‹åº¦ VBA ã®çµŒé¨“ã‚’ç©ã‚“ã§ãã‚‹ã¨ã‚¯ãƒ©ã‚¹ã€ã‚¯ãƒ©ã‚¹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚ã‚‹ã„ã¯ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã€ãªã©ã¨ã„ã£ãŸè¨€è‘‰ãŒç›®ã«ã¤ãã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—ã“ã‚Œã‚‰ã«ã¤ã„ã¦è©³ã—ãæ›¸ã‹ã‚Œã¦ã„ã‚‹å‚è€ƒæ›¸ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãªãœã§ã—ã‚‡ã†ã€‚ãã‚Œã¯ã‚¯ãƒ©ã‚¹ã‚’ä½¿ã‚ãªãã¦ã‚‚ã€ãã“ãã“VBAãŒä½¿ãˆã‚‹ã‹ã‚‰ã§ã™ã€‚
satohi 2015/08/14
excel

ãƒžã‚¯ãƒ

ä¾¿åˆ©
ãƒªãƒ³ã‚¯
ã€ŒExcelã€ã‚’ãƒ‘ãƒ¯ãƒ¼ã‚¢ãƒƒãƒ—ã•ã›ã‚‹ã‚¢ãƒ‰ã‚¤ãƒ³ã€ŒRelaxToolsã€ã€æ–‡æ›¸ä½œæˆæ”¯æ´æ©Ÿèƒ½ã‚’å¼·åŒ–
satohi 2014/06/24
excel

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
satohi 2012/07/20
excel
ãƒªãƒ³ã‚¯
ä»•äº‹ã§Excelä½¿ã†ãªã‚‰å¿…ãšèªã‚“ã§ãŠããŸã„è¨˜äº‹ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
satohi 2012/06/07
excel
ãƒªãƒ³ã‚¯
ç¬¬ä¸‰å›žã€€ã€ŒIFé–¢æ•°ã€ã®ç©ºç™½å‡¦ç†ã‚’çŸ¥ã‚‰ãªã„ã¨Excelã®ä¾¿åˆ©ã•åŠæ¸›ï¼ï¼Ÿ
ç„¡é§„ã‚’çœã‘ã‚‹ã¯ãšã®Excelã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚‚ã€ãã®æ´»ã‹ã—æ–¹ã‚’çŸ¥ã‚‰ãªã‘ã‚Œã°ã€é€†ã«æ‰‹é–“ã¨ãƒªã‚¹ã‚¯ãŒå¢—ãˆã¦ã—ã¾ã†ã¨ã„ã†æ€–ã„ãŠè©±ã§ã™ã€‚ è«‹æ±‚æ›¸ã‚„ç´å“æ›¸ã‚’ä½œæˆã™ã‚‹ã¨ãã€ã‚ã‚‰ã‹ã˜ã‚é‡‘é¡ã®æ¬„ã«ã€Œï¼å˜ä¾¡Ã—æ•°é‡ã€ã¨ã„ã†æ•°å¼ã‚’å…¥åŠ›ã—ã¦ãŠãã®ãŒä¸€èˆ¬çš„ã§ã™ã€‚ ã—ã‹ã—ã€ãã®å¼ã ã‘ã‚’å…¥åŠ›ã—ã¦ã„ã‚‹ã¨ã€å˜ä¾¡ã‚„æ•°é‡ã‚’å…¥åŠ›ã—ã¦ã„ãªã„åˆ—ã«ã€Œã‚¨ãƒ©ãƒ¼å€¤ã€ãŒè¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ ã“ã†ãªã‚‹ã¨ã€ã„ã¡ã„ã¡ã‚¨ãƒ©ãƒ¼å€¤ã‚’æ¶ˆã™ä½œæ¥ã‚’ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã§ã€ç„¡é§„ãªä½œæ¥ãŒå¢—ãˆã¦ã—ã¾ã„ã¾ã™ã€‚ Excelé–¢æ•°ã®å¤§å¾¡æ‰€ã€ŒIFé–¢æ•°ã€ã‚’ä½¿ã£ãŸç©ºç™½å‡¦ç†ã‚’è¡Œãªã£ã¦ãŠã‘ã°ã€ã“ã‚“ãªå•é¡Œã¯ç°¡å˜ã«å›žé¿ã§ãã¾ã™ã€‚ ã€ŒIFé–¢æ•°ã€ã‚’ä½¿ã£ãŸç©ºç™½å‡¦ç†ã‚’ã—ã¦ã„ãªã„ã¨ãƒ»ãƒ»ãƒ» ä¸‹ã®ä¾‹ã®ã‚ˆã†ã«ã€ã€Œé‡‘é¡ã€ã®ã‚»ãƒ«ã«ã€Œå˜ä¾¡Ã—æ•°é‡ã€ã®çµæžœã‚’è¡¨ç¤ºã•ã›ã‚‹ã‚ˆã†ã«æ•°å¼ã‚’å…¥åŠ›ã—ãŸã ã‘ã®ã‚»ãƒ«ã‚’ãƒ•ã‚£ãƒ«ã‚³ãƒ”ãƒ¼ã—ã¦ãŠã„ãŸçŠ¶æ…‹ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãŒå…¥åŠ›ã•ã‚Œã¦ã„ãªã„è¡Œã®ã€Œé‡‘é¡ã€ã®ã‚»ãƒ«ã«ã‚¨ãƒ©ãƒ¼å€¤ãŒå‡ºã¦ã—ã¾ã„ã¾ã™ã€‚ ã—ã‹ã‚‚ã€å³å›³ã®ã‚ˆ
satohi 2011/07/06
excel
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ç°¡å˜ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | ã‚³ãƒªã‚¹
Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€æ¡ä»¶ä»˜ãæ›¸å¼ã‚’åˆ©ç”¨ã—ã¦ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Learn Cool Microsoft Excel Conditional Formatting Tricks ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ æ¡ä»¶ä»˜ãæ›¸å¼ã‚’ä½¿ç”¨ã—ãŸã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆ ã‚»ãƒ«å†…ã«é…ç½®ã™ã‚‹ã‚°ãƒ©ãƒ• ãƒŸã‚¹ã‚„ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ‡ãƒ¼ã‚¿æ¬ è½ãªã©ã®ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤º ç›´æ„Ÿçš„ã«æŠŠæ¡ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ†ãƒ¼ãƒ–ãƒ« [ad#ad-2] ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ã€Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ä¸€ç•ªä¸‹ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹ãŸã‚ã«ã€æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’äº¤äº’ã«ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤ºã«ã—ã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã«ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã‚’é¸æŠžã—ã¾ã™ã€‚ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚ˆã‚Šã€[æ›¸å¼] - [æ¡ä»¶ä»˜ãæ›¸å¼] ã‚’é¸æŠžã€‚ ã€Œæ•°å¼ã€ã‚’é¸æŠžã—ã€ã€Œ=MOD(ROW(),2)=0ã€ã‚’å…¥åŠ›ã—
satohi 2008/03/17
excel

ä¾¿åˆ©
ãƒªãƒ³ã‚¯
1