
ååã¯ExcelïŒãšã¯ã»ã«ïŒã®æåæ°ãã«ãŠã³ãããæ¹æ³ã玹ä»ããŠããŸããã
Excelãšã¯ã»ã«ã§æåæ°ãã«ãŠã³ããããïŒãšããã¯ãããŸãããïŒç°¡åãªæ¹æ³ããããŸããæ¬èšäºã§ã¯ãLENé¢æ°ã»LENBé¢æ°ã䜿ã£ãŠãåãã»ã«å ã®æåæ°ãã«ãŠã³ãããæ¹æ³ããšãå¥ã®è€æ°ã»ã«ã®æåæ°ãã«ãŠã³ãïŒæååãã«ãŠã³ãïŒããæ¹æ³ãã玹ä»ããŠããŸãããšã£ãŠãç°¡åã§åœ¹ç«ã€ã®ã§ãã²èŠããŠãã£ãŠãã ãããã
ã»ã«å ã®æåæ°ãæ°ããããã®LENé¢æ°ã»LENBé¢æ°ã®äœ¿ãæ¹ããç¥ãããæ¹ã¯ãŸãäžèšã®èšäºãããã§ãã¯ãã ãããïŒ
ãããŠä»æ¥ã¯ããã®å¿çšç·šãšããŠãè€æ°ã»ã«ã®æåæ°ãã«ãŠã³ãããæ¹æ³ãã玹ä»ããŠãããŸããã
ExcelïŒãšã¯ã»ã«ïŒã§è€æ°ã»ã«ã®æåæ°ãã«ãŠã³ããã
è€æ°ã»ã«ã®æåæ°ãæ°ããã«ã¯SUMé¢æ°ã䜿ã
軜ãããããã§ãããã»ã«å ã®æåæ°ãã«ãŠã³ãããã«ã¯LENé¢æ°ãŸãã¯LENBé¢æ°ã䜿ããŸãã
LENé¢æ°ãšã¯
ã»ã«å
ã®æååã®æåæ°ãã«ãŠã³ãããé¢æ°
å
šè§ãåè§ã1æåãšããŠæ°ãã
âå
¬åŒïŒ=LEN(æåå)
â»æååã¯ã»ã«çªå·ã§ãOK
LENBé¢æ°ãšã¯
LENé¢æ°ãšåãããã«ã
ã»ã«å
ã®æååã®æåæ°ãã«ãŠã³ãããé¢æ°
å
šè§ã¯2æåãåè§ã¯1æåãšããŠæ°ãã
âå
¬åŒïŒ=LENB(æåå)
â»æååã¯ã»ã«çªå·ã§ãOK
ãã®ããã«äžã€ã®ã»ã«å ã®æåæ°ãã«ãŠã³ãããã«ã¯ãLENé¢æ°ããLENBé¢æ°ããåç¬ã§äœ¿ãã ãã§OKã§ãã
ããã«ïŒ
ã»ã«ããŸããã§è€æ°ã»ã«ã®æåæ°ãã«ãŠã³ããããå Žåã«ã¯ããLENé¢æ°ããšãSUMé¢æ°ããçµã¿åãããããšã§ç°¡åã«ç®åºããããšãã§ããŸãã
LENé¢æ°ã§åºããè€æ°ã»ã«ã®æåæ°ãSUMé¢æ°ã§åç®ããããšããã€ã¡ãŒãžã§ãã
ãŸãæ®éã®ããæ¹ã ãšãäœæ¥çã«ããã ãé¢åã§ãããšããã®ãèŠãŠããã ãããšæããŸãïŒ
éåžžã®ããæ¹ã¯4å·¥çšã«ãªã
äŸïŒã»ã«B4ãB5ãB6ã®æåæ°ã®åèšãåºããšãã
ⶠãŸãã»ã«B4ïœB6ã®æåæ°ãããããã®LENé¢æ°ã§ç®åºããŸã
â· ããããã®æåæ°ãç®åºããã»ã«C4,C5,C6ãSUMé¢æ°ã«ãã£ãŠåç®ããŸã
ãã®ããã«ãé¢æ°ãå ¥åããäœæ¥ã4åãçºçããŠå°ãé¢åã§ãããã»ã»ã»ã
ä»ãã玹ä»ããããæ¹ã ãšãåãããŒã¿ãç®åºããã®ã«ã1åã®é¢æ°å ¥åäœæ¥ã§æåæ°ã«ãŠã³ãããããšãã§ããŸãã
SUMé¢æ°ã»LENé¢æ°ãçµã¿åãããæ¹æ³
äŸïŒã»ã«B4ãB5ãB6ã®æåæ°ã®åèšãåºããã
ⶠã»ã«D4ã«é¢æ°ãå ¥ããŠãããŸã
LENé¢æ°ãSUMé¢æ°ã®äžã«å«ããããšã§1ã€ã®é¢æ°ã§ç®åºã§ããããã«ããŸã
=SUM(LEN(B4),LEN(B5),LEN(B6))
ããããããæå解éãããš
=SUM( B4ã®æåæ°, B5ã®æåæ° , B6ã®æåæ° )
ãšããåŒã«ãªã£ãŠããŸã
â· 3ã€ã®ã»ã«ã®åèšæåæ°ãç®åºãããŸããã
éåžžã®æé ã§åºããå€ãšãã¡ããšåãã«ãªã£ãŠãããšã確èªã§ããããšæããŸãã
1床ã®é¢æ°å ¥åã§æžãã®ã§äœæ¥çã«ã楜ã§ããã䜿ãã»ã«ã1ã€ã§æžãã®ã§èŠãç®ãã¹ããŒãã§ãããïŒ
çªå€ç·šïŒç¹å®ã®æååãå«ãã»ã«ã®åæ°ãã«ãŠã³ãããããªãCOUNTIFé¢æ°ã䜿ã
çªå€ç·šãšããŠãããã²ãšã€å°ã¯ã¶ã玹ä»ããŸãã
ç¹å®ã®æååãå«ãã§ããã»ã«ãããã€ããã®ãïŒã«ãŠã³ãããã«ã¯ãCOUNTIFé¢æ°ã䜿ãã°ç°¡åã§ããã
äŸïŒã©ãã³ãšããæåãå«ãã»ã«ã®åæ°ãã«ãŠã³ããããšãã
ⶠCOUNTIFã®å
¬åŒã¯
ã=COUNTIF( ç¯å²,æ€çŽ¢æ¡ä»¶)ããªã®ã§
=COUNTIF(B4:B6,"ã©ãã³")
ãšããããšããã§ããã ãã®ãŸãŸã§ã¯ãã©ãã³ããšã ãå
¥åãããã»ã«ããäžèŽããªãã®ã§
ã¯ã€ã«ãã«ãŒãã*ãã䜿ã£ãŠ
=COUNTIF(B4:B6,"*ã©ãã³*")ããšèšè¿°ããŸã
è£è¶³ïŒã¯ã€ã«ãã«ãŒãã®äœ¿ãæ¹ã¯ãã¡ã
ExcelïŒãšã¯ã»ã«ïŒã§ãã䜿ããã¯ã€ã«ãã«ãŒããšã¯ãäžäœäœãç解ããŠããŸããïŒæ¬èšäºã§ã¯ãã¯ã€ã«ãã«ãŒããšã¯äœïŒãšããçåãšã¯ã€ã«ãã«ãŒãã®äœ¿ãæ¹ã培åºçã«è§£æ±ºããŠãããŸããã¯ã€ã«ãã«ãŒãã䜿ããšé¢æ°ãªã©ããŸããŸãªäœæ¥ããšã£ãŠã楜ã«ãªãã®ã§äœ¿ãæ¹ãèŠããŸãããã
â· ããã§ãã©ãã³ããå«ãã»ã«ã®åæ°ã衚瀺ãããŸãããïŒã3ããšè¡šç€ºãããŠããŸã
ããïŒ4åãããªãã®ïŒãšæã£ãæ¹ããããããããŸããã
ãã©ãã³ãã®æååã®æ°ãã¿ããšå šéšã§4ã€ãããŸãããä»åã«ãŠã³ãããã®ã¯ãã©ãã³ãšããæååãå«ã "ã»ã«" ã®åæ°ããªã®ã§
æ»ãå€ã¯ãïŒãã§æ£è§£ãšããããšã«ãªããŸãïŒ
ãã®èšäºãèŠãŠãã人ã«ãããã
ãããã§ãããïŒä»æ¥ã¯Excel(ãšã¯ã»ã«)ã§ã®è€æ°ã»ã«ã®æåæ°ãã«ãŠã³ãããæ¹æ³ã玹ä»ããŠããŸããã
äžæãé¢æ°ãçµã¿åããããšäœæ¥ãäœåã楜ã«ãªãããšããããŸãããã²è©ŠããŠã¿ãŠãã ãããïŒ