{"id":4860,"date":"2021-08-08T20:53:56","date_gmt":"2021-08-08T11:53:56","guid":{"rendered":"https:\/\/hobby.mydns.jp\/teruki.wp\/?p=4860"},"modified":"2021-08-08T20:59:50","modified_gmt":"2021-08-08T11:59:50","slug":"post-4860","status":"publish","type":"post","link":"https:\/\/hobby.mydns.jp\/teruki.wp\/2021\/08\/08\/post-4860\/","title":{"rendered":"Excel\u3000\u30c7\u30fc\u30bf\u96c6\u8a08\u95a2\u6570"},"content":{"rendered":"<p>\u65e5\u5831\u306a\u3069\u3067\u4f7f\u3048\u308b\u3001\u9805\u76ee\u3068\u5de5\u6570\u306e\u96c6\u8a08\u306b\u3064\u3044\u3066\u3001Excel\u3067\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<p>\u3010\u30a8\u30af\u30bb\u30eb\u30b5\u30f3\u30d7\u30eb\u3011<br \/>\n<a href=\"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-content\/uploads\/2021\/08\/syuukei.xlsx\">\u96c6\u8a08\u30a8\u30af\u30bb\u30eb\u30b5\u30f3\u30d7\u30eb<\/a><\/p>\n<p>\u3010\u4ed5\u69d8\u3011<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4867 size-full\" src=\"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-content\/uploads\/2021\/08\/exel.png\" alt=\"\" width=\"466\" height=\"324\" srcset=\"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-content\/uploads\/2021\/08\/exel.png 466w, https:\/\/hobby.mydns.jp\/teruki.wp\/wp-content\/uploads\/2021\/08\/exel-300x209.png 300w\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" \/><br \/>\nA\u5217B\u5217\u306e7\u884c\u76ee\u4ee5\u964d\u306b\u65e5\u5831\u306e\u3088\u3046\u306b\u4f8b\u3048\u3070\u4ed5\u4e8b\u5185\u5bb9\u3068\u305d\u308c\u306b\u8cbb\u3084\u3057\u305f\u5de5\u6570\u3068\u3044\u3046\u5177\u5408\u306b\u8a18\u9332\u3057\u3066\u3044\u3063\u305f\u3068\u3057\u307e\u3059\u3002\u3053\u308c\u30921\u65e5\u304b\u308931\u65e5\u307e\u3067\u8a18\u9332\u3059\u308b\u3068\u3044\u3063\u305f\u3084\u308a\u65b9\u3082\u826f\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n<p>\u96c6\u8a08\u3068\u3057\u3066\u4ee5\u4e0b\u306e\u60c5\u5831\u3092\u77e5\u308b\u306e\u306b\u4fbf\u5229\u306a\u3082\u306e\u3067\u3059\u3002<br \/>\n\u25c6D\u5217E\u5217\u306b\u306f\u3001\u5404\u9805\u76ee\u3054\u3068\u306b\u6642\u9593\u3092\u96c6\u8a08\u3057\u305f\u30ea\u30b9\u30c8\u3092\u751f\u6210\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u25c6A\u5217B\u5217\u306e4\u884c\u76ee\u306b\u306f\u3001\u5404\u9805\u76ee\u3092\u30ea\u30b9\u30c8\u3067\u547c\u3073\u51fa\u3057\u3066\u3001\u305d\u306e\u9805\u76ee\u306e\u5de5\u6570\u3092\u8868\u793a\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3053\u306e2\u3064\u306e\u8868\u793a\u65b9\u6cd5\u304c\u3067\u304d\u308b\u30b5\u30f3\u30d7\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u25c7C\u5217\u306f\u3001D\u5217\u306e\u96c6\u8a08\u7528\u306b\u30d5\u30e9\u30b0\u3092\u7acb\u3066\u3066\u3044\u308b\u305f\u3081\u3001\u3053\u306e\u884c\u306b\u3064\u3044\u3066\u306f\u4ed6\u306e\u884c\u306b\u79fb\u3057\u305f\u308a\u3001\u767d\u6587\u5b57\u3067\u898b\u3048\u306a\u304f\u3057\u3066\u3082\u826f\u3044\u3068\u601d\u3044\u307e\u3059\u3002C\u5217\u306e\u5f79\u5272\u3068\u3057\u3066\u306f\u3001A\u5217\u306e\u5404\u9805\u76ee\u306e\u91cd\u8907\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u3001\u6700\u521d\u306b\u5f15\u3063\u304b\u304b\u3063\u305f\u6587\u5b57\u5217\u304c\u3042\u308b\u884c\u6570\u3092\u62bd\u51fa\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>C7\u306e\u5f0f\uff1a=IF(OR(COUNTIF(A$7:A7,A7)&gt;1,A7=&#8221;&#8221;),&#8221;&#8221;,ROW())<br \/>\n\u3053\u306e\u5f0f\u3092\u30b3\u30d4\u30fc\u3057\u306615\u884c\u76ee\u307e\u3067\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u25c7D\u5217\u306f\u3001C\u5217\u306e\u884c\u6570\u8868\u793a\u304c\u3042\u308b\u3068\u3053\u308d\u306e\u9805\u76ee\u3092\u4e0a\u304b\u3089\u8a70\u3081\u3066\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>D7\u306e\u5f0f\uff1a=@IF(ROW(D1)&gt;COUNT(C:C),&#8221;&#8221;,INDEX(A:A,SMALL(C:C,ROW(D1))))<br \/>\n\u3053\u306e\u5f0f\u3092\u30b3\u30d4\u30fc\u3057\u306615\u884c\u76ee\u307e\u3067\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u25c7E\u5217\u306f\u3001D\u5217\u306b\u8a72\u5f53\u3059\u308b\u9805\u76ee\u306b\u3064\u3044\u3066\u3001A\u5217\u304b\u3089\u62bd\u51fa\u3057\u3001\u8a72\u5f53\u3059\u308bB\u5217\u306e\u5de5\u6570\u306e\u5408\u8a08\u5024\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/p>\n<p>E7\u306e\u5f0f\uff1a=IF(D7=&#8221;&#8221;,&#8221;&#8221;,IF(D7=&#8221;\u3053\u3053\u307e\u3067&#8221;,SUM($B$7:$B$14),SUMIF($A$7:$B$14,D7,$B$7:$B$14)))<br \/>\n\u3053\u306e\u5f0f\u3092\u30b3\u30d4\u30fc\u3057\u306615\u884c\u76ee\u307e\u3067\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u25c7\u30bb\u30ebA4\u306f\u30c7\u30fc\u30bf\u5165\u529b\u898f\u5247\u3092\u4f7f\u3063\u3066\u3001\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u8868\u793a\u3055\u305b\u307e\u3059\u3002<\/p>\n<p>A4\u306e\u30c7\u30fc\u30bf\u5165\u529b\u898f\u5247\uff1a[\u7a2e\u985e]\uff1a\u30ea\u30b9\u30c8\u3001\u7a7a\u767d\u7121\u8996\u3001\u30ea\u30b9\u30c8\u304b\u3089\u9078\u629e<br \/>\n[\u5143\u306e\u5024]\uff1a=OFFSET($D$7,0,0,COUNTIF($D:$D,&#8221;&gt;!&#8221;)-1,1)<\/p>\n<p>\u25c7\u30bb\u30ebB4\u306fA4\u3067\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u3055\u308c\u305f\u9805\u76ee\u306b\u5bfe\u3059\u308b\u5de5\u6570\u306e\u5408\u8a08\u5024\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<p>B4\u306e\u5f0f\uff1a=IF(A4=&#8221;\u3053\u3053\u307e\u3067&#8221;,SUM(B7:B15),SUMIF(A7:B14,A4,B7:B14))<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u65e5\u5831\u306a\u3069\u3067\u4f7f\u3048\u308b\u3001\u9805\u76ee\u3068\u5de5\u6570\u306e\u96c6\u8a08\u306b\u3064\u3044\u3066\u3001Excel\u3067\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002 \u3010\u30a8\u30af\u30bb\u30eb\u30b5\u30f3\u30d7\u30eb\u3011 \u96c6\u8a08\u30a8\u30af\u30bb\u30eb\u30b5\u30f3\u30d7\u30eb \u3010\u4ed5\u69d8\u3011 A\u5217B\u5217\u306e7\u884c\u76ee\u4ee5\u964d\u306b\u65e5\u5831\u306e\u3088\u3046\u306b\u4f8b\u3048\u3070\u4ed5\u4e8b\u5185\u5bb9\u3068\u305d\u308c\u306b\u8cbb\u3084\u3057\u305f\u5de5\u6570\u3068\u3044\u3046\u5177\u5408\u306b\u8a18\u9332\u3057\u3066\u3044 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-4860","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-windows"],"_links":{"self":[{"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/posts\/4860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/comments?post=4860"}],"version-history":[{"count":1,"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/posts\/4860\/revisions"}],"predecessor-version":[{"id":4868,"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/posts\/4860\/revisions\/4868"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/media\/4867"}],"wp:attachment":[{"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/media?parent=4860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/categories?post=4860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hobby.mydns.jp\/teruki.wp\/wp-json\/wp\/v2\/tags?post=4860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}