[B! é–¢æ•°] lovegaudiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lovegaudi id:lovegaudi

é–¢æ•°ã«é–¢ã™ã‚‹lovegaudiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

é‡è¤‡ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹ã«ã¯ - COUNTIF, IFã®è§£èª¬ - ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
COUNTIF, IFã®è§£èª¬ é‡è¤‡ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³• COUNTIFé–¢æ•°ã¨IFé–¢æ•°ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€åç°¿ã‚„å•†å“ãƒªã‚¹ãƒˆãªã©ã‹ã‚‰é‡è¤‡ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ é‡è¤‡ãƒ‡ãƒ¼ã‚¿ã®æŠ½å‡ºæ–¹æ³•ã¯ã€ã¾ãšã€COUNTIFé–¢æ•°ã‚’ç”¨ã„ã¦ãã‚Œãžã‚Œã®é …ç›®ã®ãƒ‡ãƒ¼ã‚¿ã®æ•°ã‚’æ±‚ã‚ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã®æ•°ãŒ1ã¤ãªã‚‰ã°é‡è¤‡ãƒ‡ãƒ¼ã‚¿ãŒãªã‹ã£ãŸã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ã®æ•°ãŒ2ã¤ä»¥ä¸Šãªã‚‰ã°é‡è¤‡ãƒ‡ãƒ¼ã‚¿ãŒã‚ã£ãŸã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ æ¬¡ã«ã€IFé–¢æ•°ã‚’ç”¨ã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ã®æ•°ãŒ2ã¤ä»¥ä¸Šãªã‚‰ã°ãƒ‡ãƒ¼ã‚¿ã®æ¨ªã®ã‚»ãƒ«ã«ã€Œé‡è¤‡ã€ã¨è¡¨ç¤ºã™ã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ =COUNTIF(ç¯„å›²,èª¿ã¹ã‚‹ãƒ‡ãƒ¼ã‚¿) ã€Œç¯„å›²ã€ï½¥ï½¥ï½¥é‡è¤‡ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹ã‚»ãƒ«ã®ç¯„å›²ã‚’æŒ‡å®šã—ã¾ã™ã€‚ ã€Œèª¿ã¹ã‚‹ãƒ‡ãƒ¼ã‚¿ã€ï½¥ï½¥ï½¥èª¿ã¹ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’æŒ‡å®šã—ã¾ã™ã€‚ ã€Œ=COUNTIF(ç¯„å›²,èª¿ã¹ã‚‹ãƒ‡ãƒ¼ã‚¿)ã€ã§ãƒ‡ãƒ¼ã‚¿ã®æ•°ã‚’æ±‚ã‚ã¾ã™ã€‚ IFé–¢æ•°ã‚’ç”¨ã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ã®æ•°ãŒ2ã¤ä»¥ä¸Šãªã‚‰ã°ã€Œé‡è¤‡ã€ã¨è¡¨ç¤ºã—ã¦1ã¤ãªã‚‰ã°ä½•ã‚‚è¡¨ç¤ºã—ãªã„ã‚ˆã†ã«ã—ã¾
lovegaudi 2014/01/08
ãƒ‡ãƒ¼ã‚¿

é–¢æ•°

ã‚¨ã‚¯ã‚»ãƒ«

ãƒªã‚¹ãƒˆ

ä½æ‰€
ãƒªãƒ³ã‚¯
INDIRECTãƒ»CHOOSEé–¢æ•°
INDIRECTé–¢æ•°ã¯ã€å‚ç…§æ–‡å—åˆ—ã«ã‚ˆã£ã¦æŒ‡å®šã—ã¦ã„ã‚‹å‚ç…§ã‚’è¿”ã™é–¢æ•°ã§ã™ã€‚ ã‚»ãƒ«ã«å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã‚»ãƒ«ç•ªåœ°ãªã©ã®æ–‡å—åˆ—ã‚’ä»‹ã—ã€é–“æŽ¥çš„ã«ã‚»ãƒ«ã®å‚ç…§å…ˆã®å€¤ã‚’æ±‚ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä½¿ã„æ–¹ã‚’å·¥å¤«ã™ã‚Œã°ã€ã•ã¾ã–ã¾ãªå¿œç”¨ãŒã§ãã‚‹é–¢æ•°ã§ã™ã€‚ æ›¸å¼ã§è¡¨ã™ã¨ã€ INDIRECT(å‚ç…§æ–‡å—åˆ—ï¼Œå‚ç…§å½¢å¼)ã¨ãªã‚Šã¾ã™ã€‚å¼•æ•°ã®å‚ç…§æ–‡å—åˆ—ã¯ã€å‚ç…§ã—ãŸã„ã‚»ãƒ«ãŒæ–‡å—åˆ—ã§å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã‚»ãƒ«ã‚’æŒ‡å®šã—ã¾ã™ã€‚ ã‚»ãƒ«ã‚„ã‚»ãƒ«ç¯„å›²ã«åå‰ã‚’ä»˜ã‘ã€ãã®åå‰ãŒå…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã‚»ãƒ«ã‚‚å«ã¿ã¾ã™ã€‚ å‚ç…§å½¢å¼ã¯ã€A1å½¢å¼ã‹R1C1å½¢å¼ã‹ã‚’ç†è«–å€¤ã§æŒ‡å®šã—ã¾ã™ã€‚A1å½¢å¼ã®å ´åˆã¯ã€TRUEã‚‚ã—ãã¯æŒ‡å®šã‚’çœç•¥ã—ã¾ã™ã€‚R1C1å½¢å¼ã®å ´åˆã¯ã€FALSEã§æŒ‡å®šã—ã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«ã¯ã€äºŒã¤ã®å‚ç…§å½¢å¼ãŒã‚ã‚Šã¾ã™ã€‚A1å½¢å¼ã¨ã¯ã€é€šå¸¸ã®å‚ç…§å½¢å¼ã®ã“ã¨ã§ã€åˆ—ç•ªå·ãŒã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆã§è¡¨ã•ã‚Œã€è¡Œç•ªå·ãŒæ•°å—ã§è¡¨ã•ã‚Œã‚‹å½¢å¼ã®ã“ã¨ã§ã™ã€‚ã“ã‚Œã«å¯¾ã—ã€R1C1å½¢å¼ã¯ã€åˆ—ç•ªå·ã€è¡Œ
lovegaudi 2013/11/08
ãƒ‡ãƒ¼ã‚¿

ãƒªã‚¹ãƒˆ

ã‚¨ã‚¯ã‚»ãƒ«

Excel

é–¢æ•°
ãƒªãƒ³ã‚¯
https://remotestance.com/blog/1522/
lovegaudi 2012/08/10
é–¢æ•°

ã‚µãƒ³ãƒ—ãƒ«

è¨å®š

ãƒ•ã‚©ãƒ¼ãƒ

jquery

ãƒ—ãƒ©ã‚°ã‚¤ãƒ³

popup
ãƒªãƒ³ã‚¯
ä¾‹å¤–è¨è¨ˆã«ãŠã‘ã‚‹å¤§ç½ª - å¥‘ç´„
1. ä¾‹å¤–è¨è¨ˆ ã«ãŠã‘ã‚‹å¤§ç½ª å’Œç”° å“äºº (a.k.a id:t-wada or @t_wada) Jun 27, 2012 @ java-ja 12å¹´6æœˆ28æ—¥æœ¨æ›œæ—¥ 2. è‡ªå·±ç´¹ä»‹ åå‰: å’Œç”° å“äºº (ã‚ã ãŸãã¨) ãƒ–ãƒã‚°: http://d.hatena.ne.jp/t-wada ãƒ¡ãƒ¼ãƒ«: takuto.wada@gmail.com Twitter: http://twitter.com/t_wada ã‚¿ãƒ¯ãƒ¼ã‚ºï½¥ã‚¯ã‚¨ã‚¹ãƒˆæ ªå¼ä¼šç¤¾ å–ç· å½¹ç¤¾é•· 12å¹´6æœˆ28æ—¥æœ¨æ›œæ—¥
lovegaudi 2012/06/29
é–¢æ•°

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

movie

Gmail

presentation

id

Twitter

ãƒ¡ãƒ¼ãƒ«

ãƒ–ãƒã‚°

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
â– Excel2003-[é–¢æ•°]-PHONETICé–¢æ•°ã«ã¤ã„ã¦ - B1ã‚»ãƒ«ã«ã€Œ=PHONETIC(A1)ã€ã¨å…¥åŠ›A1ã‚»ãƒ«ã«ç›´æŽ¥ã€Œå±±ç”°å¤ªéƒŽã€... - Yahoo!çŸ¥æµè¢‹
â– Excel2003-[é–¢æ•°]-PHONETICé–¢æ•°ã«ã¤ã„ã¦ B1ã‚»ãƒ«ã«ã€Œ=PHONETIC(A1)ã€ã¨å…¥åŠ› A1ã‚»ãƒ«ã«ç›´æŽ¥ã€Œå±±ç”° å¤ªéƒŽã€ã¨å…¥åŠ›ã™ã‚Œã°ã€B1ã‚»ãƒ«ã¯ã€Œãƒ¤ãƒžãƒ€ ã‚¿ãƒã‚¦ã€ã¨è¿”ã—ã¾ã™ã€‚ ã—ã‹ã—ã€ã»ã‹ã®ã‚½ãƒ•ãƒˆã‹ã‚‰æ–‡å—åˆ—ã‚’è²¼ã‚Šä»˜ã‘ã‚‹ã¨ã€ãµã‚ŠãŒãªå—æƒ…å ±ãŒãªã„ãŸã‚ã€ ãã®æ–‡å—äº‹æ…‹ã®è¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ å›žé¿ã™ã‚‹æ–¹æ³•ã¨ã—ã¦ã¯ã€ã‚³ãƒ”ãƒ¼ã—ãŸã‚»ãƒ«ã‚’é¸æŠžã—ãŸçŠ¶æ…‹ã§ [æ›¸å¼]-[ãµã‚ŠãŒãª]-[ç·¨é›†]ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚Œã°å†è¨ˆç®—ï¼Ÿã•ã‚Œ ãƒ•ãƒªã‚¬ãƒŠãŒåæ˜ ã•ã‚Œã‚‹ã®ã§ã™ãŒï½¥ï½¥ï½¥ ã“ã‚Œã§ã¯ã€1å›žã®æ“ä½œã§ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã®ã‚»ãƒ«ã—ã‹ä¿®æ£ã•ã‚Œã¾ã›ã‚“ã€‚ ä»–ã«å›žé¿ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ ã”å˜çŸ¥ã®æ–¹ã€ã”æ•™ç¤ºãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ [é–¢é€£è£œè¶³]ä¸Šè¨˜è³ªå•ã¯ã€ä¸‹è¨˜URLã¨è‹¥å¹²é–¢é€£ãŒã‚ã‚Šã¾ã™ã€‚ http://detail.chiebukuro.yahoo.co.jp/qa/question_detail/q1413731194
lovegaudi 2012/06/21
ãƒ‡ãƒ¼ã‚¿ã‚’è²¼ã‚Šã¤ã‘ãŸã®ã§ã€æ¼¢å—ãŒã²ã‚‰ãŒãªåŒ–ã§ããªã„æ™‚ã«ä½¿ã†æ–¹æ³•ã€‚

Excel

é–¢æ•°
ãƒªãƒ³ã‚¯
ç¬¬ä¸‰å›žã€€ã€ŒIFé–¢æ•°ã€ã®ç©ºç™½å‡¦ç†ã‚’çŸ¥ã‚‰ãªã„ã¨Excelã®ä¾¿åˆ©ã•åŠæ¸›ï¼ï¼Ÿ
ç„¡é§„ã‚’çœã‘ã‚‹ã¯ãšã®Excelã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚‚ã€ãã®æ´»ã‹ã—æ–¹ã‚’çŸ¥ã‚‰ãªã‘ã‚Œã°ã€é€†ã«æ‰‹é–“ã¨ãƒªã‚¹ã‚¯ãŒå¢—ãˆã¦ã—ã¾ã†ã¨ã„ã†æ€–ã„ãŠè©±ã§ã™ã€‚ è«‹æ±‚æ›¸ã‚„ç´å“æ›¸ã‚’ä½œæˆã™ã‚‹ã¨ãã€ã‚ã‚‰ã‹ã˜ã‚é‡‘é¡ã®æ¬„ã«ã€Œï¼å˜ä¾¡Ã—æ•°é‡ã€ã¨ã„ã†æ•°å¼ã‚’å…¥åŠ›ã—ã¦ãŠãã®ãŒä¸€èˆ¬çš„ã§ã™ã€‚ ã—ã‹ã—ã€ãã®å¼ã ã‘ã‚’å…¥åŠ›ã—ã¦ã„ã‚‹ã¨ã€å˜ä¾¡ã‚„æ•°é‡ã‚’å…¥åŠ›ã—ã¦ã„ãªã„åˆ—ã«ã€Œã‚¨ãƒ©ãƒ¼å€¤ã€ãŒè¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ ã“ã†ãªã‚‹ã¨ã€ã„ã¡ã„ã¡ã‚¨ãƒ©ãƒ¼å€¤ã‚’æ¶ˆã™ä½œæ¥ã‚’ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã§ã€ç„¡é§„ãªä½œæ¥ãŒå¢—ãˆã¦ã—ã¾ã„ã¾ã™ã€‚ Excelé–¢æ•°ã®å¤§å¾¡æ‰€ã€ŒIFé–¢æ•°ã€ã‚’ä½¿ã£ãŸç©ºç™½å‡¦ç†ã‚’è¡Œãªã£ã¦ãŠã‘ã°ã€ã“ã‚“ãªå•é¡Œã¯ç°¡å˜ã«å›žé¿ã§ãã¾ã™ã€‚ ã€ŒIFé–¢æ•°ã€ã‚’ä½¿ã£ãŸç©ºç™½å‡¦ç†ã‚’ã—ã¦ã„ãªã„ã¨ãƒ»ãƒ»ãƒ» ä¸‹ã®ä¾‹ã®ã‚ˆã†ã«ã€ã€Œé‡‘é¡ã€ã®ã‚»ãƒ«ã«ã€Œå˜ä¾¡Ã—æ•°é‡ã€ã®çµæžœã‚’è¡¨ç¤ºã•ã›ã‚‹ã‚ˆã†ã«æ•°å¼ã‚’å…¥åŠ›ã—ãŸã ã‘ã®ã‚»ãƒ«ã‚’ãƒ•ã‚£ãƒ«ã‚³ãƒ”ãƒ¼ã—ã¦ãŠã„ãŸçŠ¶æ…‹ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãŒå…¥åŠ›ã•ã‚Œã¦ã„ãªã„è¡Œã®ã€Œé‡‘é¡ã€ã®ã‚»ãƒ«ã«ã‚¨ãƒ©ãƒ¼å€¤ãŒå‡ºã¦ã—ã¾ã„ã¾ã™ã€‚ ã—ã‹ã‚‚ã€å³å›³ã®ã‚ˆ
lovegaudi 2011/07/05
web

ãƒ‡ãƒ¼ã‚¿

excel

ã‚ã¨ã§èªã‚€

*ã‚ã¨ã§èªã‚€

ä¾¿åˆ©

ãŠå½¹ç«‹ã¡

é–¢æ•°

PC

Office
ãƒªãƒ³ã‚¯
1