{"id":367576,"date":"2024-09-24T14:14:32","date_gmt":"2024-09-24T13:14:32","guid":{"rendered":"https:\/\/learnesy.com\/?p=367576"},"modified":"2024-09-24T14:58:11","modified_gmt":"2024-09-24T13:58:11","slug":"veckans-tips-sokfalt-i-excel","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/veckans-tips-sokfalt-i-excel\/","title":{"rendered":"Veckans tips: S\u00f6kf\u00e4lt i Excel \ud83d\udd0d"},"content":{"rendered":"<p>I den h\u00e4r veckans tips l\u00e4r du dig att g\u00f6ra ett s\u00f6kf\u00e4lt f\u00f6r ditt kalkylblad i Excel. Utm\u00e4rkt n\u00e4r man snabbt beh\u00f6ver extrahera material. Den fullst\u00e4ndiga formeln och underlaget hittar du l\u00e4ngre ned i inl\u00e4gget.<\/p>\n<p><iframe loading=\"lazy\" title=\"Inb\u00e4ddat inl\u00e4gg\" src=\"https:\/\/www.linkedin.com\/embed\/feed\/update\/urn:li:ugcPost:7241733434853732352\" width=\"504\" height=\"605\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<hr \/>\n<span id=\"heading-formeln-i-sin-helhet\"><h3>Formeln i sin helhet<\/h3><\/span>\n<pre>=FILTER(H6:J36;\u00c4RTAL(HITTA(D3;H6:H36));)<\/pre>\n<p>Formeln filtrerar rader fr\u00e5n omr\u00e5det H6 och returnerar endast de rader d\u00e4r v\u00e4rdet i cell D3 kan hittas i kolumn H (H6). Om v\u00e4rdet fr\u00e5n cell D3 finns n\u00e5gonstans i en cell i kolumn H inkluderas den motsvarande raden i resultatet.<\/p>\n<p><a href=\"\/wp-content\/uploads\/2024\/09\/Sokfalt-i-Excel.xlsx\">H\u00e4r kan du ladda ned underlaget till videon.<\/a><\/p>\n<span id=\"heading-praktiska-exceltips\"><h3>Praktiska Exceltips<\/h3><\/span>\n<p>Du hittar \u00e4ven lektionen i v\u00e5r gratiskurs <a href=\"https:\/\/learnesy.com\/sv\/courses\/praktiska-exceltips\/\"><em>Praktiska Exceltips<\/em><\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Se veckans Excel-tips!<\/p>\n","protected":false},"author":54291,"featured_media":367579,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[],"class_list":["post-367576","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/367576","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\/54291"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=367576"}],"version-history":[{"count":5,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/367576\/revisions"}],"predecessor-version":[{"id":367609,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/367576\/revisions\/367609"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/367579"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=367576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=367576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=367576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}