{"id":418,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/sort\/"},"modified":"2021-02-13T11:36:24","modified_gmt":"2021-02-13T11:36:24","slug":"sort","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/sort\/","title":{"rendered":"SORT"},"content":{"rendered":"

In Excel and Google Sheets, the SORT function is an invaluable tool for organizing a range or array of data. It allows sorting based on the values in one or more columns and can order data either ascendingly or descendingly, based on the criteria you define.<\/p>\n

Basic Syntax:<\/h2>\n

The syntax for the SORT function is consistent across both Excel and Google Sheets:<\/p>\n

=SORT(range, [sort_index], [sort_order], [range2], [sort_index2], [sort_order2], ...)<\/code><\/pre>\n
    \n
  • range<\/code>: The data range or array to be sorted.<\/li>\n
  • sort_index<\/code>: Specifies the column number or row number within the range on which to base the sort. The default is 1.<\/li>\n
  • sort_order<\/code>: Determines the sort direction; 1 for ascending or -1 for descending order, with a default of ascending order.<\/li>\n
  • range2<\/code>, sort_index2<\/code>, sort_order2<\/code>: Allows for additional ranges, sort indices, and orders for secondary sorting criteria.<\/li>\n<\/ul>\n
    Example Usage:<\/h2>\n
    Consider a dataset listing student scores across different subjects:<\/p>\n\n\n\n\n\n
    Student Name<\/th>\nMath Score<\/th>\nScience Score<\/th>\n<\/tr>\n
    John<\/td>\n85<\/td>\n90<\/td>\n<\/tr>\n
    Amy<\/td>\n78<\/td>\n88<\/td>\n<\/tr>\n
    David<\/td>\n92<\/td>\n80<\/td>\n<\/tr>\n<\/table>\n
    To sort the student data by Math scores in descending order, the formula is:<\/p>\n
    =SORT(A2:C4, 2, -1)<\/code><\/pre>\n
    This results in data arranged with the highest Math score at the top:<\/p>\n\n\n\n\n\n
    Student Name<\/th>\nMath Score<\/th>\nScience Score<\/th>\n<\/tr>\n
    David<\/td>\n92<\/td>\n80<\/td>\n<\/tr>\n
    John<\/td>\n85<\/td>\n90<\/td>\n<\/tr>\n
    Amy<\/td>\n78<\/td>\n88<\/td>\n<\/tr>\n<\/table>\n
    Applying Multiple Sorting Criteria:<\/h2>\n
    To sort first by Science scores and then by Math scores, both in descending order, use this formula:<\/p>\n
    =SORT(A2:C4, 3, -1, 2, -1)<\/code><\/pre>\n
    This approach first sorts the data by Science scores. Then, ties in Science scores are broken based on Math scores:<\/p>\n\n\n\n\n\n
    Student Name<\/th>\nMath Score<\/th>\nScience Score<\/th>\n<\/tr>\n
    John<\/td>\n85<\/td>\n90<\/td>\n<\/tr>\n
    Amy<\/td>\n78<\/td>\n88<\/td>\n<\/tr>\n
    David<\/td>\n92<\/td>\n80<\/td>\n<\/tr>\n<\/table>\n
    This demonstrates how the SORT function can be leveraged to efficiently organize data in Excel and Google Sheets according to specific sorting parameters.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Sorts the contents of a range or array<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[200],"tags":[],"class_list":["post-418","post","type-post","status-publish","format-standard","hentry","category-lookup-and-reference"],"acf":[],"yoast_head":"\nExcel SORT Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel SORT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/sort\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel SORT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel SORT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/sort\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:36:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel SORT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/sort\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/sort\/\",\"name\":\"Excel SORT Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:36:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel SORT function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/sort\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/sort\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/sort\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lookup and reference\",\"item\":\"https:\/\/functiontranslator.com\/en\/lookup-and-reference\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SORT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel SORT Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel SORT function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/sort\/","og_locale":"en_US","og_type":"article","og_title":"Excel SORT Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel SORT function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/sort\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:36:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel SORT Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/sort\/","url":"https:\/\/functiontranslator.com\/en\/sort\/","name":"Excel SORT Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:36:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel SORT function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/sort\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/sort\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/sort\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Lookup and reference","item":"https:\/\/functiontranslator.com\/en\/lookup-and-reference\/"},{"@type":"ListItem","position":3,"name":"SORT"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/418\/revisions"}],"predecessor-version":[{"id":3309,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/418\/revisions\/3309"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}