{"id":83724,"date":"2024-11-04T16:37:59","date_gmt":"2024-11-04T07:37:59","guid":{"rendered":"https:\/\/www.excel-no-mori-blog.jp\/?p=83724"},"modified":"2024-11-04T16:41:51","modified_gmt":"2024-11-04T07:41:51","slug":"%e3%80%90%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e3%80%91sort%e9%96%a2%e6%95%b0%e3%81%ae%e4%bd%bf%e3%81%84%e6%96%b9%e3%80%82%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e7%b8%a6%e6%96%b9%e5%90%91%e3%81%a7","status":"publish","type":"post","link":"https:\/\/www.excel-no-mori-blog.jp\/?p=83724","title":{"rendered":"\u3010\u30a8\u30af\u30bb\u30eb\u3011\u30c7\u30fc\u30bf\u3092\u4e26\u3079\u66ff\u3048\u3059\u308bSORT\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3002\u8907\u6570\u306e\u5217\u3084\u7e26&amp;\u6a2a\u65b9\u5411\u306b\u3082\u53ef\u80fd\uff01"},"content":{"rendered":"\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">Excel(\u30a8\u30af\u30bb\u30eb)\u306b\u306f\u30c7\u30fc\u30bf\u3092\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u300c\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u6a5f\u80fd\u3068\u300c\u4e26\u3079\u66ff\u3048\u300d\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6700\u8fd1\u306b\u306a\u3063\u3066\u3001<span class=\"st-mymarker-s\">\u95a2\u6570\u3067\u3082\u30c7\u30fc\u30bf\u306e\u4e26\u3079\u66ff\u3048<\/span>\u304c\u51fa\u6765\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u306e\u3092\u3054\u5b58\u77e5\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e26\u3079\u66ff\u3048\u306b\u5229\u7528\u3059\u308b\u306e\u306f\u3001<strong><span class=\"st-mymarker-s\">SORT\u95a2\u6570<\/span><\/strong>\u3068\u3044\u3046\u65b0\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306b\u306f\u3001\u300c\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u6a5f\u80fd\u3084\u300c\u4e26\u3079\u66ff\u3048\u300d\u6a5f\u80fd\u306b\u306f\u306a\u3044\u4ee5\u4e0b\u306e<strong>\u30e1\u30ea\u30c3\u30c8<\/strong>\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-st-blocks-my-box st-mybox has-title\" style=\"background-color:#fff;border-color:#066094\"><p class=\"st-mybox-title\" style=\"color:#424242;font-weight:bold;text-shadow:#fff 3px 0px 0px, #fff 2.83487px .981584px 0px, #fff 2.35766px 1.85511px 0px, #fff 1.62091px 2.52441px 0px, #fff .705713px 2.91581px 0px, #fff -0.287171px 2.98622px 0px, #fff -1.24844px 2.72789px 0px, #fff -2.07227px 2.16926px 0px, #fff -2.66798px 1.37182px 0px, #fff -2.96998px .42336px 0px, #fff -2.94502px -0.571704px 0px, #fff -2.59586px -1.50383px 0px, #fff -1.96093px -2.27041px 0px, #fff -1.11013px -2.78704px 0px, #fff -0.137119px -2.99686px 0px, #fff .850987px -2.87677px 0px, #fff 1.74541px -2.43999px 0px, #fff 2.44769px -1.73459px 0px, #fff 2.88051px -0.838246px 0px;background:linear-gradient(0deg, #fff 0%, #fff 55%, rgba(0, 0, 0, 0) 55%, rgba(0, 0, 0, 0) 100%)\"><i class=\"st-fa st-svg-check-circle st-css-no\" aria-hidden=\"\"><\/i>SORT\u95a2\u6570\u306e\u30e1\u30ea\u30c3\u30c8<\/p><div class=\"st-in-mybox\">\n<p>\uff11\uff0e\u5143\u30c7\u30fc\u30bf\u81ea\u4f53\u306f\u4e26\u3079\u66ff\u3048\u305b\u305a\u3001\u4e26\u3079\u66ff\u3048\u5f8c\u306e\u30c7\u30fc\u30bf\u3092\u5225\u306e\u30bb\u30eb\u306b\u4f5c\u6210\u3067\u304d\u308b<\/p>\n\n\n\n<p>\uff12\uff0e\u6a2a\u65b9\u5411\u306b\u3082\u7e26\u65b9\u5411\u306b\u3082\u4e26\u3079\u66ff\u3048\u304c\u53ef\u80fd<\/p>\n\n\n\n<p>\uff13\uff0e\u30c7\u30fc\u30bf\u7bc4\u56f2\u304c\u81a8\u5927\u3067\u3082\u3001SORT\u95a2\u6570\u306e\u633f\u5165\u306f\uff11\u30bb\u30eb\u3060\u3051\u3067\u6e08\u3080<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u306e\u8a18\u4e8b\u3067\u306f\u3001SORT\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u4e8b\u4f8b\u3068\u5408\u308f\u305b\u306a\u304c\u3089\u8a73\u3057\u304f\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u3092\u4f7f\u308f\u305a\u3001\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u4f7f\u3044\u305f\u3044\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel wp-block-embed-excel\"><div class=\"wp-block-embed__wrapper\">\n<div><a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=68151\" class=\"st-cardlink st-embed-cardlink\"><div class=\"kanren st-cardbox\"><dl class=\"clearfix\"><dt class=\"st-card-img\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/06\/excel-filter-setting-howtouse-basic-advanced-1-1000x530.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">\u3010Excel\u57fa\u672c\uff5e\u5fdc\u7528\u7de8\u3011\u30d5\u30a3\u30eb\u30bf\u30fc\u6a5f\u80fd\u306e\u8a2d\u5b9a\u65b9\u6cd5\u3068\u4f7f\u3044\u65b9\u3002\u4e0a\u624b\u304f\u3044\u304b\u306a\u3044\u5834\u5408\u306e\u5bfe\u51e6\u65b9\u6cd5\u3082<\/p><div class=\"st-card-excerpt smanone\"><p>Microsoft Excel(\u30a8\u30af\u30bb\u30eb)\u3067\u8868\u3092\u4f5c\u6210\u3057\u305f\u3068\u304d\u306b\u3001\u300c\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u3068\u547c\u3070\u308c\u308b\u6a5f\u80fd\u3092\u8a2d\u5b9a\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u3092\u4e26\u3079\u66ff &#8230; <\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SORT\u95a2\u6570\u3068\u306f\uff1f<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u8aad\u307f\u65b9\u306f\u3001\u201d\u30bd\u30fc\u30c8\u201d\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u3068\u306f\u3001\u6307\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5225\u306e\u7a7a\u3044\u305f\u30b9\u30da\u30fc\u30b9\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u6a5f\u80fd\u3068\u300c\u4e26\u3079\u66ff\u3048\u300d\u6a5f\u80fd\u306f\u5143\u30c7\u30fc\u30bf\u81ea\u4f53\u304c\u4e26\u3079\u66ff\u3048\u3055\u308c\u307e\u3059\u304c\u3001SORT\u95a2\u6570\u306f\u5143\u30c7\u30fc\u30bf\u306f\u305d\u306e\u307e\u307e\u3067\u3001<span class=\"st-mymarker-s\"><strong>\u7570\u306a\u308b\u5834\u6240\u306b\u4e26\u3079\u66ff\u3048\u5f8c\u306e\u30ea\u30b9\u30c8\u3092<\/strong>\u4f5c\u6210<\/span>\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-image-sorting-2.png\"><img decoding=\"async\" width=\"1240\" height=\"736\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-image-sorting-2.png\" alt=\"Excel\u306eSORT\u95a2\u6570\u306b\u3088\u308b\u4e26\u3079\u66ff\u3048\u306e\u30a4\u30e1\u30fc\u30b8\" class=\"wp-image-83770\" style=\"width:644px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-image-sorting-2.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-image-sorting-2-1200x712.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-image-sorting-2-768x456.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>Excel\u306eSORT\u95a2\u6570\u306b\u3088\u308b\u4e26\u3079\u66ff\u3048\u306e\u30a4\u30e1\u30fc\u30b8<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u306e\u305f\u3081\u3001SORT\u95a2\u6570\u306f\u5143\u30c7\u30fc\u30bf\u306f\u52d5\u304b\u3057\u305f\u304f\u306a\u3044\u3001\u8907\u6570\u306e\u30d1\u30bf\u30fc\u30f3\u3067\u4e26\u3079\u66ff\u3048\u3057\u305f\u30c7\u30fc\u30bf\u3092\u6b8b\u3057\u305f\u3044\u3001\u3068\u3044\u3063\u305f\u5834\u5408\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3055\u3089\u306b\u3001SORT\u95a2\u6570\u306f\u7e26\u65b9\u5411\u3060\u3051\u3067\u306a\u304f\u3001<span class=\"st-mymarker-s\">\u6a2a\u65b9\u5411\u3067\u3082\u4e26\u3079\u66ff\u3048<\/span>\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-st-blocks-my-box st-mybox has-title\" style=\"background-color:#fff;border-color:#757575\"><p class=\"st-mybox-title\" style=\"color:#424242;font-size:110%;font-weight:bold;text-shadow:#fff 3px 0px 0px, #fff 2.83487px .981584px 0px, #fff 2.35766px 1.85511px 0px, #fff 1.62091px 2.52441px 0px, #fff .705713px 2.91581px 0px, #fff -0.287171px 2.98622px 0px, #fff -1.24844px 2.72789px 0px, #fff -2.07227px 2.16926px 0px, #fff -2.66798px 1.37182px 0px, #fff -2.96998px .42336px 0px, #fff -2.94502px -0.571704px 0px, #fff -2.59586px -1.50383px 0px, #fff -1.96093px -2.27041px 0px, #fff -1.11013px -2.78704px 0px, #fff -0.137119px -2.99686px 0px, #fff .850987px -2.87677px 0px, #fff 1.74541px -2.43999px 0px, #fff 2.44769px -1.73459px 0px, #fff 2.88051px -0.838246px 0px;background:linear-gradient(0deg, #fff 0%, #fff 55%, rgba(0, 0, 0, 0) 55%, rgba(0, 0, 0, 0) 100%)\"><i class=\"st-fa st-svg-check-circle st-css-no\" aria-hidden=\"\"><\/i>SORT\u95a2\u6570\u304c\u5f79\u7acb\u3064\u30b1\u30fc\u30b9<\/p><div class=\"st-in-mybox\">\n<p>\uff11\uff0e\u5143\u30c7\u30fc\u30bf\u306f\u52d5\u304b\u3057\u305f\u304f\u306a\u3044<\/p>\n\n\n\n<p>\uff12\uff0e\u8907\u6570\u306e\u30d1\u30bf\u30fc\u30f3\u3067\u4e26\u3079\u66ff\u3048\u3092\u5b9f\u65bd\u3057\u3066\u3001\u305d\u306e\u30c7\u30fc\u30bf\u306f\u6b8b\u3057\u3066\u304a\u304d\u305f\u3044<\/p>\n\n\n\n<p>\uff13\uff0e\u7e26\u65b9\u5411\u3001\u6a2a\u65b9\u5411\u306b\u3082\u4e26\u3079\u66ff\u3048\u304c\u3057\u305f\u3044<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305f\u3060\u3057\u3001SORT\u95a2\u6570\u304c\u4f7f\u3048\u308b\u306e\u306f\u3001Excel\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304cMicrosoft365(\u30b5\u30d6\u30b9\u30af)\u3068<span class=\"st-mymarker-s-b\">Excel2021\u4ee5\u964d\u306e\u30e6\u30fc\u30b6\u30fc\u306b\u9650\u5b9a<\/span>\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u5206\u304b\u3089\u306a\u3044\u65b9\u306f\u3001\u300c\u30d5\u30a1\u30a4\u30eb\u300d\u30bf\u30d6\u21d2\u300c\u305d\u306e\u4ed6\u300d\u21d2\u300c\u30a2\u30ab\u30a6\u30f3\u30c8\u300d\u753b\u9762\u304b\u3089\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SORT\u95a2\u6570\u306e\u66f8\u5f0f\u3068\u5f15\u6570<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u307e\u305a\u3001SORT\u95a2\u6570\u306e\u66f8\u5f0f\u3068\u5f15\u6570\u3092\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3001\uff14\u3064\u306e\u5f15\u6570\u3067\u69cb\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-memo has-background has-small-font-size\" style=\"background-color:#ebffeb\"><strong><span class=\"oomozi\">\uff1dSORT(\u914d\u5217,[\u4e26\u3079\u66ff\u3048\u30a4\u30f3\u30c7\u30c3\u30af\u30b9],[\u4e26\u3079\u66ff\u3048\u9806\u5e8f],[\u4e26\u3079\u66ff\u3048\u57fa\u6e96])<\/span><\/strong><\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2 has-st-icon has-st-icon-pencil\"><strong><span class=\"dotline\">\u7b2c\uff11\u5f15\u6570\u300c\u914d\u5217\u300d<\/span><\/strong><br>\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u30c7\u30fc\u30bf\u306e<strong>\u30bb\u30eb\u7bc4\u56f2<\/strong>\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002(\u4f8b\uff1aB3:E11)<\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2 has-st-icon has-st-icon-pencil\"><strong><span class=\"dotline\">\u7b2c\uff12\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u300d<\/span><\/strong><br>\u7b2c\uff11\u5f15\u6570\u3067\u6307\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u7bc4\u56f2\u306e\u5148\u982d\u306e\u5217(\u884c)\u306e\u4f4d\u7f6e\u30921\u3068\u3057\u3066\u3001<strong>\u4f55\u5217\u76ee(\u4f55\u884c\u76ee)\u3092\u4e26\u3079\u66ff\u3048<\/strong>\u3057\u305f\u3044\u304b\u6570\u5024\u3067\u6307\u5b9a\u3002\u300c1\u300d\u306e\u5834\u5408\u306f\u3001\u7701\u7565\u53ef\u80fd\u3067\u3059\u3002(\u4f8b\uff1a3)<\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2 has-st-icon has-st-icon-pencil\"><strong><span class=\"dotline\">\u7b2c\uff13\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u9806\u5e8f\u300d<\/span><\/strong><br><strong>\u6607\u9806<\/strong>\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u5834\u5408\u306f\u300c1\u300d\u306f\u3001<strong>\u964d\u9806<\/strong>\u306e\u5834\u5408\u306f \u300c-1\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7701\u7565\u3059\u308b\u3068\u3001\u300c\uff11\u300d\u3092\u6307\u5b9a\u3057\u305f\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002(\u4f8b\uff1a1\uff0c-1)<\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2 has-st-icon has-st-icon-pencil\"><strong><span class=\"dotline\">\u7b2c\uff14\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u57fa\u6e96\u300d<\/span><\/strong><br><strong>\u7e26\u65b9\u5411<\/strong>\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u5834\u5408\u306f\u3001\u300cFALSE\u300d\u3082\u3057\u304f\u306f\u300c0\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<strong>\u6a2a\u65b9\u5411<\/strong>\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u5834\u5408\u306f\u3001\u300cTRUE\u300d\u3082\u3057\u304f\u306f\u300c1\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7701\u7565\u3057\u305f\u5834\u5408\u306f\u3001\u300cFALSE\u300d\u3068\u306a\u308a\u307e\u3059\u3002(\u4f8b\uff1aFALSE\uff0cTRUE)<\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SORT\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3068\u624b\u9806<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u8a73\u3057\u304f\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eee\u306b\u3001\u4e26\u3079\u66ff\u3048\u3059\u308b\u30c7\u30fc\u30bf\u304c20\u30bb\u30eb\u3042\u3063\u305f\u3068\u3057\u3066\u3082\u300120\u500b\u306eSORT\u95a2\u6570\u3092\u633f\u5165\u3059\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u3092\uff11\u3064\u306e\u30bb\u30eb\u306b\u633f\u5165\u3059\u308b\u3060\u3051\u3067\u3001<span class=\"st-mymarker-s\">\u8907\u6570\u306e\u884c\u3068\u5217\u306b\u7d50\u679c\u304c\u62e1\u5f35<\/span>\u3055\u308c\u3066\u4e26\u3079\u66ff\u3048\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002(\u3053\u306e\u6a5f\u80fd\u306e\u3053\u3068\u3092\u30b9\u30d4\u30eb\u3068\u3044\u3044\u307e\u3059)<\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SORT\u95a2\u6570\u3067\u30c7\u30fc\u30bf\u3092\u7e26\u65b9\u5411\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u6cd5<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e0b\u306e\u8868\u306bSORT\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3001\u300c\u751f\u5e74\u6708\u65e5\u300d\u5217\u3092\u6607\u9806\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data.png\"><img decoding=\"async\" width=\"1108\" height=\"1240\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data.png\" alt=\"SORT\u95a2\u6570\u3092\u4f7f\u3046\u5143\u30c7\u30fc\u30bf\" class=\"wp-image-83816\" style=\"width:356px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data.png 1108w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data-1072x1200.png 1072w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data-768x859.png 768w\" sizes=\"(max-width: 1108px) 100vw, 1108px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u3092\u4f7f\u3046\u5143\u30c7\u30fc\u30bf<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff0e\u898b\u51fa\u3057\u884c\u3092\u30b3\u30d4\u30da<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u898b\u51fa\u3057\u884c\u306fSORT\u95a2\u6570\u3067\u306f\u8907\u88fd\u3055\u308c\u307e\u305b\u3093\u3002\u305d\u306e\u305f\u3081\u3001\u7a7a\u3044\u3066\u3044\u308b\u30bb\u30eb\u306b\u884c\u898b\u51fa\u3057\u3092\u30b3\u30d4\u30da\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-heading-copy-paste.png\"><img decoding=\"async\" width=\"1240\" height=\"475\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-heading-copy-paste.png\" alt=\"SORT\u95a2\u6570\/\u624b\u9806\uff11\uff1a\u898b\u51fa\u3057\u3092\u30b3\u30d4\u30da\" class=\"wp-image-83819\" style=\"width:672px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-heading-copy-paste.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-heading-copy-paste-1200x460.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-heading-copy-paste-768x294.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\/\u624b\u9806\uff11\uff1a\u898b\u51fa\u3057\u3092\u30b3\u30d4\u30da<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff12\uff0eSORT\u95a2\u6570\u3092\u7b2c\uff11\u5f15\u6570\u3092\u6307\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u898b\u51fa\u3057\u306e\u5de6\u4e0b\u306eG3\u30bb\u30eb\u306bSORT\u95a2\u6570\u3092\u633f\u5165\u3057\u307e\u3059\u3002\u7b2c\uff11\u5f15\u6570\u300c\u914d\u5217\u300d\u306f\u3001\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u30c7\u30fc\u30bf\u7bc4\u56f2(B3:E11)\u3092<span class=\"dotline\">\u898b\u51fa\u3057\u3092\u9664\u3044\u3066<\/span>\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SORT(<span class=\"st-mymarker-s\">B3:E11,<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-data-area-designation.png\"><img decoding=\"async\" width=\"1240\" height=\"679\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-data-area-designation.png\" alt=\"SORT\u95a2\u6570\/\u624b\u9806\uff12\uff1a\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u30c7\u30fc\u30bf\u3092\u6307\u5b9a\" class=\"wp-image-83826\" style=\"width:626px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-data-area-designation.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-data-area-designation-1200x657.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-data-area-designation-768x421.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\/\u624b\u9806\uff12\uff1a\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u30c7\u30fc\u30bf\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff13\uff0eSORT\u95a2\u6570\u3092\u7b2c\uff12\u5f15\u6570\u3092\u6307\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u300d\u306f\u3001\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u5217\u304c<span class=\"dotline\">\u5148\u982d\u304b\u3089\u4f55\u5217\u76ee\u304b<\/span>\u3092\u6570\u5b57\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u751f\u5e74\u6708\u65e5\u300d\u5217\u306f\u3001\u5de6\u7aef\u304b\u30894\u5217\u76ee\u306b\u3042\u308b\u306e\u3067\u3001\u300c4\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SORT(B3:E11,<span class=\"st-mymarker-s\">4<\/span><span class=\"st-mymarker-s\">,<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-column-number-designation.png\"><img decoding=\"async\" width=\"1240\" height=\"780\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-column-number-designation.png\" alt=\"SORT\u95a2\u6570\/\u624b\u9806\uff13\uff1a\u4e26\u3079\u66ff\u3048\u3059\u308b\u5217\u3092\u6307\u5b9a\" class=\"wp-image-83842\" style=\"width:606px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-column-number-designation.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-column-number-designation-1200x755.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-column-number-designation-768x483.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\/\u624b\u9806\uff13\uff1a\u4e26\u3079\u66ff\u3048\u3059\u308b\u5217\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff14\uff0eSORT\u95a2\u6570\u3092\u7b2c\uff13\u5f15\u6570\u3092\u6307\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u9806\u5e8f\u300d\u306f\u3001\u624b\u9806\uff13\u3067\u6307\u5b9a\u3057\u305f\u5217\u3092\u6607\u9806\u3067\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u304b\u964d\u9806\u3067\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u304b\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6607\u9806(\u5c0f\u3055\u3044\u9806)\u306e\u5834\u5408\u306f\u300c1\u300d(\u3082\u3057\u304f\u306f\u30d6\u30e9\u30f3\u30af)\u3001\u964d\u9806(\u5927\u304d\u3044\u9806)\u306e\u5834\u5408\u306f\u300c-1\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SORT(B3:E11,4,<span class=\"st-mymarker-s\">1<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-ascending-descending-designation.png\"><img decoding=\"async\" width=\"1240\" height=\"779\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-ascending-descending-designation.png\" alt=\"SORT\u95a2\u6570\/\u624b\u9806\uff14\uff1a\u6607\u9806\u304b\u964d\u9806\u304b\u3092\u6307\u5b9a\" class=\"wp-image-83849\" style=\"width:600px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-ascending-descending-designation.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-ascending-descending-designation-1200x754.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-ascending-descending-designation-768x482.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\/\u624b\u9806\uff14\uff1a\u6607\u9806\u304b\u964d\u9806\u304b\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff15\uff0eSORT\u95a2\u6570\u3092\u7b2c\uff14\u5f15\u6570\u3092\u6307\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u7b2c\uff14\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u57fa\u6e96\u300d\u306f\u3001\u7e26\u65b9\u5411\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u304b\u3001\u6a2a\u65b9\u5411\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u304b\u3092\u6c7a\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u7e26\u65b9\u5411\u306e\u5834\u5408\u306f\u300cFALSE\u300d(\u3082\u3057\u304f\u306f0)\u3001\u6a2a\u65b9\u5411\u306e\u5834\u5408\u306f\u300cTRUE\u300d(\u3082\u3057\u304f\u306f\uff11)\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SORT(B3:E11,4,1,<span class=\"st-mymarker-s\">FALSE)<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-vertical-horizontal-designation.png\"><img decoding=\"async\" width=\"1240\" height=\"775\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-vertical-horizontal-designation.png\" alt=\"SORT\u95a2\u6570\/\u624b\u9806\uff15\uff1a\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u5411\u3092\u6307\u5b9a\" class=\"wp-image-83860\" style=\"width:636px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-vertical-horizontal-designation.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-vertical-horizontal-designation-1200x750.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-vertical-horizontal-designation-768x480.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\/\u624b\u9806\uff15\uff1a\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u5411\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff16\uff0eSORT\u95a2\u6570\u3092\u78ba\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">Enter\u30ad\u30fc\u3092\u62bc\u3057\u3066SORT\u95a2\u6570\u3092\u78ba\u5b9a\u3055\u305b\u3066\u304f\u3060\u3055\u3044\u3002\u305d\u3046\u3059\u308b\u3068\u3001\u300c\u751f\u5e74\u6708\u65e5\u300d\u5217\u3092\u6607\u9806\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305f\u3060\u3001\u4eca\u56de\u306e\u3088\u3046\u306b\u65e5\u4ed8\u30bb\u30eb\u3092\u4e26\u3079\u66ff\u3048\u3059\u308b\u3068\u3001\u4e0b\u306e\u56f3\u306e\u3088\u3046\u306b\u65e5\u4ed8\u304c\u30b7\u30ea\u30a2\u30eb\u5024\u3067\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u30bb\u30eb\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3092\u300c\u65e5\u4ed8\u300d\u306b\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-cell-format-date-change.png\"><img decoding=\"async\" width=\"1240\" height=\"1145\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-cell-format-date-change.png\" alt=\"SORT\u95a2\u6570\/\u624b\u9806\uff16\uff1a\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u3092\u65e5\u4ed8\u306b\u5909\u66f4\" class=\"wp-image-83868\" style=\"width:446px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-cell-format-date-change.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-cell-format-date-change-1200x1108.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-cell-format-date-change-768x709.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\/\u624b\u9806\uff16\uff1a\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u3092\u65e5\u4ed8\u306b\u5909\u66f4<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:65px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff17\uff0eSORT\u95a2\u6570\u306b\u3088\u308b\u4e26\u3079\u66ff\u3048\u304c\u5b8c\u6210<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4ee5\u4e0a\u306e\u64cd\u4f5c\u3067\u3001\u4e0b\u306e\u56f3\u306e\u3088\u3046\u306b\u30c7\u30fc\u30bf\u3092\u300c\u751f\u5e74\u6708\u65e5\u300d\u3092\u57fa\u6e96\u306b\u6607\u9806\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-use-completed.png\"><img decoding=\"async\" width=\"1240\" height=\"773\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-use-completed.png\" alt=\"SORT\u95a2\u6570\/\u624b\u9806\uff17\uff1a\u4e26\u3079\u66ff\u3048\u304c\u5b8c\u6210\" class=\"wp-image-83874\" style=\"width:580px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-use-completed.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-use-completed-1200x748.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-use-completed-768x479.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\/\u624b\u9806\uff17\uff1a\u4e26\u3079\u66ff\u3048\u304c\u5b8c\u6210<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:33px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>SORT\u95a2\u6570\u306fG3\u30bb\u30eb\u306e\uff11\u3064\u306e\u30bb\u30eb\u306b\u3057\u304b\u633f\u5165\u3057\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u30b9\u30d4\u30eb\u6a5f\u80fd\u306b\u3088\u308aG3\u30bb\u30eb\u4ee5\u5916\u306e\u30bb\u30eb\u306b\u3082\u4e26\u3079\u66ff\u3048\u3055\u308c\u305f\u7d50\u679c\u304c\u62e1\u5f35\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:53px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SORT\u95a2\u6570\u3067\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u5834\u5408<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u3067<span class=\"st-mymarker-s-b\">\u30a8\u30e9\u30fc\u5024\u300c#\u30b9\u30d4\u30eb!\u300d<\/span>\u304c\u767a\u751f\u3059\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u30b1\u30fc\u30b9\u306f\u3001\u30b9\u30d4\u30eb\u6a5f\u80fd\u306b\u3088\u3063\u3066SORT\u95a2\u6570\u306e\u7d50\u679c\u3092\u8868\u793a\u3055\u305b\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u5468\u308a\u306e\u30bb\u30eb\u7bc4\u56f2\u306b\u3001\u6587\u5b57\u3084\u6570\u5024\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u539f\u56e0\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u969b\u306f\u3001\u4e26\u3079\u66ff\u3048\u5f8c\u306e\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u308b\u30bb\u30eb\u7bc4\u56f2\u306b\u6587\u5b57\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u306a\u3044\u304b\u78ba\u8a8d\u3057\u524a\u9664\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-spill-error-solution.png\"><img decoding=\"async\" width=\"1240\" height=\"801\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-spill-error-solution.png\" alt=\"SORT\u95a2\u6570\u3067\u30b9\u30d4\u30eb\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u5834\u5408\u306e\u89e3\u6c7a\u7b56\" class=\"wp-image-83883\" style=\"width:520px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-spill-error-solution.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-spill-error-solution-1200x775.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-spill-error-solution-768x496.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u3067\u30b9\u30d4\u30eb\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u5834\u5408\u306e\u89e3\u6c7a\u7b56<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:53px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SORT\u95a2\u6570\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u3092\u7d39\u4ecb<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u306f\u4e0a\u8a18\u3067\u7d39\u4ecb\u3057\u305f\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u7d9a\u3044\u3066\u3001SORT\u95a2\u6570\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u3001SORT\u95a2\u6570\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u30925\u3064\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5b9f\u52d9\u3067\u6d3b\u7528\u3067\u304d\u308b\u5834\u9762\u304c\u306a\u3044\u304b\u30a4\u30e1\u30fc\u30b8\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:43px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SORT\u95a2\u6570\/\u4e8b\u4f8b\uff11\uff1a\u6a2a\u65b9\u5411\u306b\u4e26\u3079\u66ff\u3048<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306f\u3001\u30c7\u30fc\u30bf\u3092<span class=\"st-mymarker-s\">\u6a2a\u65b9\u5411<\/span>\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e0b\u306e\u8868\u306e\uff14\u884c\u76ee\u306e\u300c\u751f\u5e74\u6708\u65e5\u300d\u5217\u3092\u5de6\u304b\u3089\u9806\u306b\u6607\u9806\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data-horizontal.png\"><img decoding=\"async\" width=\"1240\" height=\"584\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data-horizontal.png\" alt=\"SORT\u95a2\u6570\u3067\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u6a2a\u5411\u304d\u306e\u8868\" class=\"wp-image-83901\" style=\"width:662px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data-horizontal.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data-horizontal-1200x565.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-base-data-horizontal-768x362.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u3067\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u6a2a\u5411\u304d\u306e\u8868<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:43px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6a2a\u65b9\u5411\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u3068\u304d\u306f\u3001SORT\u95a2\u6570\u306e\u7b2c4\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u57fa\u6e96\u300d\u3092\u300cTRUE\u300d\u3082\u3057\u304f\u306f\u300c\uff11\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SORT(C2:I4,3,1,<span class=\"st-mymarker-s\">TRUE<\/span>)<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-horizontal-how-to-use.png\"><img decoding=\"async\" width=\"1240\" height=\"592\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-horizontal-how-to-use.png\" alt=\"SORT\u95a2\u6570\u3067\u8868\u3092\u6a2a\u65b9\u5411\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u6cd5\" class=\"wp-image-83907\" style=\"width:626px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-horizontal-how-to-use.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-horizontal-how-to-use-1200x573.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-horizontal-how-to-use-768x367.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u3067\u8868\u3092\u6a2a\u65b9\u5411\u306b\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u6cd5<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30d5\u30a3\u30eb\u30bf\u30fc\u3067\u306f\u6a2a\u65b9\u5411\u306b\u5bfe\u5fdc\u3067\u304d\u307e\u305b\u3093\u304c\u3001SORT\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001\u4e0a\u8a18\u306e\u3088\u3046\u306b\u7c21\u5358\u306b\u4e26\u3079\u66ff\u3048\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SORT\u95a2\u6570\/\u4e8b\u4f8b\uff12\uff1a\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\u3092\u81ea\u52d5\u3067\u53cd\u6620\u3055\u305b\u3066\u4e26\u3079\u66ff\u3048<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e0b\u306e\u56f3\u306e\u3088\u3046\u306b\u6700\u4e0b\u884c\u306b<span class=\"st-mymarker-s-b\">\u5143\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0<\/span>\u3057\u3066\u3082\u3001\u6b8b\u5ff5\u306a\u304c\u3089SORT\u95a2\u6570\u306e<span class=\"st-mymarker-s-b\">\u7d50\u679c\u306f\u81ea\u52d5\u3067\u53cd\u6620\u3055\u308c\u307e\u305b\u3093<\/span>\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-data-addition-1.png\"><img decoding=\"async\" width=\"1240\" height=\"794\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-data-addition-1.png\" alt=\"\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u3066\u3082SORT\u95a2\u6570\u306f\u81ea\u52d5\u3067\u53cd\u6620\u3055\u308c\u306a\u3044\" class=\"wp-image-83928\" style=\"width:560px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-data-addition-1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-data-addition-1-1200x768.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-data-addition-1-768x492.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u3066\u3082SORT\u95a2\u6570\u306f\u81ea\u52d5\u3067\u53cd\u6620\u3055\u308c\u306a\u3044<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30c7\u30fc\u30bf\u3092\u53cd\u6620\u3055\u305b\u308b\u305f\u3081\u306b\u306f\u3001G3\u30bb\u30eb\u306b\u633f\u5165\u3057\u305fSORT\u95a2\u6570\u3067\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u3092\u4fee\u6b63\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3057\u304b\u3057\u3001IF\u95a2\u6570\u3068SORT\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001<span class=\"st-mymarker-s\">\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\u3092\u81ea\u52d5\u53cd\u6620<\/span>\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u3001\u305d\u306e\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5143\u30c7\u30fc\u30bf\u3092\u5f8c\u304b\u3089\u8ffd\u52a0\u3059\u308b\u524d\u63d0\u3067\u3001SORT\u95a2\u6570\u306e\u30bb\u30eb\u7bc4\u56f2\u3092<span class=\"st-mymarker-s\">\u7a7a\u767d\u30bb\u30eb\u3082\u542b\u3081\u3066\u5e83\u3081\u306b\u8a2d\u5b9a<\/span>\u3057\u3066\u304a\u304f\u3068\u3001SORT\u95a2\u6570\u306e\u7d50\u679c\u306f<strong>\u300c0\u300d\u3068\u8868\u793a<\/strong>\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-cell-area-expansion-result.png\"><img decoding=\"async\" width=\"1240\" height=\"842\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-cell-area-expansion-result.png\" alt=\"SORT\u95a2\u6570\u306f\u7a7a\u767d\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u300c0\u300d\u3092\u8fd4\u3059\" class=\"wp-image-83933\" style=\"width:608px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-cell-area-expansion-result.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-cell-area-expansion-result-1200x815.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-function-cell-area-expansion-result-768x521.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u306f\u7a7a\u767d\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u300c0\u300d\u3092\u8fd4\u3059<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u306e\u305f\u3081\u3001IF\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3001SORT\u95a2\u6570\u306e\u7d50\u679c\u304c<strong><span class=\"dotline\">\u300c0\u300d\u3067\u3042\u308c\u3070\u30bb\u30eb\u304c\u30d6\u30e9\u30f3\u30af<\/span><\/strong>\u3068\u306a\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5229\u7528\u3059\u308b\u6570\u5f0f\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">IF\u95a2\u6570\u306e\u7b2c\uff11\u5f15\u6570\u300c\u8ad6\u7406\u5f0f\u300d\u306b\u300cSORT\u95a2\u6570\u306e\u7d50\u679c\u304c0\u4ee5\u5916\u306e\u5834\u5408\u300d\u3092\u8a2d\u5b9a\u3057\u3001\u7b2c\uff12\u5f15\u6570\u300c\u5024\u304c\u771f\u306e\u5834\u5408\u300d\u306bSORT\u95a2\u6570\u3001\u7b2c3\u5f15\u6570\u300c\u5024\u304c\u507d\u306e\u5834\u5408\u300d\u306b\u300c\u201d\u201d\u300d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><strong><span class=\"oomozi\">=IF(SORT(B3:E13,4,-1,FALSE)&lt;&gt;0,SORT(B3:E13,4,-1,FALSE),&#8221;&#8221;)<\/span><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination.png\"><img decoding=\"async\" width=\"1240\" height=\"808\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination.png\" alt=\"IF\u95a2\u6570\u3068SORT\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u30660\u3092\u975e\u8868\u793a\" class=\"wp-image-83950\" style=\"width:610px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination-1200x782.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination-768x500.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>IF\u95a2\u6570\u3068SORT\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u30660\u3092\u975e\u8868\u793a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u3046\u3059\u308b\u3068\u3001\u4e0a\u306e\u56f3\u306e\u3088\u3046\u306b\u3001SORT\u95a2\u6570\u306e\u30bb\u30eb\u7bc4\u56f2\u306f13\u884c\u76ee\u307e\u3067\u306e\u30d6\u30e9\u30f3\u30af\u306a\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u304c\u3001SORT\u95a2\u6570\u306e\u7d50\u679c\u306f0\u3068\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u6570\u5f0f\u3092\u4e00\u5ea6\u4f5c\u6210\u3057\u3066\u3057\u307e\u3048\u3070\u3001\u5143\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u3066\u3082\u3001SORT\u95a2\u6570\u306e\u7d50\u679c\u306f\u81ea\u52d5\u3067\u53cd\u6620\u3055\u308c\u3066\u4e26\u3079\u66ff\u3048\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination-automatic-addition.png\"><img decoding=\"async\" width=\"1240\" height=\"818\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination-automatic-addition.png\" alt=\"SORT\u95a2\u6570\u3068IF\u95a2\u6570\u3067\u5143\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\u304c\u81ea\u52d5\u3067\u53cd\u6620\" class=\"wp-image-83958\" style=\"width:568px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination-automatic-addition.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination-automatic-addition-1200x792.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-if-function-combination-automatic-addition-768x507.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u3068IF\u95a2\u6570\u3067\u5143\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\u304c\u81ea\u52d5\u3067\u53cd\u6620<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SORT\u95a2\u6570\/\u4e8b\u4f8b\uff13\uff1a\u8907\u6570\u306e\u5217\u3092\u512a\u5148\u9806\u4f4d\u3092\u3064\u3051\u3066\u4e26\u3079\u66ff\u3048 (\u914d\u5217\u6570\u5f0f)<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306f\u57fa\u672c\u7684\u306b\uff11\u3064\u306e\u5217\u306b\u5bfe\u3057\u3066\u4e26\u3079\u66ff\u3048\u3092\u884c\u3044\u307e\u3059\u304c\u3001<span class=\"st-mymarker-s\">\u512a\u5148\u9806\u4f4d\u3092\u3064\u3051\u3066\u8907\u6570\u306e\u5217\u3067\u4e26\u3079\u66ff\u3048<\/span>\u3059\u308b\u30eb\u30fc\u30eb\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5229\u7528\u3059\u308b\u306e\u306f\u3001\u300c<span class=\"st-mymarker-s\">\u914d\u5217\u6570\u5f0f<\/span>\u300d\u3068\u3044\u3046\u8907\u96d1\u306a\u8a08\u7b97\u3092\u53ef\u80fd\u306b\u3059\u308b\u300c{}\u300d\u3092\u4f7f\u3063\u305f\u6570\u5f0f\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u3068\u7b2c\uff12\u5f15\u6570\u306b\u914d\u5217\u6570\u5f0f({})\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4f8b\u3048\u3070\u3001\u512a\u5148\u9806\u4f4d\uff11\u4f4d\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u5217\u306f<strong>\uff13\u5217\u76ee<\/strong>\u3001\u512a\u5148\u9806\u4f4d\uff12\u4f4d\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u5217\u306f<strong>\uff14\u5217\u76ee<\/strong>\u3067\u8a2d\u5b9a\u3057\u305f\u3044\u5834\u5408\u306f\u3001SORT\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u300d\u306f\u3001<span class=\"st-mymarker-s\">{3,4}<\/span>\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u540c\u69d8\u306b\u3001SORT\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u300c\u4e26\u3079\u66ff\u3048\u9806\u5e8f\u300d\u306f\u3001\uff13\u5217\u76ee\u3068\uff14\u5217\u76ee\u3092\u6607\u9806(1)\u304b\u964d\u9806(-1)\u304b\u3092\u305d\u308c\u305e\u308c\u6307\u5b9a\u3057\u3001<span class=\"st-mymarker-s\">{1,-1}<\/span>\u3068\u3044\u3063\u305f\u3088\u3046\u306b\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=SORT(B3:E11,<span class=\"st-mymarker-s\">{3,4},{1,-1}<\/span>,FALSE)<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-1.png\"><img decoding=\"async\" width=\"1240\" height=\"854\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-1.png\" alt=\"\u914d\u5217\u6570\u5f0f\u3092SORT\u95a2\u6570\u306b\u4f7f\u3063\u3066\u8907\u6570\u306e\u5217\u306b\u512a\u5148\u9806\u4f4d\u3092\u3064\u3051\u3066\u4e26\u3079\u66ff\u3048\" class=\"wp-image-83989\" style=\"width:604px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-1-1200x826.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-1-768x529.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u914d\u5217\u6570\u5f0f\u3092SORT\u95a2\u6570\u306b\u4f7f\u3063\u3066\u8907\u6570\u306e\u5217\u306b\u512a\u5148\u9806\u4f4d\u3092\u3064\u3051\u3066\u4e26\u3079\u66ff\u3048<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u914d\u5217\u6570\u5f0f\u306f\u300c=SORT(B3:E11,<span class=\"st-mymarker-s\">{3,4,1},{1,-1,1}<\/span>,FALSE)\u300d\u3068\u3044\u3063\u305f\u3088\u3046\u306b\u3001\uff13\u3064\u4ee5\u4e0a\u3067\u5229\u7528\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u914d\u5217\u6570\u5f0f\u3092\u4f7f\u3046\u969b\u306e\u6ce8\u610f\u70b9\u306f\u3001<span class=\"dotline\">\u512a\u5148\u9806\u4f4d\u304c\u9ad8\u3044\u5217(\u884c)\u304b\u3089\u9806\u756a\u306b\u6570\u5f0f\u3092\u4f5c\u6210<\/span>\u3059\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c{3,4}\u300d\u3068\u3059\u3079\u304d\u3068\u3053\u308d\u3092\u300c{4,3}\u300d\u3068\u6570\u5f0f\u3092\u4f5c\u6210\u3059\u308b\u3068\u3001\uff14\u5217\u76ee\u304c\u6700\u512a\u5148\u3067\u4e26\u3079\u66ff\u3048\u3055\u308c\u308b\u306e\u3067\u3001\u7d50\u679c\u306f\u5909\u308f\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-illustrated.png\"><img decoding=\"async\" width=\"1240\" height=\"329\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-illustrated.png\" alt=\"\u56f3\u89e3\uff0eSORT\u95a2\u6570\u3092\u914d\u5217\u6570\u5f0f\u3067\u5229\u7528\" class=\"wp-image-83983\" style=\"width:576px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-illustrated.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-illustrated-1200x318.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-array-illustrated-768x204.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u56f3\u89e3\uff0eSORT\u95a2\u6570\u3092\u914d\u5217\u6570\u5f0f\u3067\u5229\u7528<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SORT\u95a2\u6570\/\u4e8b\u4f8b\uff14\uff1a\u8907\u6570\u306e\u5217\u3092\u512a\u5148\u9806\u4f4d\u3092\u3064\u3051\u3066\u4e26\u3079\u66ff\u3048 (\u5165\u308c\u5b50)<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"st-mymarker-s\">SORT\u95a2\u6570\u306e\u4e2d\u306bSORT\u95a2\u6570\u3092\u633f\u5165<\/span>\u3059\u308b\u300c\u5165\u308c\u5b50\u300d(\u5225\u540d\uff1a\u30cd\u30b9\u30c8\uff09\u3068\u3044\u3046\u30c6\u30af\u30cb\u30c3\u30af\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001<span class=\"st-mymarker-s\">\u8907\u6570\u306e\u5217\u3067\u4e26\u3079\u66ff\u3048<\/span>\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e8b\u4f8b\uff13\u3067\u7d39\u4ecb\u3057\u305f\u914d\u5217\u6570\u5f0f\u306e\u5229\u7528\u304c\u82e6\u624b\u306a\u65b9\u306f\u3001\u3053\u3061\u3089\u3092\u5229\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u307e\u305a\u3001SORT\u95a2\u6570\u3067<span class=\"dotline\">\u512a\u5148\u9806\u4f4d\u304c\u4f4e\u3044\u5217<\/span>\u306e\u4e26\u3079\u66ff\u3048\u306e\u6570\u5f0f\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002(\uff14\u5217\u76ee\u3092\u964d\u9806(-1)\u3067\u4e26\u3079\u66ff\u3048)<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=SORT(B3:E11,4,-1,FALSE)<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-lower-priority-columns-first.png\"><img decoding=\"async\" width=\"1240\" height=\"845\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-lower-priority-columns-first.png\" alt=\"\u512a\u5148\u9806\u4f4d\u304c\u4f4e\u3044\u5217\u3092\u5148\u306b\u4e26\u3079\u66ff\u3048\" class=\"wp-image-83999\" style=\"width:614px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-lower-priority-columns-first.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-lower-priority-columns-first-1200x818.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-lower-priority-columns-first-768x523.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u512a\u5148\u9806\u4f4d\u304c\u4f4e\u3044\u5217\u3092\u5148\u306b\u4e26\u3079\u66ff\u3048<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6b21\u306b\u3001\u4f5c\u6210\u3057\u305fSORT\u95a2\u6570\u3092\u56f2\u3046\u3088\u3046\u306b\u3001\uff12\u3064\u76ee\u306eSORT\u95a2\u6570\u3092\u633f\u5165\u3057\u3001\u512a\u5148\u9806\u4f4d\u304c\u9ad8\u3044\u5217\u306e\u4e26\u3079\u66ff\u3048\u3092\u5b9f\u65bd\u3057\u307e\u3059\u3002(\uff13\u5217\u76ee\u3092\u6607\u9806(1)\u3067\u4e26\u3079\u66ff\u3048)<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=<span class=\"st-mymarker-s\">SORT(<\/span>SORT(B3:E11,4,-1,FALSE)<span class=\"st-mymarker-s\">,3,1,FALSE)<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-higher-priority-columns-second.png\"><img decoding=\"async\" width=\"1240\" height=\"898\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-higher-priority-columns-second.png\" alt=\"SORT\u95a2\u6570\u306bSORT\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-84000\" style=\"width:614px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-higher-priority-columns-second.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-higher-priority-columns-second-1200x869.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-higher-priority-columns-second-768x556.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u306bSORT\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u3046\u3059\u308b\u3068\u3001\u4e0a\u306e\u8868\u306e\u3088\u3046\u306b\u3001\u5143\u30c7\u30fc\u30bf\u306e\uff13\u5217\u76ee\u300c\u6027\u5225\u300d\u3092\u512a\u5148\u9806\u4f4d\uff11\u4f4d\u3067\u3001\uff14\u5217\u76ee\u300c\u751f\u5e74\u6708\u65e5\u300d\u3092\u512a\u5148\u9806\u4f4d\uff12\u4f4d\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u540c\u69d8\u306e\u8981\u9818\u3067\u3001SORT\u95a2\u6570\u3092\uff13\u3064\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\uff13\u3064\u4ee5\u4e0a\u306e\u5217\u306b\u5bfe\u3057\u3066\u3001\u4e26\u3079\u66ff\u3048\u306e\u5217\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-nesting-illustrated.png\"><img decoding=\"async\" width=\"1240\" height=\"266\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-nesting-illustrated.png\" alt=\"SORT\u95a2\u6570\u3067\uff13\u3064\u4ee5\u4e0a\u306e\u8907\u6570\u5217\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u6570\u5f0f\u306e\u4ed5\u7d44\u307f\" class=\"wp-image-84006\" style=\"width:652px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-nesting-illustrated.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-nesting-illustrated-1200x257.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sort-multiple-columns-nesting-illustrated-768x165.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u3067\uff13\u3064\u4ee5\u4e0a\u306e\u8907\u6570\u5217\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u6570\u5f0f\u306e\u4ed5\u7d44\u307f<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SORT\u95a2\u6570\/\u4e8b\u4f8b\uff15\uff1aFILTER\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u3068<span class=\"st-mymarker-s\">FILTER\u95a2\u6570<\/span>\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3068\u3001\u6761\u4ef6\u306b\u5408\u3046<span class=\"st-mymarker-s\">\u30c7\u30fc\u30bf\u306e\u62bd\u51fa\u3068\u4e26\u3079\u66ff\u3048\u3092\u540c\u6642\u306b\u884c\u3046<\/span>\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">FILTER\u95a2\u6570\u306e\u66f8\u5f0f\u306f\u3001\u300c=FILTER(\u914d\u5217,\u542b\u3080,[\u7a7a\u306e\u5834\u5408])\u300d\u3067\u3001\u5f15\u6570\u306e\u5185\u5bb9\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-st-blocks-my-box st-mybox has-title\" style=\"background-color:#fff;border-color:#757575\"><p class=\"st-mybox-title\" style=\"color:#424242;font-weight:bold;text-shadow:#fff 3px 0px 0px, #fff 2.83487px .981584px 0px, #fff 2.35766px 1.85511px 0px, #fff 1.62091px 2.52441px 0px, #fff .705713px 2.91581px 0px, #fff -0.287171px 2.98622px 0px, #fff -1.24844px 2.72789px 0px, #fff -2.07227px 2.16926px 0px, #fff -2.66798px 1.37182px 0px, #fff -2.96998px .42336px 0px, #fff -2.94502px -0.571704px 0px, #fff -2.59586px -1.50383px 0px, #fff -1.96093px -2.27041px 0px, #fff -1.11013px -2.78704px 0px, #fff -0.137119px -2.99686px 0px, #fff .850987px -2.87677px 0px, #fff 1.74541px -2.43999px 0px, #fff 2.44769px -1.73459px 0px, #fff 2.88051px -0.838246px 0px;background:linear-gradient(0deg, #fff 0%, #fff 55%, rgba(0, 0, 0, 0) 55%, rgba(0, 0, 0, 0) 100%)\"><i class=\"st-fa st-svg-check-circle st-css-no\" aria-hidden=\"\"><\/i>FILTER\u95a2\u6570\u306e\u5f15\u6570<\/p><div class=\"st-in-mybox\">\n<p>\u7b2c\uff11\u5f15\u6570\u300c\u914d\u5217\u300d\uff1a\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3059\u308b<\/p>\n\n\n\n<p>\u7b2c\uff12\u5f15\u6570\u300c\u542b\u3080\u300d\uff1a\u62bd\u51fa\u3059\u308b\u6761\u4ef6\u3092\u8ad6\u7406\u5f0f\u3067\u5165\u529b\u3059\u308b<\/p>\n\n\n\n<p>\u7b2c\uff13\u5f15\u6570\u300c\u7a7a\u767d\u300d\uff1a\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u304c\u306a\u3044\u5834\u5408\u306e\u8868\u793a\u65b9\u6cd5\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:57px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\uff11\u3064\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">B\u5217\u304b\u3089E\u5217\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u3001\u4ee5\u4e0b\u306eFILTER\u95a2\u6570\u3092\u633f\u5165\u3057\u307e\u3059\u3002\u305d\u3046\u3059\u308b\u3068\u3001\u6027\u5225\u304c\u300c\u7537\u300d\u306b\u5408\u81f4\u3059\u308b\u300c\u6027\u5225\u300d\u300c\u751f\u5e74\u6708\u65e5\u300d\u306e\u30c7\u30fc\u30bf\u3092G\u5217\u3001H\u5217\u306b\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=FILTER(D3:E11,D3:D11=&#8221;\u7537&#8221;,&#8221;&#8221;)<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-functions-how-to-use.png\"><img decoding=\"async\" width=\"1240\" height=\"931\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-functions-how-to-use.png\" alt=\"FILTER\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\" class=\"wp-image-84015\" style=\"width:548px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-functions-how-to-use.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-functions-how-to-use-1200x901.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-functions-how-to-use-768x577.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>FILTER\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:57px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306eFILTER\u95a2\u6570\u3092SORT\u95a2\u6570\u306e\u7b2c\uff11\u5f15\u6570\u306b\u633f\u5165\u3059\u308b\u3053\u3068\u3067\u3001\u300c\u7537\u300d\u306e\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3066\u3001\u3055\u3089\u306b\u300c\u751f\u5e74\u6708\u65e5\u300d\u3092\u6607\u9806\u3067\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=<span class=\"st-mymarker-s\">SORT(<\/span>FILTER(D3:E11,D3:D11=&#8221;\u7537&#8221;,&#8221;&#8221;)<span class=\"st-mymarker-s\">,2,1)<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-sort-functions-combination.png\"><img decoding=\"async\" width=\"1240\" height=\"967\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-sort-functions-combination.png\" alt=\"SORT\u95a2\u6570\u3068FILTER\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5\" class=\"wp-image-84028\" style=\"width:554px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-sort-functions-combination.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-sort-functions-combination-1200x936.png 1200w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-filter-sort-functions-combination-768x599.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>SORT\u95a2\u6570\u3068FILTER\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:57px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SORTBY\u95a2\u6570\u306f\u8907\u6570\u306e\u57fa\u6e96\u3067\u4e26\u3079\u66ff\u3048\u3067\u304d\u308b\uff01<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u306b\u4f3c\u305f\u95a2\u6570\u306b\u3001<span class=\"st-mymarker-s\">SORTBY\u95a2\u6570<\/span>(\u30bd\u30fc\u30c8\u30d0\u30a4)\u3068\u3044\u3046\u95a2\u6570\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORTBY\u95a2\u6570\u306f\u3001\u30c7\u30fc\u30bf\u3092<strong><span class=\"dotline\">\u8907\u6570\u306e\u5217<\/span><\/strong>\u3092\u57fa\u6e96\u306b\u4e26\u3079\u66ff\u3048\u3092\u5b9f\u65bd\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SORT\u95a2\u6570\u3067\u3082\u914d\u5217\u6570\u5f0f\u3084\u5165\u308c\u5b50\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u5b9f\u73fe\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u304c\u3001SORTBY\u95a2\u6570\u306e\u65b9\u304c\u5f15\u6570\u306e\u8a2d\u5b9a\u304c\u7c21\u5358\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3067\u4f7f\u3044\u65b9\u3092\u8a73\u3057\u304f\u7d39\u4ecb\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel wp-block-embed-excel\"><div class=\"wp-block-embed__wrapper\">\n<div><a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=84049\" class=\"st-cardlink st-embed-cardlink\"><div class=\"kanren st-cardbox\"><dl class=\"clearfix\"><dt class=\"st-card-img\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/11\/excel-sortby-function-how-to-use-introduction-1200x636.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">\u3010\u30a8\u30af\u30bb\u30eb\u3011SORTBY\u95a2\u6570\u3067\u8907\u6570\u306e\u5217\u3092\u4e26\u3079\u66ff\u3048\u3059\u308b\u65b9\u6cd5\u3002\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\u3082\u81ea\u52d5\u3067\u5bfe\u5fdc<\/p><div class=\"st-card-excerpt smanone\"><p>Excel(\u30a8\u30af\u30bb\u30eb)\u306eSORTBY\u95a2\u6570\u306f\u3001\u8907\u6570\u306e\u5217(\u884c)\u3092\u57fa\u6e96\u306b\u30c7\u30fc\u30bf\u3092\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u3002 \u300c\u30d5\u30a3\u30eb\u30bf &#8230;<\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Excel(\u30a8\u30af\u30bb\u30eb)\u306b\u306f\u30c7\u30fc\u30bf\u3092\u4e26\u3079\u66ff\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u300c\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u6a5f\u80fd\u3068\u300c\u4e26\u3079\u66ff\u3048\u300d\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3059\u3002 \u6700\u8fd1\u306b\u306a\u3063\u3066 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":84037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,24],"tags":[],"class_list":["post-83724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-24"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/83724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=83724"}],"version-history":[{"count":0,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/83724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/media\/84037"}],"wp:attachment":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=83724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=83724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=83724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}