{"id":98006,"date":"2021-09-21T15:44:03","date_gmt":"2021-09-21T13:44:03","guid":{"rendered":"https:\/\/learnesy.com\/?p=98006"},"modified":"2022-03-02T11:43:03","modified_gmt":"2022-03-02T09:43:03","slug":"se-video-kombinera-antal-om","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/se-video-kombinera-antal-om\/","title":{"rendered":"Se video: Kombinera ANTAL.OM"},"content":{"rendered":"<p>Kombinera ANTAL.OM med dynamiska matrisfunktionerna FILTER och SORTERA f\u00f6r att leta fram och visa de v\u00e4rden som f\u00f6rekommer i tv\u00e5 olika tabeller. Detta fungerar \u00e4ven n\u00e4r tabellerna inte \u00e4r sorterade efter v\u00e4rdena vi letar upp!<\/p>\n<p>I denna lektion g\u00e5r vi genom hur vi mellan tv\u00e5 listor kan hitta namn som f\u00f6rekommer i b\u00e5da listorna. Vi anv\u00e4nder filterfunktionen.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/569343949?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<p>Du hittar fler blogginl\u00e4gg med Exceltips under kategorin <a href=\"https:\/\/learnesy.com\/sv\/category\/tips\/\">Tips<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kombinera ANTAL.OM med dynamiska matrisfunktionerna FILTER och SORTERA f\u00f6r att leta fram och visa de v\u00e4rden som f\u00f6rekommer i tv\u00e5 olika tabeller. Detta fungerar \u00e4ven n\u00e4r tabellerna inte \u00e4r sorterade efter v\u00e4rdena vi letar upp! [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":98008,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[343,247,208,204],"class_list":["post-98006","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-antal-om","tag-excelfunktioner","tag-onlinekurs","tag-sortera"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/98006","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=98006"}],"version-history":[{"count":7,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/98006\/revisions"}],"predecessor-version":[{"id":135814,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/98006\/revisions\/135814"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/98008"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=98006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=98006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=98006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}