{"id":92756,"date":"2021-08-19T13:42:46","date_gmt":"2021-08-19T11:42:46","guid":{"rendered":"https:\/\/learnesy.com\/?p=92756"},"modified":"2022-02-25T16:16:39","modified_gmt":"2022-02-25T14:16:39","slug":"se-video-xmatchning","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/se-video-xmatchning\/","title":{"rendered":"Se Video: Xmatchning"},"content":{"rendered":"\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"350\" class=\"wp-image-92476\" src=\"https:\/\/learnesy.com\/wp-content\/uploads\/2021\/08\/xmatchning-learnesy.png\" alt=\"Excel\" srcset=\"\/wp-content\/uploads\/2021\/08\/xmatchning-learnesy.png 600w, \/wp-content\/uploads\/2021\/08\/xmatchning-learnesy-300x175.png 300w, \/wp-content\/uploads\/2021\/08\/xmatchning-learnesy-400x233.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Vi forts\u00e4tter \u00e4ven denna vecka med matrisfunktioner, lek i Excel och prova sj\u00e4lv!\u00a0<\/p>\r\n\r\n\r\n\r\n<p>P\u00e5minnelse om att matrisfunktionerna plus exempellektioner (totalt 12 lektioner)\u00a0nu finns i v\u00e5r kurs Excelfunktioner F\u00f6rdjupning.<\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">L\u00e4s mer om\u00a0kursen h\u00e4r \u2013 EXCELFUNKTIONER F\u00d6RDJUPNING<\/a><\/p>\r\n\r\n\r\n\r\n<p>Excel har en ny PASSA funktion i form av XMATCHNING! Anv\u00e4nd XMATCHNING f\u00f6r att hitta den relativa positionen av ett v\u00e4rde du s\u00f6ker efter, men med lite extra funktionalitet. I dagens exempel kombinerar vi funktionen med INDEX f\u00f6r att skapa en omv\u00e4nd s\u00f6kning, som i st\u00e4llet f\u00f6r att s\u00f6ka f\u00f6rsta till sista s\u00f6ker den sista till f\u00f6rsta! Listan \u00e4r s\u00e5klart dynamisk, s\u00e5 den uppdateras n\u00e4r v\u00e5r k\u00e4lldata \u00e4ndras.<\/p>\r\n\r\n\r\n\r\n<p>(Funktionen heter XMATCH p\u00e5 norsk \ud83c\uddf3\ud83c\uddf4)<\/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\/561413529<\/div>\r\n<\/figure>\r\n","protected":false},"excerpt":{"rendered":"<p>Vi forts\u00e4tter \u00e4ven denna vecka med matrisfunktioner, lek i Excel och prova sj\u00e4lv!\u00a0 P\u00e5minnelse om att matrisfunktionerna plus exempellektioner (totalt 12 lektioner)\u00a0nu finns i v\u00e5r kurs Excelfunktioner F\u00f6rdjupning. L\u00e4s mer om\u00a0kursen h\u00e4r \u2013 EXCELFUNKTIONER F\u00d6RDJUPNING [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":92479,"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-92756","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\/92756","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=92756"}],"version-history":[{"count":2,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/92756\/revisions"}],"predecessor-version":[{"id":135012,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/92756\/revisions\/135012"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/92479"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=92756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=92756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=92756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}