| CARVIEW |
?f?[?^???͂ɓK?????f?[?^?`???ɕϊ???????@?ƁA?\?f?[?^??ǂݍ??ޕ??@?F?₳?????f?[?^????
?f?[?^???͂̏???????w??ł????A?ڂ̑?16??i?ŏI??j?B???͂ɓK?????`?Ƀf?[?^????́^?ϊ???????@???AExcel???g???Ď?????Ȃ???w??ł????܂??傤?B?X?^?b?N?`???̃??R?[?h???A???X?^?b?N?`???ɕϊ???????@?ACVS?t?@?C????Web?y?[?W????f?[?^??ǂݍ??ޕ??@?Ȃǂɂ??ĉ?????܂??B
???̋L???͉??????ł??B????o?^?i?????j????ƑS?Ă????????????܂??B
?A?ځF
?w?Љ?l1?N??????w?ԁA?₳?????f?[?^???́x
?@???̘A?ڂł́A?f?[?^?????܂??܂Ȋp?x???番?͂??A???̔w??ɂ???L?v?ȏ??????o?????@???w?т܂??B
?@?f?[?^?̎??W???@?A?f?[?^?̎?舵???A???͂̎?@?Ȃǂɂ??Ă̍l????????̗?Ő???????ƂƂ??ɁA?g?߂Ɏg????\?v?Z?\?t?g?iExcel??Google?X?v???b?h?V?[?g?j?𗘗p?????쐬????Љ?܂??B
?@?K?v?ɉ????āAPython?̃v???O?????ⓝ?v?\?t?gR?Ȃǂł̍쐬??ɂ??G??邱?Ƃɂ??܂??B
?@???w?Ȃǂ̑O??m???͓??ɖ₢?܂???B???̗͂??Ă??ЂƂ??C?y?ɓǂݐi?߂Ă????????B
?H?R???M?ҏЉ?F IT?n???C?^?[?̖T??A???u?t?Ƃ??ē???ŏ??E?v???O???~???O?֘A?̎??Ƃ??A?ꋴ???AI?֘A?̎??Ƃ?S???B?????A?G????o?āA?s?A?m?ƃo?C?I??????Ɗw?Ŏn?߂???w?K?Ȑ??͏?ɕ??R?B??̌????́A?ŋߖ?????????99??ň?U???f?B????Ƀ??^?[?????C?_?[??ڎw???A??^??֖Ƌ????擾?B1?N?????ăR?c?R?c?ƒ??????A?悤?₭?o?C?N???w???i?܂?????????j?B
?@?O???͏d??A???͂ɂ??A?????̐????ϐ?????ɖړI?ϐ??̒l??\????????@???w?т܂????B???̒??ŁA?f?[?^?̌`???𐮂??邱?Ƃ̏d?v???ɂ??ċC?t???????Ǝv???܂??B?f?[?^?̎?舵???ɂ??ẮA?{???ł???Ε??͂ɐ旧???čl???Ă????ׂ????Ƃł??B???????A???܂??܂Ȏ?@??̌????邱?Ƃ?D?悵???̂ŁA?????ĘA?ڂ̍Ō?ɂ܂Ƃ߂邱?ƂƂ??܂????B
?@????́A???ۂɃ??R?[?h???ǂ̂悤?ɍ\?????邩?A?f?[?^???ǂ̂悤?ɕ??ׂ邩?i?X?^?b?N?`???^?A???X?^?b?N?`???j?Ƃ??????f?[?^?̕\???Ɋւ?????ɂ??Č?????A?t?@?C???ɕۑ?????Ă???f?[?^?̌`???iCSV?j?ƕ????R?[?h?iUTF-8?ABOM?j?ɂ܂????ɂ??āA????́u???????v????????グ?A?g???u???V???[?e?B???O?I?Ɍ??Ă??????ƂƂ??܂??i?}1?`3?j?B?Ȃ??A?????̗\??ł̓f?[?^?̎?舵???𐔉?ɕ????ĉ??????\??ł??????A??2???ŁA?K?v?Œ???̂??b?i?\?????f?[?^?Ɣ?\?????f?[?^?A???R?[?h?ƃt?B?[???h?Ȃǁj?ɂ??Ă͍ς܂??Ă???̂ŁA????ň?ʂ?̂??b???I???ƂȂ?A?S16??ɂ킽??A?ڂ͍??ŏI??ƂȂ?܂??B
?}1?@?f?[?^?̓??͂ł??肪???ȍ??????????ڂ??P???ɕ???ł???f?[?^?ł?????R?[?h?ɂǂ̂悤?ȃt?B?[???h??z?u????????̂??ȒP?ɕ????邪?A?`?[?`???̃f?[?^?̂悤?ɁA???ׂɌJ??Ԃ???????f?[?^???ǂ̂悤?Ƀ??R?[?h?Ƃ??ĕ\???????̂??Y?ޏꍇ???????B???R?[?h??t?B?[???h?ɂ??ẮA?P?Ɍ??t?̈Ӗ??????łȂ??A???H?I?ȗ??????K?v?B
?}2?@?f?[?^?̉????╪?͂̑O?ɂ??肪???ȍ????????I?[?v???f?[?^?͐}?̍???Ɏ??????悤?ȃX?^?b?N?`???Œ???Ă?????̂??????B???܂??????ł??Ȃ??ꍇ?́A?A???X?^?b?N?`???ɕϊ???????A????ɃO???t?Ŏ?舵???̂ɓK?????`???ɕϊ?????K?v??????B?܂??́A?X?^?b?N?`???ƃA???X?^?b?N?`???̈Ⴂ?𗝉????悤?B?Ȃ??A???̃f?[?^??IMF?̃I?[?v???f?[?^?????H???????́B
?}3?@?t?@?C???╶???R?[?h?Ɋւ??Ă??肪???ȍ????????I?[?v???f?[?^??CSV?t?@?C???Ƃ??Ē???Ă??邱?Ƃ????邪?AExcel?ł́A?????R?[?h??UTF-8?iBOM?Ȃ??j???Ɠ??{?ꕶ????????????????ꍇ??????B?t?@?C???̌`???╶???R?[?h?ɂ??Ă????????K?v?B?Ȃ??ACSV??Comma Separeated Values?i?J???}???̒l?j?̗??B
?@????̓f?[?^????舵????ł̖??_???[?I?ɕ?????悤?ɁA?P???ȗ???g???Č??Ă??????ƂƂ??܂??B
?@???̋L???́A?f?[?^???͂̏??????牞?p?܂ŏ??????X?e?b?v?A?b?v???Ȃ???w??ł????A?ڂ̑?16??ł??B????܂ł̓P?[?X?X?^?f?B??ʂ??āA???͂̎?@??????̕??@???ڂ??????Ă??܂????B????́A???͂̑O?i?K?ŕK?v?ƂȂ?f?[?^?̎?舵???ɂ??Č??Ă????܂??B?g?b?v?y?[?W????S?̖̂ڎ????Q?Ƃł??܂??B
???̋L???Ŋw?ׂ邱??
?@????͈ȉ??̂悤?ȃ|?C???g?ɂ??āA???͂̕??@??ڂ̕t???ǂ???????Ă????܂??B
- ???ۂ̃f?[?^?????R?[?h?Ƃ??ĕ\?????@
- ?X?^?b?N?`???ƃA???X?^?b?N?`???̕ϊ?
- CSV?t?@?C??????̓ǂݍ??݂ƕ????R?[?h?̎?舵??
?@?ł́A?`?[?`???̃f?[?^?????R?[?h?Ƃ??ĕ\???Ƃ??납??X?^?[?g???܂??B?T???v???t?@?C???̗??p?ɂ??Ă̐????̌?A?{?҂ɐi?݂܂??傤?B
?T???v???t?@?C???̗??p?ɂ???
?@?{?e?ł́A?\?v?Z?\?t?g???g???Ď?????Ȃ???w??ł????܂??B?\?v?Z?\?t?gMicrosoft Excel?p??.xlsx?t?@?C?????_?E?????[?h?ł???悤?ɂ??Ă??܂??B?f?X?N?g?b?v?ł?Excel???茳?ɂȂ??ꍇ?́AMicrosoft?A?J?E???g?Ŏg??????????Microsoft 365?I?????C???A????????Google?A?J?E???g?Ŏg??????????Google?X?v???b?h?V?[?g?iGoogle Sheets?j?????g???????????BMicrosoft 365?I?????C???̏ꍇ?́A.xlsx?t?@?C????OneDrive?ɃA?b?v???[?h???Ă???J???Ă????????BGoogle?X?v???b?h?V?[?g?̏ꍇ?́A?t?@?C???????L???ĎQ?Ƃł???悤?ɂ??܂??B?????N???J???A???j???[????m?t?@?C???n?|?m?R?s?[???쐬?n??I?????AGoogle?h???C?u?ɃR?s?[???Ă??g???????????B
?J??Ԃ??̂???f?[?^?̕\???? ?` ?`?[?`???̃f?[?^?̎?舵??
?@?}1?Ō????悤?Ȕ???`?[?̃f?[?^?????̂܂܂̃C???[?W?œ??͂???l?͂??????ɂ??Ȃ??Ǝv???܂??B?ł́A???R?[?h?Ƃ??Ăǂ̂悤?ɕ\???????̂ł??傤???B
?@???R?[?h??1?????̃f?[?^?ł???Ƃ??????Ƃ́A???̘A?ڂ̑?2???ŏq?ׂ??ʂ?ł????A?P????1???̓`?[??1?????̃f?[?^?ł???ƍl????Ƃ??܂??????܂???B???́A????`?[?ɂ?1???̗p???ɕ??????̎???f?[?^???L?^????Ă??܂??B?]???āA???̌??????A???R?[?h????͂??܂??B????A???t??ڋq?R?[?h?Ȃǂ̓??????i?????炪???j?̕????́A???ꂼ??̃??R?[?h?ɋ??ʂ??????e?ł??B?????ŁA???ʕ????͊e???R?[?h?̐擪?ɔz?u???܂??i?}4?j?B
?}4?@????`?[?̓??͗??`?[?̖???1?s??1???R?[?h?ɂȂ?BA?`D??ɂ͊e???R?[?h?ɋ??ʂȓ??e?i?`?[?̓??????̕????j?????̂܂ܓ??͂???BE?`I??ɖ??ׂ̃f?[?^????͂???B?ڋq???A???i???A?P???ɂ??Ă?VLOOKUP????XLOOKUP???ňꗗ?\?????????ĕ\??????????̂œ??͂̕K?v?͂Ȃ??B?܂??A???z???v?Z?ŋ??߂???̂œ??͂??Ȃ??Ă??悢?B???ɂ??鍇?v?i?`?[?̋r?????̕????j???v?Z???ċ??߂?悢?B
?@?o???\?t?g?Ȃǂł͓`?[?`???̉?ʂŃf?[?^?????͂ł???悤?ɂȂ??Ă??܂????A???ۂɂ͐}4?̂悤?ȃ??R?[?h?Ƃ??ăf?[?^?x?[?X?ɋL?^????Ă??܂??B???????A?????Ɛ??????ꂽ?`???ɂȂ??Ă???̂????ʂł??i?ȉ??̃t?L?_?V?̓??e???Q?Ɓj?B???Ƃł̓??͂ł͂Ȃ??APOS?iPoint Of Sales?j?[???Ȃǂ?????W???ꂽ?f?[?^?ł????l?ł??B
?@?f?[?^?x?[?X?i?????[?V???i???f?[?^?x?[?X?j?ł́A???????ǂ??A???_??Ƀf?[?^????舵?????߂????K???ƌĂ?鑀????s???A?????̕\?ɕ????ăf?[?^???L?^???܂??B
?@?f?[?^?x?[?X?̐v???ɂ́A?܂??A?`?[?̒??̖??ׁi?J??Ԃ??????j?????Đ}4?̂悤?ɕ\?????邱?Ƃ???n?߂܂??B???̂悤?ɂ??ČJ??Ԃ????Ȃ??????\??????1???K?`?ƌĂт܂??B
?@????ɁA?ڋq?R?[?h?Ə??i?R?[?h???????͂??Ă????A?K?v?ɉ????Čڋq?ꗗ?Ə??i?ꗗ????ڋq???⏤?i???A?P?????????Ă???Ό??̃f?[?^???Č??ł??܂??B???̏ꍇ?̌ڋq?R?[?h?⏤?i?R?[?h?̂悤?Ɍ??̃??R?[?h????ӂɌ??߂?̂ɕK?v?ȃL?[????L?[?ƌĂсA??L?[?Ƃ???ɏ]??????ڋq???⏤?i???A?P???̕\???????`?̕\??????2???K?`?ƌĂт܂??B
?@?f?[?^?x?[?X?̐v?ł͑?6???K?`?܂Œ?`????Ă??܂????AExcel?ł̃f?[?^?̎?舵??????͘b???O???̂ł???ȏ?͐G??܂???B?ڍׂɂ??ẮA??????̋L???Ȃǂ????Q?Ƃ????????B
?@?f?[?^???͂̏o???_?Ƃ??āA???????₷???`???Ńf?[?^???L?^???邱?Ƃ͂ƂĂ??d?v?ł??B?}4?̂悤?Ȍ`???ŋL?^???Ă????A????̓??t?̃??R?[?h?????o??????A?ڋq?⏤?i???Ƃɔ?????z???W?v?????肷?邱?Ƃ??ȒP?ɂł???Ƃ????킯?ł??B?܂???O???t??p???Ĕ???グ?̐??ڂ???????????A?p???[?g?}??p???ď??i?̔?????z?ɂ???ABC???͂??s?????肷?邱?Ƃ??ȒP?ɂł??܂??B
???͂?e?Ղɂ??A???A?G???[?f?[?^??????Ȃ??悤?ɂ???d?g??
?@?}4????????R?[?h?̍\??????????Ǝv???܂????A???p?ɍۂ??ẮA???͂?e?Ղɂ???ƂƂ??ɁA?G???[?f?[?^?????ꍞ?܂Ȃ??悤?ɂ???H?v???K?v?ɂȂ?܂??B???̂??߂ɂ????͋K???̋@?\???֗??ł??B?ڋq?R?[?h?⏤?i?R?[?h?????X?g????I???ł???悤?ɂ??Ă????A?????????L?[?{?[?h????R?[?h????͂??Ȃ??Ă??ς݂܂????A???炩???ߓo?^???ꂽ?l?ȊO???t???Ȃ??悤?ɂł??܂??B
?@????̎菇?͐}5?̌?ɉӏ??????ɂ??Ă???܂??B?T???v???t?@?C??????????????_?E?????[?h???A?m????f?[?^?n???[?N?V?[?g???J???Ď????Ă݂Ă????????BGoogle?X?v???b?h?V?[?g?̃T???v???͂?????????J?????Ƃ??ł??܂??B???j???[????m?t?@?C???n?|?m?R?s?[???쐬?n??I?????AGoogle?h???C?u?ɃR?s?[???Ă??g???????????B?ȉ??̑???ɂ??ẮA??????p?????Ă???܂??B???͋K???̐ݒ?ƃf?[?^?̓??͕??@?J?ɒǂ????????????͂??Ђ??????????????B
????1?@Excel?œ??͋K????ݒ肵?ăf?[?^????͂???ɂ?
?}5?@???͋K???𗘗p???A???͂?e?Ղɂ???ƂƂ??ɃG???[?f?[?^?̍?????h???ڋq?R?[?h?⏤?i?R?[?h??S?ċL?????Ă??āA?ԈႢ?Ȃ????͂???̂͂???߂ē???B?????ŁA???͋K????ݒ肵?A???炩???ߌ??߂?ꂽ?R?[?h?̈ꗗ????I???ł???悤?ɂ??Ă????A???????ǂ??Ȃ邵?A???̓~?X?????Ȃ??Ȃ?B?Ȃ??A?W???̐??l?ł???ΐ擪??0?͕\??????Ȃ????A?????ł͐擪??0???\???????悤?ɕ\???`????ύX???Ă???B
?@???͋K????ݒ肷?邽?߂̎菇?͈ȉ??̒ʂ?ł??B
???͋K???̐ݒ?iExcel?ł̑???菇?j
- ?Z??C2?`C5??I??????
- ?m?f?[?^?n?^?u?́m?f?[?^?̓??͋K???n?{?^?????N???b?N????
- ?m?f?[?^?̓??͋K???n?_?C?A???O?{?b?N?X?́m?ݒ?n?^?u?Łm???͒l?̎?ށn????m???X?g?n??I??????
- ?m???̒l?n?{?b?N?X???N???b?N???A?m?ڋq?ꗗ?n???[?N?V?[?g?̃Z??A4?`A7??I??????i=?ڋq?ꗗ!$A$4:$A$7?j
- ?mOK?n?{?^?????N???b?N????
???͋K???̐ݒ?iGoogle?X?v???b?h?V?[?g?ł̑???菇?j
- ?Z??C2?`C5??I??????
- ???j???[?o?[????m?f?[?^?n?|?m?f?[?^?̓??͋K???n??I??????
- ?m?f?[?^?̓??͋K???n??ƃE?C???h?E?Łm???[????lj??n?{?^?????N???b?N????
- ?m?????n?̃??X?g????m?v???_?E???i?͈͓??j?n??I??????i????ŎU?z?}???쐬?????j
- ???̉??́m?f?[?^?͈͂?I???n?{?^???i?c?̌`?̃{?^???j???N???b?N????
- ?m?f?[?^?͈͂̑I???n?_?C?A???O?{?b?N?X???\?????ꂽ??A?m?ڋq?ꗗ?n???[?N?V?[?g?̃Z??A4?`A7??I??????
- ?mOK?n?{?^?????N???b?N????
- ?m?f?[?^?̓??͋K???n??ƃE?C???h?E?Łm?????n?{?^?????N???b?N????
?@?Z??E2?`E5?ɂ??Ă????l?ɑ??삵?A?m???i?ꗗ?n???[?N?V?[?g?̃Z??A4?`A9?̒l???I???ł???悤?ɂ??Ă????܂??傤?B?ڋq???A???i???A?P???ɂ??ẮA?ȉ??̂悤??XLOOKUP??????͂??Ēl???????I?ɕ\???????悤?ɂ??Ă???܂??B
- ?Z??C2?Ɂu=XLOOKUP(C2:C5,?ڋq?ꗗ!A4:A7,?ڋq?ꗗ!B4:B7,"",0,1)?v
- ?Z??E2?Ɂu=XLOOKUP(E2:E5,???i?ꗗ!A4:A9,???i?ꗗ!B4:B9,"",0,1)?v
- ?Z??F2?Ɂu=XLOOKUP(E2:E5,???i?ꗗ!A4:A9,???i?ꗗ!C4:C9,"",0,1)?v
?@?????ɃZ??C2?Ɂu00010?v?Ɠ??͂??Ă݂Ă????????B?Z??D2?Ɂu??????Ѓ??[?O?E?N???[???v?ƕ\??????܂??B
?X?^?b?N?`???ƃA???X?^?b?N?`???̑??ݕϊ?
?@?O???t?ɂ????????s???ꍇ?╪?͂̂??߂̃c?[???𗘗p????ꍇ?ɂ́A???߂?ꂽ?`???̃f?[?^??p?ӂ??Ă????K?v??????܂??B???̂??߃X?^?b?N?`???ƃA???X?^?b?N?`???̕ϊ????K?v?ɂȂ邱?Ƃ??悭????܂??B
?@?X?^?b?N?`???̃f?[?^?Ƃ́A1?̊ϑ??f?[?^??1???R?[?h?i1?s?j?ɓ??͂??????̂ł??B??????A???X?^?b?N?`???̃f?[?^?ł́A1???R?[?h???????̊ϑ??f?[?^????Ȃ??Ă??܂??B?u?X?^?b?N?v?Ƃ́u?ςݏd?˂?v?Ƃ??????Ӗ??ł??B
?@?ŏ??Ɍ???1?l??????GDP?̗?̓f?[?^?ʂ??????A??????ƌ??Â炢?̂ŁA?ȒP?ȗ?Ō??Ă݂܂??傤?i?}6?j?B?X?^?b?N?`???̏ꍇ?A?u?ԍ?1?̐l???p??̎?????????98?_???????v?Ƃ???1?̊ϑ??f?[?^??1???R?[?h?ɂȂ??Ă??܂??B?p??̎????Ɛ??w?̎????͓????ɂ͍s???Ȃ??̂ŁA?u?ԍ?1?̐l?????w?̎?????????88?_???????v?Ƃ????͕̂ʂ̃??R?[?h?ɂȂ??Ă??܂??B????A?A???X?^?b?N?`???̗?ł́A?u?ԍ?1?̐l???p??̎?????????98?_?ŁA???w?̎?????????88?_???????v?Ƃ????悤?ɁA?????̊ϑ??f?[?^??1???R?[?h?ɂȂ??Ă??܂??i?܂?A?J??Ԃ???????Ƃ??????Ƃł??ˁj?B
?@?X?^?b?N?`???̂??Ƃ??????O?t?H?[?}?b?g?A?A???X?^?b?N?`???̂??Ƃ????C?h?t?H?[?}?b?g?ƌĂԂ??Ƃ?????܂??B
?}6?@?X?^?b?N?`???ƃA???X?^?b?N?`???̈Ⴂ?X?^?b?N?`???ł?1?̊ϑ??f?[?^??1???R?[?h?Ƃ??ċL?^?????B?A???X?^?b?N?`???ł͕????̊ϑ??f?[?^??1???R?[?h?Ƃ??ċL?^?????B?????╪?͂̂??߂̃c?[???ł́A?ǂ???̌`???Ńf?[?^?????????Ă??????????߂??Ă???̂ŁA???݂ɕϊ???????@??m???Ă????K?v??????B
?X?^?b?N?`??????A???X?^?b?N?`???ɕϊ?????
?@?X?^?b?N?`???̃f?[?^???A???X?^?b?N?`???ɕϊ???????@?Ƃ??ẮAWRAPCOLS???𗘗p??????@?ƃs?{?b?g?e?[?u?????g?????@???ȒP?ł??B?????ł͊????g???Ă???Ă݂܂??傤?B???????AWRAPCOLS????Excel 2019?ȑO?ł͎g???܂???B?s?{?b?g?e?[?u???𗘗p??????@?ɂ??ẮA??̃R?????ɂ܂Ƃ߂Ă????܂??B
?@WRAPCOLS???͎w?肵?????Ő܂?Ԃ??ė???????ł??B?Ⴆ?A10?̃f?[?^??5???Ƃɐ܂?Ԃ??A5?s2??ɂ??邱?Ƃ??ł??܂??B15?̃f?[?^??5???Ƃɐ܂?Ԃ???5?s3??ɂȂ?܂??B?}6?Ɏ??????X?^?b?N?`???̃f?[?^?ł???A8???Ƃɐ܂?Ԃ??A?A???X?^?b?N?`???ɂȂ?܂??ˁB
?@?ł́A?T???v???t?@?C??????????????_?E?????[?h???A?m???сi?X?^?b?N?`???j?n???[?N?V?[?g???J???Ď????Ă݂Ă????????BGoogle?X?v???b?h?V?[?g?̃T???v???͂?????????J?????Ƃ??ł??܂??B???j???[????m?t?@?C???n?|?m?R?s?[???쐬?n??I?????AGoogle?h???C?u?ɃR?s?[???Ă??g???????????B?ȍ~?̊????g?????X?^?b?N?`???^?A???X?^?b?N?`?????݂̕ϊ????@?ɂ??ẮA??????p?????Ă???܂??B?菇???????J?ɒǂ????????????͂??Ђ??????????????B
????2?@Excel?Ŋ????g???ăX?^?b?N?`???^?A???X?^?b?N?`???𑊌݂ɕϊ?????ɂ?
?}7?@WRAPCOLS???𗘗p???ăX?^?b?N?`?????A???X?^?b?N?`???ɕϊ?????WRAPCOLS???̈????ɂ́A1??܂???1?s?ɕ??f?[?^?͈̔͂Ƃ???C4:C19???w?肵?A?܂?Ԃ??̌??Ƃ??āA?Z??E4?`E12?̐??l?̐??i??8?j???w?肷??B16?̃f?[?^??8?s2??̌`?ɕϊ?????ĕԂ????B
?@?}7?Ɏ?????????̎菇?͈ȉ??̒ʂ?ł??B
- ?Z??F4??=WRAPCOLS(C4:C19,COUNT(E4:E11))?Ɠ??͂???
?@?ԍ??〈?o???͎??Ƃœ??͂??Ă??\???܂??A?????g???ĕ\?????邱?Ƃ??ł??܂??B?T???v???t?@?C???ɂ͈ȉ??̂悤?Ȋ??????͂???Ă???̂Ŋm?F???Ă݂Ă????????B
- ?Z??F3?F =TRANSPOSE(UNIQUE(B4:B19))
- ?Z??E4?F =UNIQUE(A4:A19)
?@?ŏ??Ɍ???1?l??????GDP?̗???S?????????@?łł??܂??B1?̍??^?n??̃f?[?^??10??????̂ŁA10???Ő܂?Ԃ??A???X?^?b?N?`???ɂł??܂??B??͐܂???O???t???쐬???邾???ł??B?T???v???t?@?C???Ɋ܂܂??m1?l??????GDP?iUS?h???쐬??j?n???[?N?V?[?g?????Q?Ƃ????????B
?@???́A?o?T??IMF?̃f?[?^?͍ŏ?????A???X?^?b?N?`???ɂȂ??Ă??܂??B?????ł́A?킴?킴?X?^?b?N?`???ɕϊ????????̂??f?ڂ??܂????B
?R?????@?s?{?b?g?e?[?u?????g???ăA???X?^?b?N?`???ɕϊ?????
?@?s?{?b?g?e?[?u?????g???ăX?^?b?N?`???̃f?[?^???A???X?^?b?N?`???ɕϊ?????ꍇ?́A?}8?̂悤?ɑ??삵?܂??BExcel?ł̎菇?͐}?̒??Ɏ??????ʂ?ł??BGoogle?X?v???b?h?V?[?g?ł̎菇?͐}?̌?ɉӏ??????ŋL???Ă????܂??B?m???сi?X?^?b?N?`???s?{?b?g?e?[?u???p?j?n???[?N?V?[?g???J???āA?????Ă݂Ă????????i??Ō??????̂Ɠ????f?[?^?ł??j?B
?}8?@?s?{?b?g?e?[?u???𗘗p???ăX?^?b?N?`?????A???X?^?b?N?`???ɕϊ??????????ł́A???̃f?[?^?ƌ??ʂ??ɕ\?????邽?߂Ƀs?{?b?g?e?[?u?????????̃??[?N?V?[?g?ɍ쐬???Ă???B?e?t?B?[???h?́A?҂̔ԍ????m?s?n?ɁA?Ȗځi?J??Ԃ??̂??鍀?ځj???m??n?ɁA???т??m???l?n?Ɏw?肷??B???ʂɂ͑??v???\??????Ă??邪?A?s?v?ł???u???v?v?̕??????E?N???b?N???ām???v?̍폜?n??I??????悢?B?Z??E4?́u?s???x???v???u?ԍ??v?ɏ?????????A?}6?̃A???X?^?b?N?`???̃f?[?^?Ɠ????`?ɂȂ?B
?@Google?X?v???b?h?V?[?g?ł̎菇?͈ȉ??̒ʂ?ł??B
Google?X?v???b?h?V?[?g?ł̑???菇
- ?Z??A3?`C19?̂????ꂩ?̃Z?????N???b?N???Ă???
- ???j???[?o?[????m?}???n?|?m?s?{?b?g?e?[?u???n??I??????
- ?m?s?{?b?g?e?[?u???̍쐬?n?_?C?A???O?{?b?N?X?́m?f?[?^?͈́n???u???сi?X?^?b?N?`???j!A3:C19?v?ɂȂ??Ă??邱?Ƃ??m?F????
- ?m?}????n?̉??́m?????̃??[?N?V?[?g?n???N???b?N???ăI???ɂ???
- ?m?f?[?^?͈͂?I???n?{?^???i?c?̃}?[?N?̃{?^???j???N???b?N???āA?Z??E3???N???b?N???A?mOK?n???N???b?N????
- ?m?쐬?n?{?^?????N???b?N????
?@????ŁA??̃s?{?b?g?e?[?u?????쐬????܂??B??ʂ̉E???Ƀs?{?b?g?e?[?u???G?f?B?^???\???????̂ŁA?ȉ??̂悤?ɑ??삵?܂??傤?B
- ?E???ɕ\??????Ă??鍀?ڈꗗ?́m?ԍ??n???A?????́m?s?n?̉??Ƀh???b?O????
- ?E???ɕ\??????Ă??鍀?ڈꗗ?́m?Ȗځn???A?????́m??n?̉??Ƀh???b?O????
- ?E???ɕ\??????Ă??鍀?ڈꗗ?́m???сn???A?????́m?l?n?̉??Ƀh???b?O????
?@???ʂ??s?{?b?g?e?[?u???Ƃ??Ăł͂Ȃ??A?P?Ȃ?f?[?^?Ƃ??ė??p???????ꍇ?ɂ́A???̏ꏊ?ɃR?s?[???Ă????Ƃ????ł??傤?B?}8?̗?ł???A?Z??E4?`G12???R?s?[???A???̏ꏊ?ɓ\??t???Ă????܂??B
?A???X?^?b?N?`??????X?^?b?N?`???ɕϊ?????
?@?????āA?A???X?^?b?N?`???̃f?[?^???X?^?b?N?`???ɕϊ???????@?????Ă????܂??傤?B??????́A?s?{?b?g?e?[?u???ł͂ł??܂???BTOCOL?????g???Ĕz???1??̃f?[?^?ɕϊ????܂??BTOCOL????Excel 2019?ȑO?ł͎g???܂???B?m???сi?A???X?^?b?N?`???j?n???[?N?V?[?g???J???Ď????Ă݂Ă????????B
?}9?@TOCOL???𗘗p???ăX?^?b?N?`?????A???X?^?b?N?`???ɕϊ?????TOCOLS???̈????ɂ́A?z??Ƃ???B4:C11???w?肷??B??2?????ɂ͖???????l???w?肷??B0???w?肷??ƑS?Ă̒l??ΏۂƂ???i?w??ł???l?ɂ??Ă͍Ō?Ɍf?ڂ??????̌`?????Q?Ɓj?B?Ō?̈????͔z??c?????Ƀf?[?^?????o???ė?ɂ??邩?A???????Ƀf?[?^?????o???ė?ɂ??邩???w?肷??BTRUE???w?肷??Əc?????Ƀf?[?^?????o???̂ŁA???̗?ł???A?Z??B4?`B11?̒l?????o???A???ɃZ??C4?`C11?̒l???Ȃ???1??Ƃ???B????AFALSE???w?肷??Ɖ??????Ƀf?[?^?????o???̂ŁA?Z??B4?`C4?̒l?????o???A???ɃZ??B5?`C5?̒l???A???̎??ɃZ??B6?`C6?̒l???c?c?Ƃ??????ŃZ??B11?`C11?̒l?܂ł??Ȃ??ł????A1??Ƃ???B
?@?}9?Ɏ?????????̎菇?͈ȉ??̒ʂ?ł??B
- ?Z??G4??=TOCOL(B4:C11,0,TRUE)?Ɠ??͂???
?@E???F??ɂ??Ă͎??Ƃœ??͂??Ă??\???܂??A?ȉ??̂悤?Ɋ????g???ē??͂???̂??????I?ł??B?T???v???t?@?C???ɂ͈ȉ??̂悤?Ȋ??????͂???Ă???̂Ŋm?F???Ă݂Ă????????B
Excel?̏ꍇ
- ?Z??E4?F =A4:A11
- ?Z??E12?F =A4:A11
- ?Z??F4?F ???炩???߃Z??F4?`F11??I?????Ă???=B3?Ɠ??͂??A???͏I?????ɁmCtrl?n?{?mShift?n+?mEnter?n?L?[??????
- ?Z??F12?F ???炩???߃Z??F12?`F19??I?????Ă???=B4?Ɠ??͂??A???͏I?????ɁmCtrl?n?{?mShift?n+?mEnter?n?L?[??????
?@?Z??E4?ƃZ??E12?ɂ́A??????z???Ƃ??ē??͂??܂??B????????A???炩???ߑI???????͈͂ɓ????l??\?????邱?Ƃ??ł??܂??B?????l???J??Ԃ??ĕ\??????ɂ?EXPAND???Ȃǂ??g?????@??????܂????A?z???Ƃ??ē??͂?????????Ԃ???????Ȃ????Ǝv???܂??B
Google?X?v???b?h?V?[?g?̏ꍇ
- ?Z??E4?F =ARRAYFORMULA(A4:A11)
- ?Z??E12?F =ARRAYFORMULA(A4:A11)
F??ɂ??ẮAARRAYFORMULA???ł͂??܂??????Ȃ??̂ŁA?ȉ??̕??@???g???܂??BExcel?ł????????@???g???܂??B
Google?X?v???b?h?V?[?g??Excel?ŗ??p?\?ȁi??⍂?x?ȁj???@
- ?Z??F4?F =MAKEARRAY(16,1,LAMBDA(row,col,IF(row<9,B3,C3)))
?@MAKEARRAY????LAMBDA???ł̌v?Z?ɂ??A?w?肵???s???A?ɔz????쐬???邽?߂̊??ł??B?ŏ??́u16,1?v??16?s1??̔z??????Ƃ????Ӗ??ł??BLAMBDA???Ɏw?肵??row??col?͍s?ʒu?Ɨ?ʒu??\???ϐ??ŁA?????ōD???ȕϐ?????t???邱?Ƃ??ł??܂??B???̌?Ɏw?肵????????row??col???g?????v?Z?ł??B?Ⴆ?Arow?̒l??9?????̂Ƃ??́uIF(row<9,B3,C3)?v??B3?̒l?i?u?p??v?j??Ԃ??Arow?̒l??9?ȏ??̂Ƃ??ɂ?C3?̒l?i?u???w?v?j??Ԃ??Ƃ????킯?ł??B
?R?????@???ڂ̌J??Ԃ????x???????????ꍇ?̎?舵??
?@????܂ŁA?J??Ԃ??̃??x????1?̗?????Ă??܂????B????Ƀ??x?????????Ȃ?ꍇ??????܂??B??̓I?ɂ͐}10?̂悤?ȗ?ł??B?p??Ɛ??w?̎?????2??s???Ă??āA??1??̐??тƑ?2??̐??т??L?^????Ă???ꍇ?ł??ˁB???̂悤?ȏꍇ?ł??l?????͑S???????ł??B
?}10?@?A???X?^?b?N?`???ɕϊ?????i?J??Ԃ????????̃??x???̏ꍇ?j?????̉??J??Ԃ??ɂȂ??Ă???A????ɉȖڂ??J??Ԃ??ɂȂ??Ă???BWRAPCOLS???ɂ͐??т͈̔͂ł???D4:D35?ƁA?܂?Ԃ??????w?肷??B?܂?Ԃ?????COUNT???ŋ??߂Ă??邪?A?ڎ??Łu8?v?Ǝw?肵?Ă??悢?B
?@?T???v???t?@?C???́m???сi2??j?n???[?N?V?[?g?ɐ}10?̗?ƁA?s?{?b?g?e?[?u?????g???ĕϊ???????A?????=TOCOL(G5:J12,0,TRUE)?Ɠ??͂??ăA???X?^?b?N?`??????X?^?b?N?`???ɕϊ?????????܂߂Ă???܂??B?m???сi2??j?n???[?N?V?[?g?͍쐬??̍Ō?i???[?N?V?[?g?̉E?[?̃^?u?j?ɂ???܂??B?Ȃ??A???o???ɂ??Ă͑S?Ċ????g???č쐬???Ă??܂????A???̒??x?Ȃ???Ƃœ??́^?R?s?[???č쐬???Ă??\???܂???B
CSV?t?@?C???̕????????ɑΏ?????
?@Excel?ł́A.xls??.xlsx?Ȃǂ?Excel?Ǝ??̃t?@?C???????łȂ??ACSV?t?@?C???Ȃǂ??ǂݍ??߂܂??B?I?[?v???f?[?^?ɂ?CSV?t?@?C???̌`???Œ???Ă?????̂???????????܂??BCSV?t?@?C???͍??ڂ??J???}?ŋ??ꂽ?P?Ȃ?e?L?X?g?t?@?C???ł????A?????R?[?h?ɂ???Ă͂??܂??ǂݍ??߂Ȃ??i????????????j?ꍇ??????܂??B?ȉ??ɁA?悭?g???镶???R?[?h?ƁAExcel?œǂݍ??ꍇ?̏?Ԃ??L???Ă????܂??B
- ?V?t?gJIS?F ???????????Ȃ??BWindows 10 ?o?[?W????1903?ȑO?̃??????ł̕W???I?Ȍ`???iANSI?ƕ\?L????Ă???j
- UTF-8?iBOM?Ȃ??j?F ?t?@?C???̐擪?ɓ??{?ꕶ?????܂܂?Ă???ƕ???????????BWindows?̃??????ł̕W???I?Ȍ`??
- UTF-8?iBOM?t???j?F ???????ǂݍ??߂?
?@???݂ł́A?C???^?[?l?b?g?ŕW???I?Ɏg???Ă???UTF-8?̌`????CSV?t?@?C???ɋL?^????Ă??邱?Ƃ??????悤?ł????ABOM?i?o?C?g?I?[?_?[?}?[?N?j?ƌĂ??R?[?h???t?@?C???̐擪?ɕt???Ă??邩???Ȃ????ɂ???Č??ʂ??قȂ?܂??BExcel?ł́ABOM?t???ł???Ƃ????O??Ńf?[?^???ǂݍ??܂??̂ŁABOM???Ȃ??Ɛ}3?̂悤?ɕ??????????܂??i?}11?ɍČf?j?B
?}11?@?t?@?C???╶???R?[?h?Ɋւ??Ă??肪???ȍ???????i?}3???Čf?j???e???M???_?ł́A?????R?[?h??UTF-8?iBOM?Ȃ??j???ƁA?t?@?C???̐擪?ɓ??{?ꕶ????????CSV?t?@?C????Excel?œǂݍ??ꍇ?ɕ??????????Ă??܂??B???炩????BOM?t???ɕϊ????Ă????K?v??????B
?@Excel?ł́A??Ɍf?ڂ????????R?[?h?ȊO?̃t?@?C????ǂݍ??ނƁA?قƂ?ǂ̏ꍇ???????????܂??B????AGoogle?X?v???b?h?V?[?g?ł́A??Ɍf?ڂ??????̂??܂߂āA?قƂ?ǂ̏ꍇ?A???????ǂݍ??߂܂??B
?@BOM?́AUnicode?ƌĂ?镶???R?[?h?ŁA???o?C?g?????̉??ʃo?C?g????ʃA?h???X?ɔz?u????i?r?b?O?G???f?B?A???j???A???ʃo?C?g?????ʃA?h???X?ɔz?u????i???g???G???f?B?A???j??????ʂ???Ȃǂ̖????????R?[?h?ł??BUTF-8??Unicode?̈??ł????A????BOM?͕K?v?Ƃ???Ă??܂???B???????A?A?v???P?[?V?????̎d?l?Ȃǂɂ???āABOM???t??????ꍇ??????܂??BUTF-8?̏ꍇ?ABOM??16?i????EF BB BF?ƂȂ??Ă??܂??B
?@UTF-8?iBOM?Ȃ??j?̃t?@?C????UTF-8?iBOM?t???j?ɕϊ?????ɂ́AWindows?̏ꍇ?̓??????ŕۑ??????????@???ȒP?ł??i?}12?j?BUTF-8?iBOM?Ȃ??j?̃T???v???t?@?C??????????????_?E?????[?h???Ď????Ă݂Ă????????BGoogle?X?v???b?h?V?[?g?ł?UTF-8?iBOM?Ȃ??j?̃t?@?C???𐳂????J????̂ŁA?T???v???t?@?C???͗p?ӂ??Ă??܂???B
?@?ȉ??̑???ƁA???̍??̋??ʒu?̕ύX?̑???ɂ??ẮA??????p?????Ă???܂??B?菇???????J?ɒǂ????????????͂??Ђ??????????????B
????3?@Excel??CSV?t?@?C???i?J???}?^?^?u?^?X?y?[?X?????܂ށj??ǂݍ??ނɂ?
?}12?@?????????g???ăt?@?C????UTF-8?iBOM?t???j?ŕۑ??????T???v???t?@?C?????J???ɂ́A?????????N?????āA?G?N?X?v???[???[???烁?????̃E?C???h?E?Ƀt?@?C?????h???b?O????̂??????葁???B?t?@?C?????ǂݍ??߂???A???j???[?o?[????m?t?@?C???n-?m???O??t???ĕۑ??n??I?????A?m???O??t???ĕۑ??n?_?C?A???O?{?b?N?X?́m?G???R?[?h?n???X?g????mUTF-8?iBOM?t???j?n??I?????ĕۑ?????B?ۑ??????t?@?C????Excel?ŊJ???ΐ??????\???????B
?@macOS?ł?mi??Sublime Text?Ȃǂ̃e?L?X?g?G?f?B?^???g???ĕۑ??????????Ƃ??ł??܂????A????????W???̃A?v???P?[?V?????ł͂Ȃ??̂ŁA?????̃A?v???P?[?V???????Ȃ??ꍇ?́A?^?[?~?i??????}13?̂悤?ɃR?}???h????͂???̂??????葁?????@?ł??B
?}13?@?^?[?~?i???̃R?}???h?g???ăt?@?C????UTF-8?iBOM?t???j?ŕۑ??????u%?v??荶?̓v?????v?g?i???͂???ʒu?Ȃǂ???????????j?Ȃ̂Łu%?v?̉E????R?}???h????͂???B?܂??Acd?R?}???h?ŁAUTF-8?iBOM?Ȃ??j?̃t?@?C????????ꏊ????ƃt?H???_?[?Ƃ???B???ɁAecho?R?}???h???g???āABOM???????L?^???ꂽ?t?@?C???ibom.txt?j???쐬????Becho?R?}???h?͕?????????̂܂ܕ\??????R?}???h?B-n?́A?Ō?ɉ??s??????t?????Ȃ??Ƃ????w??B\x??16?i???ŕ????R?[?h???w?肷??Ƃ????Ӗ??i\?́AmacOS?ł́moption?n?{?m¥?n?œ??͂???j?B?u>?v?͏o?͌??ʂ??t?@?C???ɕۑ????邽?߂̎w??B?Ō?ɁAcat?R?}???h???g???ăt?@?C????A??????Bbom.txt??BOM?Ȃ??̌??̃t?@?C???i?????ł?16c_utf8.csv?j???w?肵?A?A?????????ʂ??u>?v???g???ăt?@?C???i16c_utf8_bom.csv?j?ɕۑ?????BBOM???t?????ꂽ16c_utf8_bom.csv??Excel?ŊJ???ΐ??????\???????B
???ڂ????܂?????Ȃ??ꍇ?̑Ώ??@
?@CSV?t?@?C???͕????ʂ荀?ڂ??J???}?ŋ??ꂽ?t?@?C???ł????A?ꍇ?ɂ???Ă̓X?y?[?X??^?u?ŋ??ꂽ?e?L?X?g?t?@?C???ɂȂ??Ă??邱?Ƃ?????܂??B???̂悤?ȏꍇ?A?s?S?̂?1?̃Z???ɓǂݍ??܂?邱?Ƃ?????܂??B???????ǂݍ??ނɂ́A?m?f?[?^?n?^?u?́m???ʒu?n?{?^?????g???āA?t?B?[???h?i???ځj?̋????w?肵?܂??i?}14?j?B
?@?T???v???t?@?C??????????????_?E?????[?h???Ď????Ă݂Ă????????BGoogle?X?v???b?h?V?[?g???g???????ꍇ?́A?T???v???t?@?C????Google?h???C?u?ɃA?b?v???[?h???Ă???A??q?̎菇?ɏ]???ĊJ???Ă????????B
?}14?@?t?B?[???h?̋???ύX?????X?y?[?X??^?u?Ńt?B?[???h??????Ă???e?L?X?g?t?@?C?????J???ƁA?s?S?̂?1?̃Z???ɓǂݍ??܂??B?m?f?[?^?n?^?u?́m???ʒu?n?{?^???iMicrosoft 365?I?????C???łł͊Y???Z????I????????ԂŁm?e?L?X?g???ɕ???????n?{?^???j???N???b?N???āA??蕶?????w?肷??A?????̗?ɕ????邱?Ƃ??ł???B?m?X?y?[?X?ɂ???ĉE?܂??͍??ɑ?????ꂽ?Œ蒷?t?B?[???h?̃f?[?^?n?́A?e?t?B?[???h???????????ɂȂ?悤?ɒ???????Ă???f?[?^?̏ꍇ?ɁA???ʒu???w?肵?ăt?B?[???h?????̂Ɏg???B
?@Excel?ł̎菇?͐}14?Ɏ??????ʂ?ł??BGoogle?X?v???b?h?V?[?g?̏ꍇ?͈ȉ??̂悤?ɑ??삵?܂??B
Google?X?v???b?h?V?[?h?̏ꍇ
- Google?h???C?u?ɕۑ????ꂽCSV?t?@?C?????E?N???b?N???āA?m?A?v???ŊJ???n-?mGoogle?X?v???b?h?V?[?h?n??I??????
- ?Z??A1?`A2??I??????
- ???j???[?o?[????m?f?[?^?n-?m?e?L?X?g???ɕ????n???N???b?N????
- ?I??͈͂̉E???Ɂm??蕶???n?Ƃ????|?b?v?A?b?v?\?????????̂ŁA?m?????I?Ɍ??o?n?ƕ\??????Ă??郊?X?g????m?X?y?[?X?n??I??????
?R?????@Web?y?[?W?̕\??ǂݍ???
?@Web?y?[?W?ȂǂŌ??J????Ă???f?[?^?̂????AExcel?̃t?@?C????CSV?t?@?C???Ƃ??ă_?E?????[?h?ł?????̂́A?_?E?????[?h???????̂????̂܂܊J?????Ƃ??ł??܂??B???????AWeb?y?[?W??ɕ\??????Ă???\??Excel?Ɏ?荞?݂????ꍇ??????Ǝv???܂??B???????A??????̏ꍇ?????p?Ɋւ??Ă͂??ꂼ???Web?T?C?g?ł̗??p?K??????K?v??????܂??B
?@Web?u???E?U?[?ɕ\?????ꂽ?\??I?????ăR?s?[???AExcel?̃??[?N?V?[?g?ɓ\??t????Ƃ??????@?́A???܂?X?}?[?g?Ƃ͌????܂???ˁi?\?????ꂽ?肷?邱?Ƃ??悭????܂??j?BExcel?f?X?N?g?b?v?ł́m?f?[?^?n?^?u?ɂ͂??܂??܂ȃf?[?^??ǂݍ??ނ??߂̃{?^????????̂ŁA????𗘗p???܂??傤?B?Ȃ??AGoogle?X?v???b?h?V?[?g??Microsofot 365?I?????C???łɂ͑S???????@?\?͂???܂???i???????AGoogle?X?v???b?h?V?[?g?ł?IMPORTHTML????Web?y?[?W?̃f?[?^??ǂݍ??ނ??Ƃ??ł??܂??B?ڍׂɂ??Ă?Google?X?v???b?h?V?[?g?̃w???v?????Q?Ƃ????????j?B
?@?}15?͋C?ے??Œ???Ă??閈???̋C?ۃf?[?^?iURL?Fhttps://www.data.jma.go.jp/stats/data/mdrr/synopday/data1s.html?j?ł????A?????Excel?Ɏ?荞??ł݂܂??B
?}15?@?C?ے??̃y?[?W?Œ???Ă??閈???̋C?ۃf?[?^?S???̋C?ۃf?[?^???ꗗ?ɂ????y?[?W?i2024?N3??15??12?????݂̃f?[?^?j?B?e?n?_?̋C?ۂ??L?^?????\??5?ƁA?}??Ȃǂ̕\??4?܂܂?Ă???i?????ڂ͕\?ɂȂ??Ă??Ȃ????A?\?Ƃ??Ē?`????Ă?????̂?????j?B???̂????̍ŏ??̕\?i?D?y?`?Ί??j??Excel?ɓǂݍ???ł݂悤?B
?@????͊ȒP?ł??B?}15?̂悤?Ɂm?f?[?^?n?^?u???J???A?mWeb????n?{?^?????N???b?N???܂??BURL????͂???AWeb?y?[?W?Ɋ܂܂??\???ꗗ?\???????̂ŁA???̒?????ړI?̕\??I?????邾???ł??B
?}16?@?????̋C?ۃf?[?^??Web?y?[?W????Excel?ɓǂݍ????m?i?r?Q?[?^?[?n?E?C???h?E?Ńv???r???[?????Ȃ???ǂݍ??݂????\???I???ł???B?E???̉?ʂŁmWeb?r???[?n?^?u???J???ƁAWeb?y?[?W?ł̕\?????m?F?ł???B?m?ǂݍ??݁n?{?^?????N???b?N????A???̂܂?Excel?̃??[?N?V?[?g?Ƀf?[?^???ǂݍ??܂??B?܂??m?f?[?^?̕ϊ??n?{?^?????N???b?N????APower Query?ƌĂ??E?C???h?E???\??????A?ǂݍ??ޑO?Ƀf?[?^?̉??H???ł???B
?@?}16?̕??@?́AWeb?y?[?W?̕\?????łȂ??A?C???^?[?l?b?g?o?R??JSON?t?@?C????XML?t?@?C????ǂݍ??ނ̂ɂ??g???܂??B???????AJSON?t?@?C????XML?t?@?C???̃f?[?^?͊K?w?I?ȍ\???ɂȂ??Ă???̂ŁAPower Query?̉?ʂŊK?w?????ǂ??ăf?[?^??I??????K?v??????܂??BPower Query?ɂ?邱???̃f?[?^?̗??p?ɂ??ẮA?A?ڂ̃e?[?}????b????i???j??Ă??܂??̂ŁA??????̌????L???Ȃǂ????Q?Ƃ????????B
?@????́A?f?[?^???͈ȑO?ɍl?????ׂ??f?[?^?̌`????t?@?C???̌`???ɂ??āA????̗???g???u???V???[?e?B???O?I?ɏЉ?܂????B
?@???ۂ̃f?[?^???͂ɓ??????ẮA?s???̎?̑I???A???בւ??Ȃǂ??K?v?ɂȂ?܂????A???????Excel?̊?{?I?ȋ@?\?őΉ??ł??܂??B???̃f?[?^???C???M?????[?Ȍ`???ł??????ꍇ?Ɍ`???𐮂???ɂ́A???Ƃł̑Ή????K?v?ɂȂ邩??????܂??AExcel?̋@?\????𗘗p?????????x?̎????????ł??邩?Ǝv???܂??B?f?[?^??K?Ȍ`???ɂł???A???̘A?ڂŌ??Ă??????͂̂??߂̋@?\??c?[?????X???[?Y?ɓK?p?ł???悤?ɂȂ?܂??B
?@?Ƃ????킯?ŁA?f?[?^???͂̋L?q???v?҂͍??ŏI??ł??B?????āA?m?????z?҂Ɛ??????v?҂????????Ă??܂??̂ŁA?ǂ??????y???݂ɁI
?????t?@?????X?F ???̋L???Ŏ??グ?????̌`??
?@???̗??p??ɂ??ẮA???̋L???̒??ŏЉ?Ă???ʂ?ł??B?????ł́A??????グ?????̊?{?I?ȋ@?\?ƈ????̎w????@???????????Ă????܂??B
?z??𑀍삷?邽?߂̊?
WRAPCOLS???F ?s?܂??͗?̃f?[?^???w?肵?????Ő܂?Ԃ??A?????̗?Ƃ??ĕԂ?
?`??
WRAPCOLS(?x?N?g??, ??, [???ߍ??ޒl])
????
- ?x?N?g???F 1?s?܂???1??̃f?[?^?̕??сB
- ???F ?????Ƃɐ܂?Ԃ??????w?肷??B
- ???ߍ??ޒl?F ???̒l?????݂??Ȃ??Ƃ??ɖ??ߍ??ޒl???w?肷??B????l??#N/A?B
???l
?@?܂?Ԃ?????3?Ƃ??A???ߍ??ޒl??????l?Ƃ????ꍇ?A?ȉ??̂悤?ɂȂ?B
?@?Ȃ??A???̊??Ǝ????@?\??????WRAPROWS???ł́A?s?܂??͗?̃f?[?^???w?肵?????Ő܂?Ԃ??ĕ????̍s?Ƃ??ĕԂ??B
?@WRAPROWS???́AExcel 2019?ȑO?ł͎g???Ȃ??B
TOCOL???F ?z???1??ɂ???
?`??
TOCOL(?z??, ?m????????l?n, ?m?????n)
????
- ?z??F 1??ɂ??????z??B
- ????????l?F ?ȉ??̒l???w?肷??B
- 0?܂????ȗ? ?c?c ?S?Ă̒l??ێ?????
- 1 ?c?c ??????
- 2 ?c?c ?G???[??????
- 3 ?c?c ?ƃG???[??????
- ?????F ???????Ƀf?[?^???擾???邩?c?????Ƀf?[?^???擾???邩???ȉ??̒l?Ŏw?肷??B
- TRUE ?c?c ?c?????Ƀf?[?^???擾????
- FALSE?܂????ȗ? ?c?c ???????Ƀf?[?^???擾????
???l
?@?????̎w??ɂ??A?ȉ??̂悤?Ȍ??ʂɂȂ?B?Ȃ??A?m????????l?n??1???w?肷??ƁA7?s?ڂ́u0?v?͕\??????Ȃ??B
?@?Ȃ??A???̊??Ǝ????@?\??????TOROW???ł́A?z???1?s?ɂ???B
?@TOCOL???́AExcel 2019?ȑO?ł͎g???Ȃ??B
MAKEARRAY???F LAMBDA???̌v?Z?ɂ??z????쐬????
?`??
MAKEARRAY?i?s??, ??, LAMBDA(?s??\???ϐ?, ???\???ϐ?, ???j
????
- ?s???F ?쐬???????z??̍s???B
- ?F ?쐬???????z??̗B
- ?s??\???ϐ??F ?z????̍s?ʒu??\???ϐ????i?C?ӂ̖??O?j???w?肷??B
- ???\???ϐ??F ?z????̗?ʒu??\???ϐ????i?C?ӂ̖??O?j???w?肷??B
- ???F ?s??\???ϐ??Ɨ??\???ϐ????g???Čv?Z???邽?߂̎????w?肷??B
???l
?@LAMBDA???́A?ϐ??Ƃ??̌v?Z?̕??@???`???邽?߂̊??i??q?j?B?Ⴆ?A?u=LAMBDA(x, y, x+y)(1, 2)?v?Ƃ???ƁAx??1?Ay??2?????????Ax+y?̒l???Ԃ????BMAKEARRAY???̒??Ɏw?肵???ꍇ?ɂ́A?z????̍s?ʒu?Ɨ?ʒu??LAMBDA???̍s??\???ϐ??Ɨ??\???ϐ??ɓn?????B
LAMBDA???F ????̊?????邽?߂̊?
?`??
LAMBDA?i????1, ????2, ..., ???j
????
- ????1, ????2, ...?F ???ɗ^????????ɑΉ?????ϐ??????`????B
- ???F ?ϐ????g?????v?Z?̕??@???w?肷??B
???l
?@?Ⴆ?A?u=LAMBDA(x, y, x+y)?v?ł???A?ŏ???x?ɑ?1?????̒l???n????Ay?ɑ?2?????̒l???n?????B?Ō??x+y?̒l???????Ƃ??ĕԂ????B?]???āA?Z???Ɂu=LAMBDA(x, y, x+y)(A1,A2)?v?Ɠ??͂???ƁA?Z??A1?̒l??x?ɓn????A?Z??A2?̒l??y?ɓn????Ax+y?̒l?܂?A1??A2?̘a???Ԃ????B????ɁA???O?@?\?𗘗p???āu=LAMBDA(x, y, x+y)?v??myadd?Ƃ????????O??t???Ă???A?u=myadd(A1, A2)?v?ŃZ??A1?ƃZ??A2?̘a?????߂???B???̂悤?ɂ??Ċ???????ł???B
?u?₳?????f?[?^?????v
Copyright© Digital Advantage Corp. All Rights Reserved.
?A?C?e?B???f?B?A????̂??m?点
??IT eBook
???ڂ̃e?[?}
?ҏW??????̂??m?点
RSS?ɂ???
?A?C?e?B???f?B?AID?ɂ???
???[???}?K?W???o?^
??IT?̃??[???}?K?W???́A ???????A???ׂĖ????ł??B???Ѓ??[???}?K?W???????w?ǂ????????B
ITmedia?̓A?C?e?B???f?B?A??????Ђ̓o?^???W?ł??B
???f?B?A?ꗗ | ????SNS | ?L???ē? | ???₢???킹 | ?v???C?o?V?[?|???V?[ | RSS | ?^?c??? | ?̗p??? | ??????