{"id":96174,"date":"2021-09-07T10:47:36","date_gmt":"2021-09-07T08:47:36","guid":{"rendered":"https:\/\/learnesy.com\/?p=96174"},"modified":"2022-02-23T17:23:31","modified_gmt":"2022-02-23T15:23:31","slug":"se-video-filtrera-bort-kolumner-fran-ett-cellomrade-med-filter-funktionen","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/se-video-filtrera-bort-kolumner-fran-ett-cellomrade-med-filter-funktionen\/","title":{"rendered":"Se video: Filtrera bort kolumner fr\u00e5n ett cellomr\u00e5de med FILTER funktionen."},"content":{"rendered":"\r\n<p>Vanligtvis anv\u00e4nder vi FILTER f\u00f6r att filtrera bort rader som vi inte beh\u00f6ver se, men det g\u00e5r ocks\u00e5 att anv\u00e4nda funktionen p\u00e5 kolumner, s\u00e5 l\u00e4nge man f\u00f6rst\u00e5r hur man anv\u00e4nder flera funktioner i en formel.<\/p>\r\n\r\n\r\n\r\n<p>I v\u00e5rt exempel vill vi endast se den viktigaste informationen om var anst\u00e4lld ist\u00e4llet, och vi tar skapar en ny tabell med endast de kolumner vi vill se.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\">\r\n<div class=\"wp-block-embed__wrapper\">https:\/\/vimeo.com\/569334686<\/div>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Det h\u00e4r \u00e4r Excel p\u00e5 avancerad niv\u00e5. \u00c4r du inte h\u00e4r \u00e4n, s\u00e5 kan Learnesy hj\u00e4lpa dig med kurser inom tex.\u00a0<a href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Bas<\/a> eller <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excelfunktioner F\u00f6rdjupning<\/a>.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Vanligtvis anv\u00e4nder vi FILTER f\u00f6r att filtrera bort rader som vi inte beh\u00f6ver se, men det g\u00e5r ocks\u00e5 att anv\u00e4nda funktionen p\u00e5 kolumner, s\u00e5 l\u00e4nge man f\u00f6rst\u00e5r hur man anv\u00e4nder flera funktioner i en formel. [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":96176,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[218,247,208],"class_list":["post-96174","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-online","tag-excelfunktioner","tag-onlinekurs"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/96174","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\/41201"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=96174"}],"version-history":[{"count":5,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/96174\/revisions"}],"predecessor-version":[{"id":134502,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/96174\/revisions\/134502"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/96176"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=96174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=96174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=96174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}