{"id":4206,"date":"2026-10-26T17:10:20","date_gmt":"2026-10-26T08:10:20","guid":{"rendered":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/?p=4206"},"modified":"2026-10-31T13:02:10","modified_gmt":"2026-10-31T04:02:10","slug":"post-4206","status":"publish","type":"post","link":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/2026\/10\/post-4206.html","title":{"rendered":"\uff08\uff15\uff14\uff13\uff09Excel\u3067\u3061\u3087\u3046\u3069\u771f\u3093\u4e2d\u306e\u6570\u5024\u304c\u5206\u304b\u308b\u65b9\u6cd5\uff5eMEDIAN\u95a2\u6570\uff5e"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u307f\u306a\u3055\u307e\u3001\u3053\u3093\u306b\u3061\u306f\u3002<br>\u30e2\u30ab\u3067\u3059\u3002<br>\u304a\u5143\u6c17\u3067\u3059\u304b\uff1f<br><br>\u904b\u52d5\u4f1a\u30b7\u30fc\u30ba\u30f3\u5230\u6765\uff01\u3000<br>\u96e8\u3067\u5ef6\u671f\u306e\u3068\u3053\u308d\u3082\u3042\u308b\u3088\u3046\u3067\u3059\u304c\u3001\u3059\u3063\u304d\u308a\u79cb\u6674\u308c\u306e\u7a7a\u306e\u4e0b\u3060\u3068\u3001\u6c17\u6301\u3061\u304c\u826f\u3044\u3067\u3059\u3088\u306d\u266a<br><br>\u3061\u306a\u307f\u306b\u3001\u308f\u305f\u3057\u306f\u3001\u679c\u7269\u304c\u7f8e\u5473\u3057\u304f\u3063\u3066\u3001\u5b09\u3057\u3044\u4eca\u65e5\u3053\u306e\u3054\u308d\u266a<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"712\" height=\"758\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi7.jpg\" alt=\"\" class=\"wp-image-4223\" srcset=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi7.jpg 712w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi7-282x300.jpg 282w\" sizes=\"auto, (max-width: 712px) 100vw, 712px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<h2 id=\"block-372b7a3c-e54f-4a47-b1bd-0a82b6fd8b44\" class=\"wp-block-heading\">Excel\u3067\u3061\u3087\u3046\u3069\u771f\u3093\u4e2d\u306e\u6570\u5024\u304c\u5206\u304b\u308b\u65b9\u6cd5\uff5eMEDIAN\u95a2\u6570\uff5e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u3067\u306f\u3001AVERAGE\u95a2\u6570\u3092\u4f7f\u3063\u3066\u300c\u5e73\u5747\u300d\u3092\u6c42\u3081\u3066\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3057\u305f\u308a\u3057\u307e\u3059\u3088\u306d\u3002<br>\u3067\u3082\u3001\u5e73\u5747\u3060\u3068\u3001\u6570\u5024\u304c\u98db\u3073\u306c\u3051\u3066\u5927\u304d\u3044\uff08\u307e\u305f\u306f\u5c0f\u3055\u3044\uff09\u3082\u306e\u304c\u3042\u3063\u305f\u5834\u5408\u306f\u3001\u5e73\u5747\u5024\u306f\u3001\u3042\u3093\u307e\u308a\u201d\u5f53\u3066\u201d\u306b\u306a\u3089\u306a\u3044\u3001\u3068\u3044\u3046\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3088\u306d<br><br>\u305d\u3053\u3067\u4eca\u56de\u306f\u3001\u300c\u4e2d\u592e\u5024\u300d\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u95a2\u6570\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<br>\u5e73\u5747\u3088\u308a\u3082\u3001\u3061\u3087\u3046\u3069\u771f\u3093\u4e2d\u306e\u6570\u5024\u304c\u628a\u63e1\u3067\u304d\u308b\u306e\u3067\u5206\u6790\u3057\u3084\u3059\u3044\u3067\u3059\u3002<br><br><br>\uff11\uff0e<strong>\u300c\u4e2d\u592e\u5024\u300d<\/strong>\u3092\u6c42\u3081\u308b\u524d\u306b\u3001\u53c2\u8003\u306b<strong>\u300c\u5e73\u5747\u300d<\/strong>\u3092\u6c42\u3081\u3066\u304a\u304d\u307e\u3059\u3002<strong>\u300c\u30aa\u30fc\u30c8SUM\u300d<\/strong>\u306e\u25bc\u304b\u3089<strong>\u300c\u5e73\u5747\u300d\u3092\u62bc\u3057<\/strong>\u3001\u9752\u67a0\u90e8\u5206\u3092<strong>\u7bc4\u56f2\u9078\u629e\u3057\u300cOK\u300d<\/strong>\u3092\u62bc\u3059\u3068\u3001\u5e73\u5747\u306f\u3001<strong>\u300c\uff12\uff10\uff15\uff11\u300d<\/strong>\u3068\u51fa\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"598\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi6.jpg\" alt=\"\" class=\"wp-image-4217\" srcset=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi6.jpg 977w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi6-300x184.jpg 300w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi6-768x470.jpg 768w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uff12\uff0e\u6b21\u306b<strong>\u300c\u4e2d\u592e\u5024\u300d<\/strong>\u3092\u6c42\u3081\u307e\u3059\u3002\u4e2d\u592e\u5024\u3092\u8868\u793a\u3057\u305f\u3044\u30bb\u30eb\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u7f6e\u3044\u3066\u3001<strong>fx\u30dc\u30bf\u30f3<\/strong>\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"489\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi2.jpg\" alt=\"\" class=\"wp-image-4211\" srcset=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi2.jpg 427w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi2-262x300.jpg 262w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uff13\uff0e<strong>\u300cMEDIAN\u300d<\/strong>\u3092\u9078\u629e\u3057\u3066<strong>\u300cOK\u300d<\/strong>\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"833\" height=\"489\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi3.jpg\" alt=\"\" class=\"wp-image-4213\" srcset=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi3.jpg 833w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi3-300x176.jpg 300w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi3-768x451.jpg 768w\" sizes=\"auto, (max-width: 833px) 100vw, 833px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br>\uff14\uff0e\u5148\u307b\u3069\u3068<strong>\u540c\u3058\u7bc4\u56f2\u3092\u9078\u629e<\/strong>\u3057\u3066<strong>\u300cOK\u300d<\/strong>\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"494\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi4.jpg\" alt=\"\" class=\"wp-image-4214\" srcset=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi4.jpg 985w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi4-300x150.jpg 300w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi4-768x385.jpg 768w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br>\uff15\uff0e<strong>\u300c\u4e2d\u592e\u5024\u300d<\/strong>\u306f\u3001<strong>\u300c\uff12\uff10\uff14\uff15\u300d<\/strong>\u3068\u51fa\u307e\u3057\u305f\u3002\u3061\u3087\u3046\u3069\u771f\u3093\u4e2d\u306e\u6570\u5024\uff08\u4e2d\u592e\u5024\uff09\u3063\u3066\u3001\u5e73\u5747\u3088\u308a\u3082\u4f4e\u3044\u3067\u3059\u306d\uff01\u3000<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"506\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi5.jpg\" alt=\"\" class=\"wp-image-4215\" srcset=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi5.jpg 449w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi5-266x300.jpg 266w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\u3010\u8ffd\u52a0\u3011\u2193\u3053\u3093\u306a\u304b\u3093\u3058\u3067\u3001\u307e\u3060\u7a7a\u6b04\u304c\u3042\u308b\u5834\u5408\u306f\u300c\u5e73\u5747\u300d\u3088\u308a\u300c\u4e2d\u592e\u5024\u300d\u304c\u30d9\u30b9\u30c8\uff01\u3067\u3059\u3088\u306d<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"450\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi8.jpg\" alt=\"\" class=\"wp-image-4236\" srcset=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi8.jpg 735w, https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2026\/10\/medi8-300x184.jpg 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"block-4e58e34e-f9ff-4e1d-836e-8f63191b5b15\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"block-4e58e34e-f9ff-4e1d-836e-8f63191b5b15\"><br>\u3044\u304b\u304c\u3067\u3057\u305f\u304b\uff1f<br><br>\u4eca\u56de\u306f\u3001\u6c34\u5206\u91cf\u3069\u308c\u304f\u3089\u3044\u6442\u308c\u3066\u3044\u308b\u304b\u3001\u3068\u3044\u3046\u30c7\u30fc\u30bf\u3067\u3001\u4e2d\u592e\u5024\u304c\u5206\u304b\u308b\u3068\u3001\u3060\u3044\u305f\u3044\u3053\u308c\u304f\u3089\u3044\u6442\u308c\u3066\u308b\u3001\u3068\u5206\u304b\u3063\u3066\u3001\u3088\u308a\u5b89\u5fc3\u266a<br><br>\u305c\u3072\u3001\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u307f\u306a\u3055\u307e\u3001\u3053\u3093\u306b\u3061\u306f\u3002\u30e2\u30ab\u3067\u3059\u3002\u304a\u5143\u6c17\u3067\u3059\u304b\uff1f \u904b\u52d5\u4f1a\u30b7\u30fc\u30ba\u30f3\u5230\u6765\uff01\u3000\u96e8\u3067\u5ef6\u671f\u306e\u3068\u3053\u308d\u3082\u3042\u308b\u3088\u3046\u3067\u3059\u304c\u3001\u3059\u3063\u304d\u308a\u79cb\u6674\u308c\u306e\u7a7a\u306e\u4e0b\u3060\u3068\u3001\u6c17\u6301\u3061\u304c\u826f\u3044\u3067\u3059\u3088\u306d\u266a \u3061\u306a\u307f\u306b\u3001\u308f\u305f\u3057\u306f\u3001\u679c\u7269\u304c\u7f8e\u5473\u3057\u304f\u3063\u3066\u3001\u5b09\u3057\u3044\u4eca\u65e5\u3053\u306e\u3054\u308d\u266a E [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4223,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,7],"tags":[],"class_list":["post-4206","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-3","category-7"],"_links":{"self":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/4206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/comments?post=4206"}],"version-history":[{"count":15,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/4206\/revisions"}],"predecessor-version":[{"id":4238,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/4206\/revisions\/4238"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media\/4223"}],"wp:attachment":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media?parent=4206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/categories?post=4206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/tags?post=4206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}