{"id":88287,"date":"2021-06-08T10:33:32","date_gmt":"2021-06-08T08:33:32","guid":{"rendered":"https:\/\/learnesy.com\/?p=88287"},"modified":"2022-03-02T12:41:15","modified_gmt":"2022-03-02T10:41:15","slug":"video-skapa-en-sorteringshierarki-med-sorteraefter","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/video-skapa-en-sorteringshierarki-med-sorteraefter\/","title":{"rendered":"Video: Skapa en sorteringshierarki med SORTERAEFTER\u00a0"},"content":{"rendered":"<p><strong><u>F\u00f6rra veckan introducerade vi er f\u00f6r\u00a0Excels dynamiska matrisformler.<\/u><\/strong><\/p>\n<p>Dessa formler till\u00e5ter oss att bearbeta flera v\u00e4rden i en och samma formel och g\u00f6r s\u00e5 att vi kan arbeta med data p\u00e5 ett helt nytt s\u00e4tt. F\u00f6rst ut bland dessa formler var SORTERA-funktionen och en naturlig forts\u00e4ttning \u00e4r funktionen SORTERAEFTER.<\/p>\n<p><!--{cke_protected}{C}%3C!%2D%2D%20%2Fwp%3Aparagraph%20%2D%2D%3E--><!--{cke_protected}{C}%3C!%2D%2D%20wp%3Aparagraph%20%2D%2D%3E--><\/p>\n<p>Och som vi n\u00e4mnde f\u00f6rra veckan, med dynamiska matrisfunktioner kommer ett beteende som kallas \u201dSpill\u201d. Vilket inneb\u00e4r att n\u00e4r man anv\u00e4nder formler som returnerar flera v\u00e4rden samtidigt f\u00e5r man\u00a0resultat som &#8221;sv\u00e4mmar \u00f6ver&#8221; till andra motsvarande celler.<\/p>\n<p><strong><u>SORTERAEFTER\u00a0<\/u><\/strong>skapar en sorteringshierarki i ett cellomr\u00e5de (ocks\u00e5 kallat matris) baserat p\u00e5 flera angivna kolumner och sorteringsordningar. Funktionen liknar f\u00f6rra veckans SORTERA, men uppbyggnaden kan f\u00f6r vissa vara sn\u00e4ppet enklare att begripa och anv\u00e4nda. Dessutom \u00e4r funktionen l\u00e4ttare att fiffla med i efterhand, vilket kan vara anv\u00e4ndbart f\u00f6r st\u00e4ndigt v\u00e4xande databaser!<\/p>\n<p>&nbsp;<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/558001311?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>F\u00f6rra veckan introducerade vi er f\u00f6r\u00a0Excels dynamiska matrisformler. Dessa formler till\u00e5ter oss att bearbeta flera v\u00e4rden i en och samma formel och g\u00f6r s\u00e5 att vi kan arbeta med data p\u00e5 ett helt nytt s\u00e4tt. [&hellip;]<\/p>\n","protected":false},"author":26679,"featured_media":88294,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[218,247,65,189],"class_list":["post-88287","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-online","tag-excelfunktioner","tag-excelkurs","tag-sorteraefter"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/88287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/26679"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=88287"}],"version-history":[{"count":4,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/88287\/revisions"}],"predecessor-version":[{"id":88300,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/88287\/revisions\/88300"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/88294"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=88287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=88287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=88287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}