ç§ãã¡ã®äžã«ã¯ã家ã®äºç®ã®æºåãšåæããå§ãŸããä»äºãå匷ãªã©ã®èšç®ã§çµããå°éã®ããŒã¿ãåŠçããã¿ã¹ã¯ãåŠçããå¿ èŠãããå ŽåããããŸãã ããããããã«æãé©ããããŒã«ã¯ãMicrosoft ExcelïŒãŸãã¯ããããä»ã®é¡äŒŒç©ã§ãããããŸãäžè¬çã§ã¯ãããŸããïŒã§ãã
ãã®æ€çŽ¢ã§ââã¯ãHabréã®é¡äŒŒãããã¯ã«é¢ããèšäºã1ã€ã ãã§ããã ãGoogle SpreadSheetã®æ°åŒã«ããã¿ã«ããããã§ãã Excelã§äœæ¥ããããã®åºæ¬çãªäºé ã«ã€ããŠã®é©åãªèª¬æãæäŸããŸãïŒãã ããExcelèªäœã«ã€ããŠã¯100ïŒ ã§ã¯ãããŸããïŒã
ãããã£ãŠãã¯ãšãª/ã¿ã¹ã¯ã®ç¹å®ã®ããŒã«ãèç©ããŠãã¢ã€ãã¢ã¯ããããå žååããå¯èœãªãœãªã¥ãŒã·ã§ã³ãæäŸããããã«ãªããŸããïŒãã¹ãŠã§ã¯ãããŸããããããã«çµæãåŸãããŸãïŒã
ãŠãŒã¶ãŒãçŽé¢ããæãäžè¬çãªåé¡ã解決ããããšã§ãã
ãœãªã¥ãŒã·ã§ã³ã®èª¬æã¯æ¬¡ã®ããã«æ§æãããŠããŸã-æåã®ã¿ã¹ã¯ãå«ãã±ãŒã¹ãäžããããåŸã ã«è€éã«ãªã£ãŠããŸããåã¹ãããã«ã€ããŠèª¬æä»ãã®è©³çŽ°ãªãœãªã¥ãŒã·ã§ã³ãäžããããŸãã é¢æ°ã®ååã¯ãã·ã¢èªã§è¡šèšãããŸãããæåã®æ¬åŒ§å ã«ã¯è±èªã®å ã®ååãè¡šèšãããŸãïŒçµéšäžããŠãŒã¶ãŒã®å€§åã¯ãã·ã¢èªçãã€ã³ã¹ããŒã«ãããŠããããïŒã
Case_1ïŒããŒã«é¢æ°ãšäžèŽé¢æ°
ããã¬ãŒãã«å€ã®ã»ããããããç¹å®ã®æ¡ä»¶/æ¡ä»¶ã®ã»ãããæºãããããšãã«ç¹å®ã®å€ã衚瀺ãããå¿ èŠããããŸããïŒcïŒãŠãŒã¶ãŒ
éåžžãããŒã¿ã¯è¡šåœ¢åŒã§è¡šç€ºãããŸãã

æ¡ä»¶ïŒ
- ãæ°éãåã®å€ã5ãè¶ ããå Žå
- 次ã«ããçµæãåã«ã泚æã¯äžèŠã§ãããšããå€ã衚瀺ããå¿ èŠããããŸãã
è«çåŒãåç §ããåŒã§äºåã«èšè¿°ãããœãªã¥ãŒã·ã§ã³å ã®å€ãæäŸã§ããIFåŒïŒIFïŒã¯ãããã«åœ¹ç«ã¡ãŸãã ããã¹ãå€ã¯åŒçšç¬Šã䜿çšããŠèšè¿°ãããããšã«æ³šæããŠãã ããã
åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
IFïŒlog_expressionã[value_if_true]ã[value_if_false]ïŒ
- Expression_logã¯ãå€ãTRUEãŸãã¯FALSEã«ãªãåŒã§ãã
- True_if_valueã¯ãè«çåŒãtrueã®å Žåã«åºåãããå€ã§ã
- Value_if_falseã¯ãè«çåŒãfalseã®å Žåã«è¡šç€ºãããå€ã§ã
ãœãªã¥ãŒã·ã§ã³ã®åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
çµæãã»ã«D2ã«åºåããŸãã
= IFïŒC5> 5;ã泚æäžèŠããã泚æå¿ èŠãïŒ
åºåã¯çµæã§ãïŒ

ããšãã°ã2ã€ä»¥äžã®æ¡ä»¶ãæºãããããªã©ãæ¡ä»¶ãããè€éã«ãªãå ŽåããããŸãã
- ãæ°éãåã®å€ã5ãè¶ ãããã¿ã€ããåã®å€ããAãã®å Žå
- ãçµæãåã«å€ã1ãã衚瀺ããå¿ èŠããããŸãããã以å€ã®å Žåã¯ã0ãã衚瀺ããå¿ èŠããããŸãã
ãã®å ŽåããIFãåŒã®ã¿ã®äœ¿çšã«éå®ããããšã¯ã§ããªããªãããã®æ§æã«å¥ã®åŒãè¿œå ããå¿ èŠããããŸãã ãããŠãããã¯å¥ã®è«çåŒãANDãïŒANDïŒã«ãªããŸãã
åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
ãããŠïŒboolean1ã[boolean2]ã...ïŒ
- Logical_value 1-2ãªã© -èšç®ã®çµæãTRUEãŸãã¯FALSEã«ãªããã¹ãæ¡ä»¶
ãœãªã¥ãŒã·ã§ã³ã®æ§æã¯æ¬¡ã®ãšããã§ãã
çµæãã»ã«D2ã«åºåããŸãã
= IFïŒANDïŒC2> 5; B2 =â AâïŒ; 1; 0ïŒ
ãããã£ãŠã2ã€ã®åŒã®çµã¿åããã䜿çšããŠãåé¡ã®è§£æ±ºçãèŠã€ããçµæãååŸããŸãã

ã¿ã¹ã¯ãè€éã«ããŠã¿ãŸããã-æ°ããæ¡ä»¶ïŒ
- åãæ°éãã®å€ã10ã§ãåãã¿ã€ããã®å€ããAãã®å Žå
- ãŸãã¯ããæ°éãåã®å€ã5以äžã§ããã¿ã€ããã®å€ããBãã«çãã
- ãçµæãåã«å€ã1ãã衚瀺ããå¿ èŠããããŸãããã以å€ã®å Žåã¯ã0ãã衚瀺ããå¿ èŠããããŸãã
ãœãªã¥ãŒã·ã§ã³ã®æ§æã¯æ¬¡ã®ãšããã§ãã
çµæãã»ã«D2ã«åºåããŸãã
= IFïŒORïŒANDïŒC2 = 10; B2 =â AâïŒ; ANDïŒC2> = 5; B2 =â BâïŒïŒ; 1; 0ïŒ
ã¬ã³ãŒããããããããã«ãåŒãIFãã«ã¯1ã€ã®æ¡ä»¶ãORãïŒORïŒãšãããã«å«ãŸããåŒãANDãã䜿çšãã2ã€ã®æ¡ä»¶ãå«ãŸããŠããŸãã 2çªç®ã®ã¬ãã«ã®æ¡ä»¶ã®å°ãªããšã1ã€ãå€ãTRUEããæã€å Žåãçµæã1ãããçµæãåã«è¡šç€ºãããããã§ãªãå Žåã¯ã0ãã«ãªããŸãã
çµæïŒ

ããã§ã¯ã次ã®ç¶æ³ã«ç§»ããŸãããã
ãæ¡ä»¶ãåã®å€ã«å¿ããŠããçµæãåã«ç¹å®ã®æ¡ä»¶ã衚瀺ããå€ãšçµæã®å¯Ÿå¿ã以äžã«ç€ºããŸãã
æ¡ä»¶ïŒ
- 1 = A
- 2 = B
- 3 = B
- 4 = r
IFé¢æ°ã䜿çšããŠåé¡ã解決ããå Žåãæ§æã¯æ¬¡ã®ããã«ãªããŸãã
çµæãã»ã«B2ã«åºåããŸãã
= IFïŒA2 = 1; "A"; IFïŒA2 = 2; "B"; IFïŒA2 = 3; "C"; IFïŒA2 = 4; "G"; 0ïŒïŒïŒïŒ
çµæïŒ

ã芧ã®ãšããããã®ãããªåŒãæžãããšã¯éåžžã«äŸ¿å©ã§é¢åãªã ãã§ãªãããšã©ãŒãçºçããå Žåã«çµéšã®æµ ããŠãŒã¶ãŒãç·šéããã®ã«æéããããããšããããŸãã
ãã®ã¢ãããŒãã®æ¬ ç¹ã¯ãå°æ°ã®æ¡ä»¶ã«é©çšã§ããããšã§ãããã¹ãŠã®æ¡ä»¶ãæåã§å ¥åãã倧ããªãµã€ãºã«ãèšããŸãããå¿ èŠãããããã§ãã
代æ¿ãœãªã¥ãŒã·ã§ã³_1ïŒ
ãéžæãåŒã®äœ¿çš
é¢æ°ã®æ§æïŒ
SELECTïŒã€ã³ããã¯ã¹çªå·ãå€1ã[å€2]ã...ïŒ
- Index_numberã¯ãéžæããå€åŒæ°ã®çªå·ã§ãã ã€ã³ããã¯ã¹çªå·ã¯ã1ã254ã®æ°åãæ°åŒããŸãã¯1ã254ã®ç¯å²ã®æ°åãå«ãã»ã«ãžã®ãªã³ã¯ã§ããå¿ èŠããããŸãã
- Value1ãvalue2ã...-1ã254åã®åŒæ°å€ã®å€ããSELECTãé¢æ°ã¯ãã€ã³ããã¯ã¹çªå·ã䜿çšããŠãå®è¡ããå€ãŸãã¯ã¢ã¯ã·ã§ã³ãéžæããŸãã åŒæ°ã¯ãæ°å€ãã»ã«åç §ãç¹å®ã®ååãåŒãé¢æ°ããŸãã¯ããã¹ãã§ãã
ããã䜿çšããå Žåãæå®ãããå€ã«å¿ããŠæ¡ä»¶ã®çµæãããã«å ¥åããŸãã
æ¡ä»¶ïŒ
- 1 = A
- 2 = B
- 3 = B
- 4 = r
åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
=éžæïŒA2;â Aâ;â Bâ;â Câ;â DâïŒ
çµæã¯ãäžèšã®æ©èœã®ãIFããã§ãŒã³ã䜿çšãããœãªã¥ãŒã·ã§ã³ã«äŒŒãŠããŸãã
ãã®åŒãé©çšããå Žåã次ã®å¶éããããŸãã
ã»ã«ãA2ãïŒã€ã³ããã¯ã¹çªå·ïŒã«ã¯æ°åã®ã¿ã衚瀺ã§ããçµæã®å€ã¯1ã254ã®å€ã®æé ã§è¡šç€ºãããŸãã
ã€ãŸããã»ã«ãA2ãã§1ãã254ãŸã§ã®æ°åãæé ã§ç€ºãããŠããå Žåã«ã®ã¿æ©èœãæ©èœãããã®åŒã䜿çšãããšãã«ç¹å®ã®å¶éã課ããããŸãã
ã€ãŸã æ°å€5ãæå®ãããšãã«å€ãGãã衚瀺ããå Žå
- 1 = A
- 2 = B
- 3 = B
- 5 = r
æ°åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
çµæãã»ã«B2ã«åºåããŸãã
=éžæïŒA31;â Aâ;â Bâ;â Câ ;;â DâïŒ
ã芧ã®ãšãããåŒã®å€ã4ãã空ã®ãŸãŸã«ããŠãçµæãGããã·ãªã¢ã«çªå·ã5ãã«è»¢éããå¿ èŠããããŸãã
代æ¿ãœãªã¥ãŒã·ã§ã³_2ïŒ
ããã§ãæã人æ°ã®ããExcelæ©èœã®1ã€ã玹ä»ããŸãããã®æ©èœã䜿çšãããšããªãã£ã¹ã¯ãŒã«ãŒãèªåçã«ãçµéšè±å¯ãªExcelãŠãŒã¶ãŒã/ sarcasm /ã«å€ãããŸãã
åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
VLOOKUPïŒsearch_valueãtableãcolumn_numberã[interval_view]ïŒ
- Search_Valueã¯ãé¢æ°ãæ€çŽ¢ããå€ã§ãã
- è¡š-ããŒã¿ãå«ãã»ã«ã®ç¯å²ã ãããã®ã»ã«ã§æ€çŽ¢ãè¡ãããŸãã å€ã¯ãããã¹ããæ°å€ããŸãã¯è«çå€ã§ãã
- Column_numberã¯ãTableåŒæ°ã®åçªå·ã§ãããäžèŽããå Žåã«å€ã衚瀺ãããŸãã åã¯ãã·ãŒãã®äžè¬çãªã°ãªããïŒABãCãDãªã©ïŒã§ã¯ãªããTableåŒæ°ã§æå®ãããé åå ã§ã«ãŠã³ããããããšãç解ããããšãéèŠã§ãã
- Interval_view-é¢æ°ãäžèŽãèŠã€ãããã©ããã決å®ããŸã-å®å šãŸãã¯è¿äŒŒã
éèŠïŒ VLOOKUPé¢æ°ã¯ãæåã®äžæã®ã¬ã³ãŒãã®ã¿ã§äžèŽãæ€çŽ¢ããŸããdesired_valueãTableåŒæ°ã«è€æ°åååšããç°ãªãæå³ãæã€å ŽåãVLOOKUPé¢æ°ã¯æåã®äžèŽã®ã¿ãæ€çŽ¢ããä»ã®ãã¹ãŠã®äžèŽã®çµæã¯è¡šç€ºãããŸããã VPR»ïŒVLOOKUPïŒã¯ãããŒã¿ãæäœããå¥ã®ã¢ãããŒããã€ãŸãããã£ã¬ã¯ããªãã®åœ¢æã«é¢é£ä»ããããŠããŸãã
ã¢ãããŒãã®æ¬è³ªã¯ãæ¡ä»¶ãšå¯Ÿå¿ããå€ãæžã蟌ãŸããŠããã¡ã€ã³é åãšã¯å¥ã«ããSearch_valueãåŒæ°ãšç¹å®ã®çµæã®å¯Ÿå¿ã®ããã£ã¬ã¯ããªããäœæããããšã§ãã

次ã«ãããŒãã«ã®äœæ¥éšåã«ãæ¢ã«å®äºãããã£ã¬ã¯ããªãžã®ãªã³ã¯ãå«ãåŒãæ¢ã«æžã蟌ãŸããŠããŸãã ã€ãŸã ãã£ã¬ã¯ããªã®åãDãã§ãåãAãã®å€ãæ€çŽ¢ãããäžèŽãèŠã€ãããšãåãEãã®å€ãåãBãã«è¡šç€ºãããŸãã
åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
çµæãã»ã«B2ã«åºåããŸãã
= VLOOKUPïŒA2; $ D $ 2ïŒ$ E $ 5; 2; 0ïŒ
çµæ ïŒ

次ã«ãããŒãã«ãåäžã§ã¯ãªããšãã«ãããããŒãã«ããå¥ã®ããŒãã«ã«ããŒã¿ããã«ããå¿ èŠãããç¶æ³ãæ³åããŠãã ããã 以äžã®äŸãåç §ããŠãã ããã

äž¡æ¹ã®ããŒãã«ã®Productåã®è¡ãäžèŽããªãããšãããããŸãããããã¯VLOOKUPé¢æ°ã®äœ¿çšã«å¯Ÿããé害ã§ã¯ãããŸããã
çµæãã»ã«B2ã«åºåããŸãã
= VLOOKUPïŒ$ A3; $ H $ 3ïŒ$ M $ 6; 2; 0ïŒ
ãããã解決ãããšããæ°ããåé¡ã«çŽé¢ããŸã-å³ã«æžããåŒãå "B"ããå "E"ã« "ã¹ãã¬ãã"ãããšããåŒæ° "åçªå·"ãæåã§çœ®ãæããå¿ èŠããããŸãã ããã¯æéãããããæè¬ã®ãªãäœæ¥ã§ãããããã£ãŠãå¥ã®æ©èœã圹ç«ã¡ãŸã-ãCOLUMNãïŒCOLUMNïŒã
é¢æ°ã®æ§æïŒ
COLUMNïŒ[ãªã³ã¯]ïŒ
- ãªã³ã¯ã¯ãåçªå·ãè¿ãã»ã«ãŸãã¯ã»ã«ç¯å²ã§ãã
次ã®ãããªã¬ã³ãŒãã䜿çšããå ŽåïŒ
= COLUMNïŒïŒ
次ã«ãé¢æ°ã¯çŸåšã®åã®çªå·ã衚瀺ããŸãïŒæ°åŒãèšè¿°ãããŠããã»ã«ã«ïŒã
çµæã¯ãVPRãé¢æ°ã§äœ¿çšã§ããæ°å€ã§ããã次ã®åŒã䜿çšããŠååŸããŸãã
çµæãã»ã«B2ã«åºåããŸãã
= VLOOKUPïŒ$ A3; $ H $ 3ïŒ$ M $ 6; COLUMNïŒïŒ; 0ïŒ
ãCOLUMNãé¢æ°ã¯ãçŸåšã®åã®æ°ã決å®ããŸããããã¯ããColumn_NumberãåŒæ°ã«ãã£ãŠäœ¿çšããããã£ã¬ã¯ããªå ã®æ€çŽ¢åã®æ°ã決å®ããŸãã
ããã«ã次ã®æ§é ã䜿çšã§ããŸãã
=åïŒïŒ-1
æ°åã®ã1ãã®ä»£ããã«ãå¿ èŠãªæ°åã®åã®ç¹å®ã®ã»ã«ãåç §ããããªãå Žåã¯ãä»»æã®æ°åã䜿çšããŠïŒæžç®ããã ãã§ãªããååŸããå€ã«è¿œå ããŠïŒç®çã®çµæãåŸãããšãã§ããŸãã
çµæã¯æ¬¡ã®ãšããã§ãã

ãããã¯ã®éçºãç¶ããæ¡ä»¶ãè€éã«ããŸãã補åããŒã¿ãç°ãªã2ã€ã®ãã£ã¬ã¯ããªãããããåç §ãåã«ç€ºãããŠããåç §ã®çš®é¡ã«å¿ããŠãçµæã®è¡šã«å€ã衚瀺ããå¿ èŠããããšããŸã
æ¡ä»¶ïŒ
- åãDirectoryããæ°å€1ã瀺ãå ŽåãããŒã¿ã¯ããŒãã«ãDirectory_1ããããæ°å€ã2ã®å Žåãæå®ãããæã«åŸã£ãŠããŒãã«ãDirectory_2ãããã¹ãã¬ããããå¿ èŠããããŸãã

ããã«æãæµ®ãã¶è§£æ±ºçã¯æ¬¡ã®ãšããã§ãã
çµæãã»ã«C3ã«åºåããŸãã
= IFïŒ$ B3 = 1; VLRïŒ$ A3; $ G $ 3ïŒ$ I $ 6; COLUMNïŒïŒ-1; 0ïŒ; VLRïŒ$ A3; $ K $ 3ïŒ$ M $ 6; COLUMNïŒïŒ-1; 0 ïŒïŒïŒ
é·æ ïŒãã£ã¬ã¯ããªã®ååã¯äœã§ãããŸããŸããïŒããã¹ããæ°åãããã³ãããã®çµã¿åããïŒãçæ-3ã€ä»¥äžã®ãªãã·ã§ã³ãããå Žåã¯ããŸãé©ããŠããŸããã
é»è©±çªå·ãåžžã«çªå·ã§ããå Žåã次ã®ãœãªã¥ãŒã·ã§ã³ã䜿çšããããšã¯çã«ããªã£ãŠããŸãïŒ
çµæãã»ã«C3ã«åºåããŸãã
= VLOOKUPïŒ$ A3; SELECTïŒ$ B3; $ G $ 3ïŒ$ I $ 6; $ K $ 3ïŒ$ M $ 6ïŒ; COLUMNïŒïŒ-1; 0ïŒ
é·æ ïŒæ°åŒã«ã¯æ倧254åã®ãã£ã¬ã¯ããªåãå«ããããšãã§ããŸãããçæ-ååã¯å³å¯ã«æ°å€ã§ãªããã°ãªããŸããã
ãSELECTãæ©èœã䜿çšããåŒã®çµæïŒ

ããŒãã¹ïŒåŒæ° "search_value"ã®2ã€ä»¥äžã®çç±ã§VLOOKUPã
æ¡ä»¶ïŒ
- ãã€ãã®ããã«ã衚圢åŒã®ããŒã¿ã®é åãæã£ãŠãããšæ³åããŠãã ããïŒããã§ãªãå Žåã¯ãããã«ããŒã¿ãæã¡èŸŒã¿ãŸãïŒãç¹å®ã®èšå·ã«ã€ããŠã¯ãé åããå€ãååŸããå¥ã®è¡šåœ¢åŒã«é 眮ããå¿ èŠããããŸãã
äž¡æ¹ã®è¡šã以äžã«ãªã¹ãããŸãã

衚圢åŒã®ãã©ãŒã ãããããããã«ãåã¢ã€ãã ã«ã¯ååïŒäžæã§ã¯ãªãïŒã ãã§ãªããç¹å®ã®ã¯ã©ã¹ãåç §ããç¬èªã®ããã±ãŒãžãªãã·ã§ã³ããããŸãã
ååãšã¯ã©ã¹ããã³ããã±ãŒãžã®çµã¿åããã䜿çšããŠãæ°ããç¹æ§ãäœæã§ããŸãããã®ããã«ãããŒã¿ããŒãã«ã«è¿œå åãè¿œå å±æ§ããäœæãã次ã®åŒã䜿çšããŠå ¥åããŸãã
= H3ïŒ "_"ïŒI3ïŒ "_"ïŒJ3
ãïŒãèšå·ã䜿çšããŠã3ã€ã®å±æ§ã1ã€ã«çµåããŸãïŒåèªéã®åºåãã¯ä»»æã§ããå Žåãããã°ããŸã£ãããªãå ŽåããããŸãããäž»ãªããšã¯æ€çŽ¢ã«åæ§ã®ã«ãŒã«ã䜿çšããããšã§ãïŒ
åŒã®é¡äŒŒäœã¯CONCATENATEé¢æ°ã§ããå Žåãããããã®å Žåã¯æ¬¡ã®ããã«ãªããŸãã
=ã¯ãªãã¯ïŒH3; "_"; I3; "_"; J3ïŒ
ããŒã¿ãå«ãããŒãã«ã®åã¬ã³ãŒãã«å¯ŸããŠè¿œå ã®æ©èœãäœæãããåŸã次ã®ããã«ãã®æ©èœã®æ€çŽ¢é¢æ°ãèšè¿°ããŸãã
çµæãã»ã«D3ã«åºåããŸãã
= IFãšã©ãŒïŒVLOOKUPïŒA2ïŒ "_"ïŒB2ïŒ "_"ïŒC2; $ G $ 2ïŒ$ K $ 6; 5; 0ïŒ; 0ïŒ
ãVLOOKUPãé¢æ°ã§ã¯ã3ã€ã®å±æ§ã®åãæãåŒæ°ãsearch_valueãïŒname_class_packingïŒãšããŠäœ¿çšããŸããããã§ã«ããŒãã«ã«å ¥åããŠå ¥åããåŒæ°ã«çŽæ¥å ¥åããŸãïŒãªãã·ã§ã³ãšããŠãè¿œå ã®åã§åŒæ°ã®å€ãéžæã§ããŸãïŒè¡šã«èšå ¥ããŸããããã®ã¢ã¯ã·ã§ã³ã¯åé·ã§ãïŒã
ç®çã®å€ãèŠã€ãããªãå Žåã¯IFERRORé¢æ°ã䜿çšããå¿ èŠããããVLOOKUPé¢æ°ã¯å€ "ïŒN / A"ã衚瀺ããŸãïŒè©³çŽ°ã«ã€ããŠã¯åŸè¿°ïŒã
äžã®åçã®çµæïŒ

ãã®ææ³ã¯ããå€ãã®æ©èœã«äœ¿çšã§ããŸããå¯äžã®æ¡ä»¶ã¯ãååŸãããçµã¿åããã®äžææ§ã§ãããããå°éãããªãå Žåãçµæã¯äžæ£ç¢ºã«ãªããŸãã
Case_3é åå ã®å€ãæ€çŽ¢ããããVLOOKUPã圹ã«ç«ããªãå Žå
ã»ã«ã®é åã«å¿ èŠãªå€ãå«ãŸããŠãããã©ãããç解ããå¿ èŠãããç¶æ³ãèããŸãã
ãã£ã¬ã³ãžïŒ
- ãæ€çŽ¢èªãåã«å€ã瀺ãããŠããããæ€çŽ¢é åãåã«å€ãååšãããã©ãããå€æããå¿ èŠããããŸãã
èŠèŠçã«ã¯ããã¹ãŠã次ã®ããã«ãªããŸãã

ã芧ã®ãšãããããã§ã¯ãVPRãæ©èœã¯ç¡åã§ãã å®å šã«äžèŽãããã®ã§ã¯ãªããå¿ èŠãªå€ãã»ã«ã«ååšãããã®ãæ¢ããŠããŸãã
ãã®åé¡ã解決ããã«ã¯ãããã€ãã®æ©èœãçµã¿åãããŠäœ¿çšââããå¿ èŠããããŸãã
IF
ãšã©ãŒã®å Žå
ãLINEã
èŠã€ãã
ãã¹ãŠã®é åºã§ããIFãã¯ãã§ã«ä»¥åã«å解ãããŠããã®ã§ãé¢æ°ãIFERRORãã«é²ã¿ãŸãã
IFãšã©ãŒïŒå€ãerror_valueïŒ
- å€ã¯ããšã©ãŒããã§ãã¯ããåŒæ°ã§ãã
- Error_valueã¯ãåŒã«ããèšç®äžã«ãšã©ãŒãçºçãããšãã«è¿ãããå€ã§ãã 次ã®ã¿ã€ãã®ãšã©ãŒãèããããŸãïŒïŒN / AãïŒVALUEïŒãïŒREFïŒãïŒDELIVERY / 0ïŒãïŒNUMBERïŒãïŒNAMEïŒ ããã³ïŒEMPTYïŒ
éèŠïŒæ å ±ã®é åããªãã¡ã¬ã³ã¹ããã¯ãæäœããå Žåããã®åŒã¯ã»ãšãã©åžžã«å¿ èŠã§ãã ç®çã®å€ããã£ã¬ã¯ããªã«ãªãããšããããããŸãããã®å Žåãé¢æ°ã¯ãšã©ãŒãè¿ããŸãã ã»ã«ã«ãšã©ãŒã衚瀺ãããã»ã«ãèšç®ãªã©ã«é¢äžããŠããå Žåããšã©ãŒãçºçããŸãã ããã«ãæ°åŒããšã©ãŒãè¿ããã»ã«ã«ã¯ãçµ±èšåŠçã容æã«ããããŸããŸãªå€ãå²ãåœãŠãããšãã§ããŸãã ãŸãããšã©ãŒãçºçããå Žåãä»ã®æ©èœãå®è¡ã§ããŸããããã¯ãé åãæäœãããšãã«éåžžã«äŸ¿å©ã§ãããåå²æ¡ä»¶ãèæ ®ããŠåŒãäœæã§ããŸãã
LINE
äœïŒããã¹ãïŒ
- ããã¹ãã¯ãå°æåã«å€æãããããã¹ãã§ãã
éèŠïŒLINEé¢æ°ã¯ãæå以å€ã®æåã眮ãæããŸããã
åŒã®åœ¹å²ïŒFINDé¢æ°ã¯å€§æåãšå°æåãåºå¥ããŠæ€çŽ¢ãããããããã¹ãå šäœã1ã€ã®ã±ãŒã¹ã«ãŸãšããå¿ èŠããããŸããããããªããšãteaã¯teaãšçãããªããŸããã ããã¯ãã¬ãžã¹ã¿ã®å€ãå€ã®æ€çŽ¢ããã³éžæã®æ¡ä»¶ã§ã¯ãªãå Žåã«é¢ä¿ããŸããããã§ãªãå ŽåãåŒãLINEãã䜿çšã§ããªããããæ€çŽ¢ãããæ£ç¢ºã«ãªããŸãã
次ã«ãFINDé¢æ°ã®æ§æã«ã€ããŠè©³ãã説æããŸãã
FINDïŒsearched_textãviewed_textã[start_position]ïŒ
- Search_textã¯ãæ€çŽ¢ããããã¹ãã§ãã
- 衚瀺ãããããã¹ãã¯ãæ€çŽ¢ããã¹ããæ€çŽ¢ããããã¹ãã§ãã
- Start_positionã¯ãæ€çŽ¢ãéå§ããèšå·ã§ãã ããã¹ããviewed_textãã®æåã®æåã®çªå·ã¯1ã§ããçªå·ãæå®ãããŠããªãå Žåãããã©ã«ãã§ã¯1ãšèŠãªãããŸãã
ãœãªã¥ãŒã·ã§ã³åŒã®æ§æã¯æ¬¡ã®ãšããã§ãã
çµæãã»ã«B2ã«åºåããŸãã
= IFïŒIFãšã©ãŒïŒFINDïŒLINEïŒA2ïŒ; LINEïŒE2ïŒ; 1ïŒ; 0ïŒ= 0; "fail"; "bingoïŒ"ïŒ
ã¢ã¯ã·ã§ã³ã®åŒã®ããžãã¯ãåæããŠã¿ãŸãããã
- LINEïŒA2ïŒ-A2ã®ã»ã«ã®åŒæ°ãSearched_textããå°æåã®ããã¹ãã«å€æããŸã
- ãFINDãé¢æ°ã¯ããLINEïŒE2ïŒãé¢æ°ã«ãã£ãŠå°æåããã¹ãã«å€æãããé åãViewed_textãå ã®å€æãããåŒæ°ãSearched_textãã®æ€çŽ¢ãéå§ããŸãã
- é¢æ°ãäžèŽããå Žåãã€ãŸã äžèŽããåèª/å€ã®æåã®æåã®ã·ãªã¢ã«çªå·ãè¿ããŸãããIFãåŒã®TRUEæ¡ä»¶ãããªã¬ãŒãããŸãã çµæã®å€ã¯ãŒãã«çãããããŸããã ãã®çµæãããã³ãŽïŒããšããå€ããçµæãåã«è¡šç€ºãããŸãã
- ãã ããé¢æ°ãäžèŽãæ€åºããªãå Žåãã€ãŸã äžèŽããåèª/å€ã®æåã®æåã®ã·ãªã¢ã«çªå·ã¯ç€ºããããå€ã®ä»£ããã«ãšã©ãŒãè¿ãããŸãããIF ERRORãåŒã§èšå®ãããæ¡ä»¶ãããªã¬ãŒãããã0ãã«çããå€ãè¿ãããŸãã çµæã®å€ã¯ã0ãã§ãã ãã®çµæããçµæãåã«å€ã倱æãã衚瀺ãããŸãã

äžèšã®å³ãããããããã«ããLINEãããã³ãFINDãæ©èœã®ãããã§ãæåã®å€§æåå°æåãã»ã«å ã®äœçœ®ã«é¢ä¿ãªããç®çã®å€ãèŠã€ãããŸããã5è¡ç®ã«æ³šæããå¿ èŠããããŸãã
æ€çŽ¢æ¡ä»¶ã¯ã111ãã«èšå®ãããŠããŸãããå€ã1111111 cookiesããæ€çŽ¢é åã«ç€ºãããŠããŸãããåŒã¯çµæãBingoïŒããè¿ããŸãã ããã¯ãå€ã111ããäžé£ã®å€ã1111111ãã«å«ãŸãããããçµæãšããŠäžèŽããããã§ãã ããã§ãªãå Žåããã®æ¡ä»¶ã¯æ©èœããŸããã
Case_4ããã€ãã®æ¡ä»¶ã«åŸã£ãŠé åå ã®å€ãæ€çŽ¢ããå ŽåããŸãã¯VLOOKããŸã 圹ã«ç«ããªãå Žå
ããã€ãã®æ¡ä»¶ãã€ãŸãå€ãNameããšãMonthãã«ã€ããŠã2次å é åãåç §ãã®ãçµæã®è¡šãããå€ãèŠã€ããå¿ èŠãããç¶æ³ãæ³åããŠãã ããã
ã¿ã¹ã¯ã®è¡šåœ¢åŒã¯æ¬¡ã®åœ¢åŒã«ãªããŸãã

æ¡ä»¶ïŒ
- æ¡ä»¶ãååããšãæãã®äžèŽã«å¿ããŠãçµæãå«ãããŒãã«ã«ããŒã¿ããã«ããå¿ èŠããããŸãã
ãã®åé¡ã解決ããã«ã¯ãæ©èœãINDEXããšãSEARCHãã®çµã¿åãããé©ããŠããŸã
INDEXé¢æ°ã®æ§æ
INDEXïŒé åãè¡çªå·ã[åçªå·]ïŒ
- é å-æ€çŽ¢æ¡ä»¶ã«äžèŽããå Žåã«å€ã衚瀺ãããã»ã«ã®ç¯å²ã
- é åã«1è¡ãŸãã¯1åã®ã¿ãå«ãŸããå ŽåãåŒæ° "row_number"ãŸã㯠"column_number"ã¯ãããããªãã·ã§ã³ã§ãã
- é åãè€æ°ã®è¡ãšåãå æããåŒæ° "row_number"ãš "column_number"ãã1ã€ã ããæå®ãããŠããå Žåã "INDEX"é¢æ°ã¯ã "array"åŒæ°ã®è¡å šäœãŸãã¯åå šäœã§æ§æãããé åãè¿ããŸãã
- Line_numberã¯ãå€ãè¿ãé åå ã®è¡çªå·ã§ãã
- Column_numberã¯ãå€ãè¿ãå ã®é åå ã®åçªå·ã§ãã
ã€ãŸããé¢æ°ã¯ãåŒæ°Arrayã§æå®ãããé åãããRow_NumberåŒæ°ãšColumn_NumberåŒæ°ã§æå®ããã座æšã®äº€ç¹ã«ããå€ãè¿ããŸãã
MATCHã®æ§æ
SEARCHïŒsearch_valueãlookup_arrayã[match_type]ïŒ
- Search_Valueã¯ãlookup_arrayã®åŒæ°ã®å€ã«ããããããå€ã§ãã search_valueåŒæ°ã«ã¯ãå€ïŒæ°å€ãããã¹ãããŸãã¯è«çå€ïŒãŸãã¯ãã®å€ãå«ãã»ã«ãžã®åç §ãæå®ã§ããŸãã
- Viewed_arrayã¯ãæ€çŽ¢ãå®è¡ãããã»ã«ã®ç¯å²ã§ãã
- MatchTypeã¯ãªãã·ã§ã³ã®åŒæ°ã§ãã çªå·ã¯-1ã0ããŸãã¯1ã§ãã
SEARCHé¢æ°ã¯ãã»ã«ç¯å²å ã®æå®ãããèŠçŽ ãæ€çŽ¢ããç¯å²å ã®ãã®èŠçŽ ã®çžå¯Ÿäœçœ®ãè¿ããŸãã
INDEXé¢æ°ãšSEARCHé¢æ°ã®çµã¿åããã䜿çšããããšã®æ¬è³ªã¯ãã座æšè»žãã«æ²¿ã£ãååã§å€ã®åº§æšãæ€çŽ¢ããããšã§ãã
軞Yã¯åãååãã«ãªãã軞Xã¯è¡ãæãã«ãªããŸãã
åŒã®äžéšïŒ
æ€çŽ¢ïŒ$ A4; $ I $ 4ïŒ$ I $ 7; 0ïŒY軞ã«æ²¿ã£ãŠæ°å€ãè¿ããŸãããã®å Žåã1ã«ãªããŸãã å€ãAãã¯ç®çã®ç¯å²å ã«ããããã®ç¯å²å ã®çžå¯Ÿäœçœ®ã¯ã1ãã§ãã
åŒã®äžéšïŒ
æ€çŽ¢ïŒB $ 3; $ J $ 3ïŒ$ L $ 3; 0ïŒå€ïŒN / Aãè¿ããŸãã å€ã1ãã¯è¡šç€ºç¯å²å ã«ãããŸããã
ãããã£ãŠãINDEXé¢æ°ãArrayåŒæ°ãæ€çŽ¢ããããã«äœ¿çšãããã€ã³ãïŒ1;ïŒN / AïŒã®åº§æšãååŸããŸããã
ã»ã«B4ã®å®å šã«èšè¿°ãããé¢æ°ã¯æ¬¡ã®ããã«ãªããŸãã
= INDEXïŒ$ J $ 4ïŒ$ L $ 7; SEARCHïŒ$ A4; $ I $ 4ïŒ$ I $ 7; 0ïŒ; SEARCHïŒB $ 3; $ J $ 3ïŒ$ L $ 3; 0ïŒïŒ
å®éãå¿ èŠãªå€ã®åº§æšãããã£ãŠããå Žåãé¢æ°ã¯æ¬¡ã®ããã«ãªããŸãã
= INDEXïŒ$ J $ 4ïŒ$ L $ 7; 1;ïŒN / AïŒïŒ
åŒæ°ãColumn_Numberãã®å€ã¯ãïŒN / Aãã§ãããããã»ã«ãB4ãã®çµæã¯å¯Ÿå¿ããŸãã
çµæãããããããã«ãçµæãå«ãããŒãã«å ã®ãã¹ãŠã®å€ããã£ã¬ã¯ããªãšäžèŽããããã§ã¯ãªããçµæãšããŠãããŒãã«å ã®å€ã®äžéšããïŒN / Aãã®åœ¢åŒã§è¡šç€ºãããããšãããããŸããããã«ãããããŒã¿ã®äœ¿çšãè€éã«ãªããŸãã
çµæïŒ

ãã®ãã€ãã¹ã®åœ±é¿ãäžåããããã«ãå ã»ã©èªãã ããšã©ãŒãé¢æ°ã䜿çšããè¿ãããå€ããšã©ãŒã0ãã«çœ®ãæãããšãåŒã¯æ¬¡ã®ããã«ãªããŸãã
çµæãã»ã«B4ã«åºåããŸãã
= IFãšã©ãŒïŒINDEXïŒ$ J $ 4ïŒ$ L $ 7; SEARCHïŒ$ A4; $ I $ 4ïŒ$ I $ 7; 0ïŒ; SEARCHïŒB $ 3; $ J $ 3ïŒ$ L $ 3; 0ïŒïŒ; 0ïŒ
çµæã®ãã¢ã³ã¹ãã¬ãŒã·ã§ã³ïŒ

å³ãããããããã«ããïŒN / Aãã®å€ã¯ãçµæã®è¡šã®å€ã䜿çšããåŸç¶ã®èšç®ã§å¹²æžããªããªããŸããã
Case_5æ°å€ç¯å²å ã®å€ãæ€çŽ¢
ç¹å®ã®ç¯å²å ã®æ°å€ã«ç¹å®ã®å±æ§ãäžããå¿ èŠããããšæ³åããŠãã ããã
æ¡ä»¶ïŒ
補åã®ã³ã¹ãã«å¿ããŠãç¹å®ã®ã«ããŽãªãå²ãåœãŠãå¿ èŠããããŸãã
å€ãç¯å²å ã«ããå Žå
- 0ãã1000 = A
- 1001ãã1500 = B
- 1501ãã2000 = V
- 2001ãã2500 = G
- 2501ãè¶ ãã= D

LOOKUPé¢æ°ã¯ãè¡ãåããŸãã¯é åããå€ãè¿ããŸãã ãã®é¢æ°ã«ã¯ããã¯ã¿ãŒåœ¢åŒãšé å圢åŒã®2ã€ã®æ§æ圢åŒããããŸãã
VIEWïŒæ€çŽ¢å€;é²èŠ§ãã¯ãã«; [çµæãã¯ãã«]ïŒ
- Search_Valueã¯ãVIEWé¢æ°ãæåã®ãã¯ãã«ã§æ€çŽ¢ããå€ã§ãã search_valueã«ã¯ãæ°å€ãããã¹ããããŒã«å€ãååããŸãã¯å€ãžã®åç §ãæå®ã§ããŸãã
- Viewed_Vector-1è¡ãŸãã¯1åã®ç¯å²ã watched_vectoråŒæ°ã®å€ã¯ãããã¹ããæ°å€ããŸãã¯è«çå€ã«ããããšãã§ããŸãã
- åŒæ°visible_vectorã®å€ã¯ãæé ã§é 眮ããå¿ èŠããããŸãïŒ...ã-2ã-1ã0ã1ã2ã...ãAZãFALSEãTRUE; ããããªããšãVIEWé¢æ°ã誀ã£ãçµæãè¿ãå¯èœæ§ããããŸãã å°æåãšå€§æåã®ããã¹ãã¯åçãšèŠãªãããŸãã
- Result_Vectorã¯ã1è¡ãŸãã¯1åã®ç¯å²ã§ãã result_vectorã¯ãwatched_vectorãšåããµã€ãºã§ãªããã°ãªããŸããã
çµæãã»ã«B3ã«åºåããŸãã
=ãã¥ãŒïŒE3; $ A $ 3ïŒ$ A $ 7; $ B $ 3ïŒ$ B $ 7ïŒ

åŒæ°ãViewed_Vectorãããã³ãResult_Vectorãã¯é åã®åœ¢åŒã§èšè¿°ã§ããŸãããã®å ŽåãExcelã¯ãŒã¯ã·ãŒãã®å¥ã®ããŒãã«ã«è¡šç€ºããå¿ èŠã¯ãããŸããã
ãã®å Žåãé¢æ°ã¯æ¬¡ã®ããã«ãªããŸãã
çµæãã»ã«B3ã«åºåããŸãã
= VIEWïŒE3; {0; 1001; 1501; 2001; 2501}; {"A"; "B"; "C"; "G"; "D"}ïŒ
Case_6å±æ§ã«ããæ°å€ã®åèš
ç¹å®ã®åºæºã«åŸã£ãŠæ°å€ãåèšããã«ã¯ã3ã€ã®ç°ãªãé¢æ°ã䜿çšã§ããŸãã
SUMIFïŒSUMIFïŒ-1ã€ã®ç¹æ§ã®ã¿ãèŠçŽããŸã
SUMIFSïŒSUMIFSïŒ-æ©èœã»ãããèŠçŽããŸã
SUMPRODUCTïŒSUMPRODUCTïŒ-æ©èœã»ãããèŠçŽããŸã
æ°åŒãSUMããé åã«äžãããããšãã«ããSUMãïŒSUMïŒãšé åã®æ°åŒã®é¢æ°ã䜿çšãããªãã·ã§ã³ããããŸãã
ïŒ{= SUMïŒïŒïŒ*ïŒïŒïŒ}
ãããããã®ãããªã¢ãããŒãã¯ããªãäžäŸ¿ã§ãããåŒãSUMMPROIZVãã«ãã£ãŠæ©èœãå®å šã«éè€ããŠããŸã
次ã«ãæ§æãSUMPRODUCTãã®è©³çŽ°ïŒ
SUMPRODUCTïŒã¢ã¬ã€1ã[ã¢ã¬ã€2]ã[ã¢ã¬ã€3]ã...ïŒ
- Array1ã¯ãã³ã³ããŒãã³ããä¹ç®ããŠããçµæãè¿œå ããå¿ èŠãããæåã®é åã§ãã
- Array2ãarray3 ...-2ãã255ã®é åã§ããã®ã³ã³ããŒãã³ããä¹ç®ããçµæãè¿œå ããå¿ èŠããããŸãã
æ¡ä»¶ïŒ
- ç¹å®ã®æéã®å補åã®éæå¥ã®åèšéé¡ãæ€çŽ¢ããŸãã

ããŒã¿ãå«ãããŒãã«ãããããããã«ãã³ã¹ããèšç®ããã«ã¯ãäŸ¡æ Œã«æ°éãæããå¿ èŠããããéžææ¡ä»¶ãé©çšããçµæã®å€ãçµæãšãšãã«ããŒãã«ã«è»¢éããå¿ èŠããããŸãã
ãã ããSUMMPROIZæ°åŒã䜿çšãããšããã®ãããªèšç®ãæ°åŒå ã§å®è¡ã§ããŸãã
çµæãã»ã«B4ã«åºåããŸãã
= SUMPRODUCTïŒïŒ$ A4 = $ H $ 3ïŒ$ H $ 11ïŒ*ïŒ$ K $ 3ïŒ$ K $ 11> = B $ 3ïŒ*ïŒ$ K $ 3ïŒ$ K $ 11 <C $ 3ïŒ;ïŒ$ M $ 3ïŒ$ M $ 11ïŒ*ïŒ$ L $ 3ïŒ$ L $ 11ïŒïŒ
éšåçã«åŒãåæããŸãããïŒ
ïŒ$ A4 = $ H $ 3ïŒ$ H $ 11ïŒ-çµæã®è¡šã®ãååãåã®ããŒã¿ã䜿çšããŠãè¡šã®ãååãåã«éžææ¡ä»¶ãèšå®ããŸã
ïŒ$ K $ 3ïŒ$ K $ 11> = B $ 3ïŒ*ïŒ$ K $ 3ïŒ$ K $ 11 <C $ 3ïŒ-æéæ ã«åŸã£ãŠæ¡ä»¶ãèšå®ããŸããæ¥ä»ã¯çŸåšã®æã®æåã®æ¥ä»¥äžã§ããã次ã®æã®æåã®æ¥ãããå°ãããªããŸãã åæ§ã«-çµæãå«ãããŒãã«å ã®æ¡ä»¶ãé å-ããŒã¿ãå«ãããŒãã«å ã
ïŒ$ M $ 3ïŒ$ M $ 11ïŒ*ïŒ$ L $ 3ïŒ$ L $ 11ïŒ-ããŒãã«ã®ãæ°éãåãšãäŸ¡æ Œãåã«ããŒã¿ãæããŸãã
ãã®é¢æ°ã®ééããªãå©ç¹ã¯ãèšé²æ¡ä»¶ã®èªç±ãªé åºã§ãããããã¯ä»»æã®é åºã§æžã蟌ãããšãã§ããããã¯çµæã«åœ±é¿ããŸããã
çµæïŒ

ããã§ãæ¡ä»¶ãè€éã«ãããcookiesããšããååã«ããéžæããsmallãããã³ãlargeãã¯ã©ã¹ã«å¯ŸããŠã®ã¿è¡ããããpastryããšããååã«ããéžæãã¯ã©ã¹ãjamããé€ããã¹ãŠãè¿œå ãããšããèŠä»¶ãè¿œå ããŸãã
çµæãã»ã«B4ã«åºåããŸãïŒ
= SUMPRODUCTïŒïŒ$ A4 = $ H $ 3ïŒ$ H $ 11ïŒ*ïŒ$ J $ 3ïŒ$ J $ 11> = B $ 3ïŒ*ïŒ$ J $ 3ïŒ$ J $ 11 <C $ 3ïŒ*ïŒïŒ$ I $ 3ïŒ$ I $ 11 = "å°"ïŒ+ïŒ$ I $ 3ïŒ$ I $ 11 = "倧"ïŒïŒ;ïŒ$ L $ 3ïŒ$ L $ 11 * $ K $ 3ïŒ$ K $ 11ïŒïŒ
CookieéžæåŒã«æ°ããæ¡ä»¶ãè¿œå ãããŸããã
ïŒïŒ$ I $ 3ïŒ$ I $ 11 = "å°ãã"ïŒ+ïŒ$ I $ 3ïŒ$ I $ 11 = "倧ãã"ïŒïŒ-ã芧ã®ãšããã1ã€ã®åã®2ã€ä»¥äžã®æ¡ä»¶ã¯ãã+ãèšå·ã䜿çšããŠå¥ã®ã°ã«ãŒãã§éžæããæ¡ä»¶ãè¿œå ã®ãã£ãã§å²ã¿ãŸãã
ããŒã«éžæåŒã«æ°ããæ¡ä»¶ãè¿œå ãããŸããã
= SUMPRODUCTïŒïŒ$ A5 = $ H $ 3ïŒ$ H $ 11ïŒ*ïŒ$ J $ 3ïŒ$ J $ 11> = B $ 3ïŒ*ïŒ$ J $ 3ïŒ$ J $ 11 <C $ 3ïŒ*ïŒ$ I $ 3ïŒ$ I $ 11 <> "ãžã£ã ãã"ïŒ;;ïŒ$ L $ 3ïŒ$ L $ 11ïŒ*ïŒ$ K $ 3ïŒ$ K $ 11ïŒïŒ
ããïŒ
ïŒ$ I $ 3ïŒ$ I <>ããžã£ã ãããïŒ-å®éããã®åŒã§ã¯ãCookieãéžæãããšããšåæ§ã«éžææ¡ä»¶ãæžã蟌ãããšãã§ããŸãããããã®åŸãåŒã«3ã€ã®æ¡ä»¶ããªã¹ãããå¿ èŠããããŸãããã®å Žåãå€ã䜿çšããããžã£ã ããããšã¯ç°ãªããäŸå€ãæžãæ¹ãç°¡åã§ãã<>ãã
äžè¬ã«ãæ©èœ/ã¯ã©ã¹ã®ã°ã«ãŒããäºåã«ããã£ãŠããå Žåããã¹ãŠã®æ¡ä»¶ãé¢æ°ã«æžã蟌ãã§èšããŸããããããããããã°ã«ãŒãã«çµåããŠãã£ã¬ã¯ããªãäœæããæ¹ãé©åã§ãã
çµæïŒ

ããŠãããã§ç°¡åãªããã¥ã¢ã«ã®æåŸã«æ¥ãŸãããå®éã¯ãã£ãšå€§ãããªãå¯èœæ§ããããŸãããç®æšã¯æãäžè¬çãªç¶æ³ãžã®è§£æ±ºçãæäŸããããšã§ãããç¹å®ã®è§£æ±ºçã説æããããšã§ã¯ãããŸããã§ããïŒããããããèå³æ·±ãã±ãŒã¹ïŒã
ãã®ããã¥ã¢ã«ããExcelã䜿çšããåé¡ã®è§£æ±ºã«åœ¹ç«ã€ããšãé¡ã£ãŠããŸããããã¯ãç§ã®ä»äºãç¡é§ã«ãªããªãã£ãããšãæå³ããããã§ãã
ãæéãããã ãããããšãããããŸãïŒ