{"id":86962,"date":"2021-06-01T10:01:23","date_gmt":"2021-06-01T08:01:23","guid":{"rendered":"https:\/\/learnesy.com\/?p=86962"},"modified":"2022-03-02T15:12:40","modified_gmt":"2022-03-02T13:12:40","slug":"sortera-funktionen-later-dig-sortera","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/sortera-funktionen-later-dig-sortera\/","title":{"rendered":"Video: SORTERA-funktionen, l\u00e5ter dig sortera efter flera villkor!"},"content":{"rendered":"\r\n<p>De kommande veckorna kommer vi att introducera Excels 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.<\/p>\r\n\r\n\r\n\r\n<p><br \/>Med dynamiska matrisfunktioner kommer ett beteende som kallas \u201dSpill\u201d. Anv\u00e4nder man formler som returnerar flera v\u00e4rden samtidigt kommer man ocks\u00e5 f\u00e5 resultat som &#8221;sv\u00e4mmar \u00f6ver&#8221; till andra motsvarande celler. Se exempel p\u00e5 detta beteende i slutet p\u00e5 dagens lektion: SORTERA!<br \/>Anv\u00e4nd SORTERA funktionen f\u00f6r att sortera efter flera villkor p\u00e5 samma g\u00e5ng, med en och samma funktion!<br \/>Att manuellt skapa en sorteringshierarki kan vara klurigt, men med hj\u00e4lp av SORTERA och matrisfunktionalitet blir jobbet mycket l\u00e4ttare.<\/p>\r\n<p><div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/557152985?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div><\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>De kommande veckorna kommer vi att introducera Excels 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 [&hellip;]<\/p>\n","protected":false},"author":26679,"featured_media":86963,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[74,218,247,65,204],"class_list":["post-86962","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-3","tag-excel-online","tag-excelfunktioner","tag-excelkurs","tag-sortera"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/86962","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=86962"}],"version-history":[{"count":4,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/86962\/revisions"}],"predecessor-version":[{"id":135841,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/86962\/revisions\/135841"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/86963"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=86962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=86962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=86962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}