{"id":74353,"date":"2024-11-15T16:16:46","date_gmt":"2024-11-15T16:16:46","guid":{"rendered":"https:\/\/goodwriterz.com\/site\/?p=74353"},"modified":"2024-11-15T16:16:46","modified_gmt":"2024-11-15T16:16:46","slug":"%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d9%88%d8%b8%d9%8a%d9%81%d8%a9-microsoft-excel-sort","status":"publish","type":"post","link":"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d9%88%d8%b8%d9%8a%d9%81%d8%a9-microsoft-excel-sort\/","title":{"rendered":"\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0648\u0638\u064a\u0641\u0629 Microsoft Excel SORT"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u062a\u0648\u064a\u0627\u062a<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d9%88%d8%b8%d9%8a%d9%81%d8%a9-microsoft-excel-sort\/#%D8%B1%D9%88%D8%A7%D8%A8%D8%B7_%D8%B3%D8%B1%D9%8A%D8%B9%D8%A9\" title=\"\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629\">\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d9%88%d8%b8%d9%8a%d9%81%d8%a9-microsoft-excel-sort\/#%D8%A7%D9%84%D9%88%D8%AC%D8%A8%D8%A7%D8%AA_%D8%A7%D9%84%D8%B3%D8%B1%D9%8A%D8%B9%D8%A9_%D8%A7%D9%84%D8%B1%D8%A6%D9%8A%D8%B3%D9%8A%D8%A9\" title=\"\u0627\u0644\u0648\u062c\u0628\u0627\u062a \u0627\u0644\u0633\u0631\u064a\u0639\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629\">\u0627\u0644\u0648\u062c\u0628\u0627\u062a \u0627\u0644\u0633\u0631\u064a\u0639\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d9%88%d8%b8%d9%8a%d9%81%d8%a9-microsoft-excel-sort\/#%D8%AD%D9%88%D9%84_%D8%B5%D9%8A%D8%BA%D8%A9_Excel_SORT\" title=\"\u062d\u0648\u0644 \u0635\u064a\u063a\u0629 Excel SORT\">\u062d\u0648\u0644 \u0635\u064a\u063a\u0629 Excel SORT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d9%88%d8%b8%d9%8a%d9%81%d8%a9-microsoft-excel-sort\/#%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D9%85_%D9%88%D8%B8%D9%8A%D9%81%D8%A9_%D8%A7%D9%84%D9%81%D8%B1%D8%B2_%D9%81%D9%8A_Excel\" title=\"\u0627\u0633\u062a\u062e\u062f\u0645 \u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0641\u0631\u0632 \u0641\u064a Excel\">\u0627\u0633\u062a\u062e\u062f\u0645 \u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0641\u0631\u0632 \u0641\u064a Excel<\/a><\/li><\/ul><\/nav><\/div>\n<div>\n<div class=\"w-table-content\">\n<h3 class=\"title icon i-flash\"><span class=\"ez-toc-section\" id=\"%D8%B1%D9%88%D8%A7%D8%A8%D8%B7_%D8%B3%D8%B1%D9%8A%D8%B9%D8%A9\"><\/span>\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"table-content\">\n<div class=\"w-table-content-list\">\n<ul class=\"table-content-list\">\n<li class=\"table-content-element icon\">\n<div class=\"table-content-link\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"#about-the-excel-sort-formula\">\u062d\u0648\u0644 \u0635\u064a\u063a\u0629 Excel SORT<\/a> <\/div>\n<\/li>\n<\/ul>\n<ul class=\"table-content-list\">\n<li class=\"table-content-element icon\">\n<div class=\"table-content-link\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"#use-the-excel-sort-function\">\u0627\u0633\u062a\u062e\u062f\u0645 \u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0641\u0631\u0632 \u0641\u064a Excel<\/a> <\/div>\n<\/li>\n<\/ul><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-key-points\">\n<div class=\"emaki-custom key-points\" id=\"custom_block_0\">\n<h3 class=\"title icon i-list\"><span class=\"ez-toc-section\" id=\"%D8%A7%D9%84%D9%88%D8%AC%D8%A8%D8%A7%D8%AA_%D8%A7%D9%84%D8%B3%D8%B1%D9%8A%D8%B9%D8%A9_%D8%A7%D9%84%D8%B1%D8%A6%D9%8A%D8%B3%D9%8A%D8%A9\"><\/span>\u0627\u0644\u0648\u062c\u0628\u0627\u062a \u0627\u0644\u0633\u0631\u064a\u0639\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"custom_block-content key-points\">\n<p>\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 SORT \u0641\u064a Excel\u060c \u0642\u0645 \u0628\u0625\u062f\u0631\u0627\u062c \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629 \u0641\u064a \u062e\u0644\u064a\u0629: SORT(range, Index, order, by_column). \u0633\u062a\u0642\u0648\u0645 \u0648\u0638\u064a\u0641\u0629 SORT \u0628\u0641\u0631\u0632 \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u062f\u0648\u0646 \u0627\u0644\u0625\u0636\u0631\u0627\u0631 \u0628\u0645\u062c\u0645\u0648\u0639\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0623\u0635\u0644\u064a\u0629.<\/p>\n<\/div><\/div>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":0,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":0,\"nbrPlacementsScanned\":0,\"ruleCount\":200,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":240} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":0,\"ruleCount\":200,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":200,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/section>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":0} --><br \/>\n<!-- No winning ad found for zone: below first paragraph! --><\/p>\n<p>\u0628\u064a\u0646\u0645\u0627 \u064a\u0642\u062f\u0645 Microsoft Excel \u0623\u062f\u0627\u0629 \u0645\u062f\u0645\u062c\u0629 \u0644\u0641\u0631\u0632 \u0628\u064a\u0627\u0646\u0627\u062a\u0643\u060c \u0641\u0642\u062f \u062a\u0641\u0636\u0644 \u0645\u0631\u0648\u0646\u0629 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0648\u0627\u0644\u0635\u064a\u063a\u0629. \u0633\u0646\u0648\u0636\u062d \u0644\u0643 \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0648\u0638\u064a\u0641\u0629 Excel SORT \u0645\u0639 \u0623\u0645\u062b\u0644\u0629 \u0645\u0641\u064a\u062f\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":198} --><\/p>\n<p>\u062a\u062a\u0645\u062b\u0644 \u0641\u0627\u0626\u062f\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 SORT \u0641\u064a \u0623\u0646\u0647 \u064a\u0645\u0643\u0646\u0643 \u0641\u0631\u0632 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a \u0645\u0643\u0627\u0646 \u0645\u062e\u062a\u0644\u0641. \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u062f\u0648\u0646 \u0627\u0644\u0625\u062e\u0644\u0627\u0644 \u0628\u0645\u062c\u0645\u0648\u0639\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0623\u0635\u0644\u064a\u0629\u060c \u0641\u0633\u0648\u0641 \u062a\u062d\u0628 \u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0641\u0631\u0632 \u0641\u064a Excel. \u0648\u0645\u0639 \u0630\u0644\u0643\u060c \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0641\u0636\u0644 \u0641\u0631\u0632 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0641\u064a \u0645\u0643\u0627\u0646\u0647\u0627\u060c \u0641\u064a\u062c\u0628 \u0639\u0644\u064a\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u064a\u0632\u0629 \u0627\u0644\u0641\u0631\u0632 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0630\u0644\u0643.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":501} --><br \/>\n<!-- No winning ad found for zone: native in content! --><\/p>\n<h2 id=\"about-the-excel-sort-formula\"><span class=\"ez-toc-section\" id=\"%D8%AD%D9%88%D9%84_%D8%B5%D9%8A%D8%BA%D8%A9_Excel_SORT\"><\/span>  \u062d\u0648\u0644 \u0635\u064a\u063a\u0629 Excel SORT <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0646\u0627\u0621 \u062c\u0645\u0644\u0629 \u0635\u064a\u063a\u0629 \u0641\u0631\u0632 Excel \u0647\u0648 <\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":542} --><\/p>\n<pre><code class=\"hljs \">SORT(range, index, order, by_column)<\/code> <\/pre>\n<p>  \u062d\u064a\u062b \u062a\u0643\u0648\u0646 \u0627\u0644\u0648\u0633\u064a\u0637\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u0645\u0637\u0644\u0648\u0628\u0629 \u0641\u0642\u0637.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":585} --><\/p>\n<p>\u0625\u0630\u0627 \u0643\u0646\u062a \u0645\u0647\u062a\u0645\u064b\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0648\u0633\u0627\u0626\u0637 \u0627\u0644\u0627\u062e\u062a\u064a\u0627\u0631\u064a\u0629\u060c \u0641\u0625\u0644\u064a\u0643 \u0643\u064a\u0641\u064a\u0629 \u0639\u0645\u0644\u0647\u0627:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":660} --><\/p>\n<ul>\n<li><b>\u0641\u0650\u0647\u0631\u0650\u0633<\/b><strong>:<\/strong> \u0623\u062f\u062e\u0644 \u0631\u0642\u0645\u064b\u0627 \u064a\u0645\u062b\u0644 \u0627\u0644\u0635\u0641 \u0623\u0648 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0630\u064a \u0633\u064a\u062a\u0645 \u0627\u0644\u0641\u0631\u0632 \u062d\u0633\u0628\u0647. \u064a\u0642\u0648\u0645 \u0628\u0631\u0646\u0627\u0645\u062c Excel \u0628\u0627\u0644\u0641\u0631\u0632 \u062d\u0633\u0628 \u0627\u0644\u0635\u0641 1 \u0648\u0627\u0644\u0639\u0645\u0648\u062f 1 \u0628\u0634\u0643\u0644 \u0627\u0641\u062a\u0631\u0627\u0636\u064a. <\/li>\n<li><b>\u0637\u0644\u0628<\/b><strong>:<\/strong> \u0623\u062f\u062e\u0644 1 \u0644\u0644\u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u062a\u0635\u0627\u0639\u062f\u064a \u0648\u0647\u0648 \u0627\u0644\u0625\u0639\u062f\u0627\u062f \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a \u0625\u0630\u0627 \u062a\u0645 \u062d\u0630\u0641\u0647\u060c \u0623\u0648 -1 \u0644\u0644\u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u062a\u0646\u0627\u0632\u0644\u064a. <\/li>\n<li><b>By_colum<\/b><strong>\u0646:<\/strong> \u0623\u062f\u062e\u0644 &#8220;\u062e\u0637\u0623&#8221; \u0644\u0644\u0641\u0631\u0632 \u062d\u0633\u0628 \u0627\u0644\u0635\u0641\u060c \u0648\u0647\u0648 \u0627\u0644\u0625\u0639\u062f\u0627\u062f \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a \u0625\u0630\u0627 \u062a\u0645 \u062d\u0630\u0641\u0647\u060c \u0623\u0648 \u0623\u062f\u062e\u0644 &#8220;\u0635\u062d\u064a\u062d&#8221; \u0644\u0644\u0641\u0631\u0632 \u062d\u0633\u0628 \u0627\u0644\u0639\u0645\u0648\u062f. \u0647\u0630\u0627 \u064a\u062d\u062f\u062f \u0627\u062a\u062c\u0627\u0647 \u0627\u0644\u0646\u0648\u0639. <\/li>\n<\/ul>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":1010} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/p>\n<p>\u0627\u0644\u0622\u0646\u060c \u062f\u0639\u0648\u0646\u0627 \u0646\u0644\u0642\u064a \u0646\u0638\u0631\u0629 \u0639\u0644\u0649 \u0627\u0644\u0623\u0645\u062b\u0644\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 SORT \u0641\u064a Excel.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":61} --><\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":61} --><\/p>\n<h2 id=\"use-the-excel-sort-function\"><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D9%85_%D9%88%D8%B8%D9%8A%D9%81%D8%A9_%D8%A7%D9%84%D9%81%D8%B1%D8%B2_%D9%81%D9%8A_Excel\"><\/span>  \u0627\u0633\u062a\u062e\u062f\u0645 \u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0641\u0631\u0632 \u0641\u064a Excel <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 SORT \u0644\u0646\u0637\u0627\u0642 \u0623\u0648 \u0635\u0641\u064a\u0641 \u0641\u064a Excel. \u0645\u0631\u0629 \u0623\u062e\u0631\u0649\u060c \u0644\u0627 \u064a\u0624\u062f\u064a \u0647\u0630\u0627 \u0625\u0644\u0649 \u0641\u0631\u0632 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0641\u064a \u0645\u0643\u0627\u0646\u0647\u0627 \u0648\u0644\u0643\u0646 \u0641\u064a \u0627\u0644\u0645\u0643\u0627\u0646 \u0627\u0644\u0630\u064a \u062a\u062f\u062e\u0644 \u0641\u064a\u0647 \u0627\u0644\u0635\u064a\u063a\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":212} --><\/p>\n<p><span class=\"related-single\">\u0630\u0627\u062a \u0635\u0644\u0629: \u0643\u064a\u0641\u064a\u0629 \u0633\u0631\u062f \u0648\u0641\u0631\u0632 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0648\u0627\u0644\u0646\u0635 \u0641\u064a Microsoft Excel<\/span><\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":283} --><\/p>\n<p>\u0644\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0645\u062b\u0627\u0644 \u0623\u0633\u0627\u0633\u064a\u060c \u0633\u0646\u0642\u0648\u0645 \u0628\u0628\u0633\u0627\u0637\u0629 \u0628\u0641\u0631\u0632 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0645\u0646 A2 \u0625\u0644\u0649 A6 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0644\u0644\u0648\u0633\u0627\u0626\u0637 \u0627\u0644\u0627\u062e\u062a\u064a\u0627\u0631\u064a\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":401} --><\/p>\n<pre>=SORT(A2:A6)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":413} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"434\" height=\"242\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 SORT \u0644\u0646\u0637\u0627\u0642 \u062e\u0644\u064a\u0629 \u0648\u0627\u062d\u062f\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/\u0643\u064a\u0641\u064a\u0629-\u0627\u0633\u062a\u062e\u062f\u0627\u0645-\u0648\u0638\u064a\u0641\u0629-Microsoft-Excel-SORT.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D9%88%D8%B8%D9%8A%D9%81%D8%A9-Microsoft-Excel-SORT.png?resize=434%2C242&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":653} --><\/p>\n<p>\u0644\u0641\u0631\u0632 \u0646\u0637\u0627\u0642 \u0623\u0648\u0633\u0639\u060c \u0633\u0646\u0642\u0648\u0645 \u0628\u062a\u0636\u0645\u064a\u0646 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0645\u0646 B2 \u0625\u0644\u0649 B6 \u0623\u064a\u0636\u064b\u0627:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":722} --><\/p>\n<pre>=SORT(A2:B6)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":734} --><\/p>\n<p>\u0643\u0645\u0627 \u062a\u0631\u0648\u0646\u060c \u062a\u0638\u0644 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0645\u0642\u062a\u0631\u0646\u0629 \u0628\u0635\u0641\u0627\u062a\u0647\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":797} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":797,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":103,\"nextBlockCount\":240,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1037} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"454\" height=\"242\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 SORT \u0644\u0645\u062c\u0645\u0648\u0639\u0629 \u0623\u0643\u0628\u0631 \u0645\u0646 \u0627\u0644\u062e\u0644\u0627\u064a\u0627\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_769_\u0643\u064a\u0641\u064a\u0629-\u0627\u0633\u062a\u062e\u062f\u0627\u0645-\u0648\u0638\u064a\u0641\u0629-Microsoft-Excel-SORT.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_769_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D9%88%D8%B8%D9%8A%D9%81%D8%A9-Microsoft-Excel-SORT.png?resize=454%2C242&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":137} --><\/p>\n<p>\u0633\u0646\u0642\u0648\u0645 \u0627\u0644\u0622\u0646 \u0628\u0641\u0631\u0632 \u0627\u0644\u0646\u0637\u0627\u0642 \u062d\u0633\u0628 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u062b\u0627\u0646\u064a \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0627\u0644\u0623\u0648\u0644. \u0644\u0630\u0644\u0643\u060c \u0646\u062f\u062e\u0644 2 \u0644 <code>index<\/code> \u062f\u0639\u0648\u0649:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":244} --><\/p>\n<pre>=SORT(A2:B6,2)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":258} --><\/p>\n<p>\u064a\u0645\u0643\u0646\u0643 \u0623\u0646 \u062a\u0631\u0649 \u0623\u0646 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0646\u0627 \u0645\u0631\u062a\u0628\u0629 \u062a\u0635\u0627\u0639\u062f\u064a\u064b\u0627 \u062d\u0633\u0628 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u062b\u0627\u0646\u064a\u060c \u0645\u0639 \u0627\u0644\u0623\u062e\u0636\u0631 \u0623\u0648\u0644\u0627\u064b \u0648\u0627\u0644\u0623\u0635\u0641\u0631 \u0623\u062e\u064a\u0631\u064b\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":370} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"452\" height=\"242\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 SORT \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u062b\u0627\u0646\u064a\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_672_\u0643\u064a\u0641\u064a\u0629-\u0627\u0633\u062a\u062e\u062f\u0627\u0645-\u0648\u0638\u064a\u0641\u0629-Microsoft-Excel-SORT.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_672_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D9%88%D8%B8%D9%8A%D9%81%D8%A9-Microsoft-Excel-SORT.png?resize=452%2C242&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":610} --><\/p>\n<p>\u0628\u0639\u062f \u0630\u0644\u0643\u060c \u0633\u0648\u0641 \u0646\u0633\u062a\u062e\u062f\u0645 \u0645\u062b\u0627\u0644\u0627\u064b \u0645\u0639 <code>order<\/code> \u0627\u0644\u0648\u0633\u064a\u0637\u0629 \u0648\u0641\u0631\u0632 \u0645\u0635\u0641\u0648\u0641\u062a\u0646\u0627 \u0628\u062a\u0631\u062a\u064a\u0628 \u062a\u0646\u0627\u0632\u0644\u064a \u0639\u0646 \u0637\u0631\u064a\u0642 \u062a\u0636\u0645\u064a\u0646 -1:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":716} --><\/p>\n<pre>=SORT(A2:B6,,-1)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":732} --><\/p>\n<p>\u0644\u0627\u062d\u0638 \u0623\u0646\u0646\u0627 \u0646\u062a\u0631\u0643 <code>index<\/code> \u0627\u0644\u0648\u0633\u064a\u0637\u0629 \u0641\u0627\u0631\u063a\u0629 \u0644\u0623\u0646 Excel \u064a\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0635\u0641 \u0648\u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0623\u0648\u0644 \u0628\u0634\u0643\u0644 \u0627\u0641\u062a\u0631\u0627\u0636\u064a. \u0643\u0645\u0627 \u0647\u0648 \u0645\u0642\u0635\u0648\u062f\u060c \u0644\u062f\u064a\u0646\u0627 Tangerine \u0623\u0648\u0644\u0627\u064b \u0648Apple \u0623\u062e\u064a\u0631\u064b\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":886} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":886,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":14,\"nextBlockCount\":240,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1126} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"463\" height=\"242\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 SORT \u0644\u0644\u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u062a\u0646\u0627\u0632\u0644\u064a\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_362_\u0643\u064a\u0641\u064a\u0629-\u0627\u0633\u062a\u062e\u062f\u0627\u0645-\u0648\u0638\u064a\u0641\u0629-Microsoft-Excel-SORT.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_362_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D9%88%D8%B8%D9%8A%D9%81%D8%A9-Microsoft-Excel-SORT.png?resize=463%2C242&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":226} --><\/p>\n<p>\u0644\u0644\u0641\u0631\u0632 \u0628\u062a\u0631\u062a\u064a\u0628 \u062a\u0646\u0627\u0632\u0644\u064a \u062d\u0633\u0628 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u062b\u0627\u0646\u064a\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":299} --><\/p>\n<pre>=SORT(A2:B6,2,-1)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":316} --><\/p>\n<p>\u0647\u0646\u0627\u060c \u0646\u0642\u0648\u0645 \u0628\u062a\u0636\u0645\u064a\u0646 2 \u0644\u0640 <code>index<\/code> \u0627\u0644\u0648\u0633\u064a\u0637\u0629 \u0648 -1 \u0644\u0640 <code>order<\/code> \u062f\u0639\u0648\u0649. \u0648\u0643\u0645\u0627 \u0647\u0648 \u0645\u062a\u0648\u0642\u0639\u060c \u0646\u0631\u0649 \u0627\u0644\u0644\u0648\u0646 \u0627\u0644\u0623\u0635\u0641\u0631 \u0623\u0648\u0644\u0627\u064b \u0648\u0627\u0644\u0623\u062e\u0636\u0631 \u0623\u062e\u064a\u0631\u064b\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":441} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"484\" height=\"242\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 SORT \u0644\u0644\u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u062a\u0646\u0627\u0632\u0644\u064a \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u062b\u0627\u0646\u064a\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_138_\u0643\u064a\u0641\u064a\u0629-\u0627\u0633\u062a\u062e\u062f\u0627\u0645-\u0648\u0638\u064a\u0641\u0629-Microsoft-Excel-SORT.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687403_138_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D9%88%D8%B8%D9%8A%D9%81%D8%A9-Microsoft-Excel-SORT.png?resize=484%2C242&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":681} --><\/p>\n<p>\u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644 \u0627\u0644\u0623\u062e\u064a\u0631\u060c \u0633\u0646\u0642\u0648\u0645 \u0628\u062a\u0636\u0645\u064a\u0646 \u0642\u064a\u0645\u0629 \u0644\u0643\u0644 \u0648\u0633\u064a\u0637\u0629 \u062d\u062a\u0649 \u062a\u062a\u0645\u0643\u0646 \u0645\u0646 \u0631\u0624\u064a\u0629 \u0643\u064a\u0641\u064a\u0629 \u0639\u0645\u0644\u0647\u0627 \u062c\u0645\u064a\u0639\u064b\u0627 \u0645\u0639\u064b\u0627. \u0633\u0646\u0642\u0648\u0645 \u0628\u0625\u062f\u062e\u0627\u0644 \u0645\u0635\u0641\u0648\u0641\u0629 \u0623\u0643\u0628\u0631 \u0645\u0646 A2 \u0625\u0644\u0649 C6\u060c \u06483 \u0644\u0644\u0641\u0631\u0632 \u062d\u0633\u0628 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u062b\u0627\u0644\u062b\u060c \u06481 \u0644\u0644\u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u062a\u0635\u0627\u0639\u062f\u064a\u060c \u0648\u062e\u0637\u0623 \u0644\u0644\u0641\u0631\u0632 \u062d\u0633\u0628 \u0627\u062a\u062c\u0627\u0647 \u0627\u0644\u0635\u0641.<\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":929} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/p>\n<pre>=SORT(A2:C6,3,1,FALSE)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":22} --><\/p>\n<p>\u064a\u062a\u0645 \u0641\u0631\u0632 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0644\u062f\u064a\u0646\u0627 \u062d\u0633\u0628 \u0639\u0645\u0648\u062f \u0627\u0644\u062a\u0642\u064a\u064a\u0645\u060c \u0648\u0643\u0645\u0627 \u0647\u0648 \u0627\u0644\u062d\u0627\u0644 \u0641\u064a \u0627\u0644\u0623\u0645\u062b\u0644\u0629 \u0627\u0644\u0623\u062e\u0631\u0649 \u0623\u0639\u0644\u0627\u0647\u060c \u062a\u0628\u0642\u0649 \u0645\u0639 \u0633\u0645\u0627\u062a\u0647\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":127} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"627\" height=\"242\" loading=\"lazy\" alt=\"\u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 SORT \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062c\u0645\u064a\u0639 \u0627\u0644\u0648\u0633\u0627\u0626\u0637\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687404_335_\u0643\u064a\u0641\u064a\u0629-\u0627\u0633\u062a\u062e\u062f\u0627\u0645-\u0648\u0638\u064a\u0641\u0629-Microsoft-Excel-SORT.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731687404_335_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D9%88%D8%B8%D9%8A%D9%81%D8%A9-Microsoft-Excel-SORT.png?resize=627%2C242&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":367} --><\/p>\n<p>\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0635\u064a\u063a\u0629 Excel SORT\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0637\u0631\u064a\u0642\u0629 \u0639\u0631\u0636 \u0645\u062e\u062a\u0644\u0641\u0629 \u0644\u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0627\u0644\u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u0630\u064a \u062a\u0631\u064a\u062f \u0631\u0624\u064a\u0629 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0641\u064a\u0647. \u0648\u0647\u0630\u0627 \u064a\u062c\u0639\u0644\u0647\u0627 \u0623\u062f\u0627\u0629 \u0645\u0641\u064a\u062f\u0629 \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":530} --><\/p>\n<p>\u0644\u0644\u0645\u0632\u064a\u062f\u060c \u0631\u0627\u062c\u0639 \u0643\u064a\u0641\u064a\u0629 \u0627\u0644\u0641\u0631\u0632 \u062d\u0633\u0628 \u0627\u0644\u0644\u0648\u0646 \u0623\u0648 \u0643\u064a\u0641\u064a\u0629 \u0627\u0644\u0641\u0631\u0632 \u062d\u0633\u0628 \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0641\u064a Excel.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":603} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":923} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/div>\n<p>    (\u0627\u0644\u0639\u0644\u0627\u0645\u0627\u062a \u0644\u0644\u062a\u0631\u062c\u0645\u0629)\u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a \u0623\u0648\u0641\u064a\u0633(\u0631)\u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a \u0625\u0643\u0633\u0644(\u0631)\u0645\u064a\u0632\u0627\u062a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629 \u062d\u0648\u0644 \u0635\u064a\u063a\u0629 Excel SORT \u0627\u0633\u062a\u062e\u062f\u0645 \u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0641\u0631\u0632 \u0641\u064a Excel \u0627\u0644\u0648\u062c\u0628\u0627\u062a \u0627\u0644\u0633\u0631\u064a\u0639\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 SORT \u0641\u064a Excel\u060c \u0642\u0645 \u0628\u0625\u062f\u0631\u0627\u062c \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629 \u0641\u064a \u062e\u0644\u064a\u0629: SORT(range, Index, order, by_column). \u0633\u062a\u0642\u0648\u0645 \u0648\u0638\u064a\u0641\u0629 SORT \u0628\u0641\u0631\u0632 \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u062f\u0648\u0646 \u0627\u0644\u0625\u0636\u0631\u0627\u0631 \u0628\u0645\u062c\u0645\u0648\u0639\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0623\u0635\u0644\u064a\u0629. \u0628\u064a\u0646\u0645\u0627 \u064a\u0642\u062f\u0645 Microsoft Excel \u0623\u062f\u0627\u0629 \u0645\u062f\u0645\u062c\u0629 \u0644\u0641\u0631\u0632 \u0628\u064a\u0627\u0646\u0627\u062a\u0643\u060c \u0641\u0642\u062f \u062a\u0641\u0636\u0644 \u0645\u0631\u0648\u0646\u0629 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0648\u0627\u0644\u0635\u064a\u063a\u0629. \u0633\u0646\u0648\u0636\u062d \u0644\u0643 \u0643\u064a\u0641\u064a\u0629 &#8230; <a title=\"\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0648\u0638\u064a\u0641\u0629 Microsoft Excel SORT\" class=\"read-more\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d9%88%d8%b8%d9%8a%d9%81%d8%a9-microsoft-excel-sort\/\" aria-label=\"Read more about \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0648\u0638\u064a\u0641\u0629 Microsoft Excel SORT\">\u0625\u0642\u0631\u0623 \u0627\u0644\u0645\u0632\u064a\u062f<\/a><\/p>\n","protected":false},"author":1,"featured_media":74354,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[322,288,226],"class_list":["post-74353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","tag-features","tag-microsoft-excel","tag-microsoft-office"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D9%88%D8%B8%D9%8A%D9%81%D8%A9-Microsoft-Excel-SORT.jpg?fit=1200%2C675&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/74353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/comments?post=74353"}],"version-history":[{"count":1,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/74353\/revisions"}],"predecessor-version":[{"id":74355,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/74353\/revisions\/74355"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media\/74354"}],"wp:attachment":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media?parent=74353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/categories?post=74353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/tags?post=74353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}