{"id":1780,"date":"2022-09-05T09:02:00","date_gmt":"2022-09-05T14:02:00","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1780"},"modified":"2022-09-05T09:02:00","modified_gmt":"2022-09-05T14:02:00","slug":"sorting-with-functions-only","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1780","title":{"rendered":"Sorting with functions only"},"content":{"rendered":"\n<p>This one is similar to <a href=\"http:\/\/xlfxs.com\/sort-list-using-functions\/\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/xlfxs.com\/sort-list-using-functions\/<\/a> where we use some controls here that make it more user-friendly.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>We can push the dynamic sort more by adding CHOOSE function to (SMALL, LARGE and ROW)<\/p>\n\n\n\n<p><code>=CHOOSE($I$1,SMALL(Column1,ROW()-5),LARGE(Column1,ROW()-5))<\/code><\/p>\n\n\n\n<p>This way, we let user decide which order to sort, and when we push more, we can have user selects what columns to show, using simple VLOOKUP and MATCH functions &#8230;<\/p>\n\n\n\n<p><code>=VLOOKUP($B6,wholedb,MATCH(D$5,Heads,0),FALSE)<\/code><\/p>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/08\/Dynamic-sort-SMALL-ROW.xlsx\" style=\"border-radius:4px\">Download Spreadsheet<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO65Y3HAc1y5ae1hlI7A?e=E8IxZe\" style=\"border-radius:4px\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Online<\/a><\/div>\n<\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/08\/dynamic-sort1.jpg\"><img decoding=\"async\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/08\/dynamic-sort1.jpg\" alt=\"\" class=\"wp-image-1783\"\/><\/a><figcaption>Original list<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/08\/dynamic-sort2-1.jpg\"><img decoding=\"async\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/08\/dynamic-sort2-1.jpg\" alt=\"\" class=\"wp-image-1782\"\/><\/a><figcaption>Sorted list<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This one is similar to http:\/\/xlfxs.com\/sort-list-using-functions\/ where we use some controls here that make it more user-friendly.<\/p>\n","protected":false},"author":1,"featured_media":1781,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71,3,88,36,37,38,51,53,6,62],"tags":[],"class_list":["post-1780","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-choose","category-formulas","category-large","category-lookup_and_references","category-match","category-math-and-trig","category-row","category-small","category-standard_functions","category-vlookup"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1780"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1780\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1781"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}