{"id":88741,"date":"2021-06-13T11:13:39","date_gmt":"2021-06-13T09:13:39","guid":{"rendered":"https:\/\/learnesy.com\/?p=88741"},"modified":"2022-03-02T12:40:30","modified_gmt":"2022-03-02T10:40:30","slug":"video-hantera-unika-varden-med-unik-funktionen","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/video-hantera-unika-varden-med-unik-funktionen\/","title":{"rendered":"Video: Hantera unika v\u00e4rden med UNIK-funktionen"},"content":{"rendered":"<p><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Anv\u00e4nd UNIK funktionen f\u00f6r att h\u00e4mta och hantera unika v\u00e4rden inom ett cellomr\u00e5de!\\n\\nMatrisfunktionaliteten hj\u00e4lper oss skapa en lista unika v\u00e4rden, h\u00e4mtade fr\u00e5n en annan lista, som ocks\u00e5 uppdateras dynamiskt n\u00e4r ny data kommer in.\\nMan kan v\u00e4lja om man vill se unik v\u00e4rden p\u00e5 raderna eller kolumnerna, samt om man vill se alla unika v\u00e4rden eller endast de som f\u00f6rekommer endast en g\u00e5ng!\\n\\nKom ih\u00e5g att \u201dspill\u201d beteendet g\u00f6r att man m\u00e5ste \u00e4ndra formeln i f\u00f6rsta cellen f\u00f6r f\u00f6r\u00e4ndra resultatet i andra.\\n\\n(Funktionen heter ocks\u00e5 UNIK p\u00e5 norsk \ud83c\uddf3\ud83c\uddf4)&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:521,&quot;3&quot;:{&quot;1&quot;:0},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:[null,2,0]},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;12&quot;:0}\">\u00c4nnu en vecka med Excels dynamiska matrisformler!<\/span><\/p>\n<p><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Anv\u00e4nd UNIK funktionen f\u00f6r att h\u00e4mta och hantera unika v\u00e4rden inom ett cellomr\u00e5de!\\n\\nMatrisfunktionaliteten hj\u00e4lper oss skapa en lista unika v\u00e4rden, h\u00e4mtade fr\u00e5n en annan lista, som ocks\u00e5 uppdateras dynamiskt n\u00e4r ny data kommer in.\\nMan kan v\u00e4lja om man vill se unik v\u00e4rden p\u00e5 raderna eller kolumnerna, samt om man vill se alla unika v\u00e4rden eller endast de som f\u00f6rekommer endast en g\u00e5ng!\\n\\nKom ih\u00e5g att \u201dspill\u201d beteendet g\u00f6r att man m\u00e5ste \u00e4ndra formeln i f\u00f6rsta cellen f\u00f6r f\u00f6r\u00e4ndra resultatet i andra.\\n\\n(Funktionen heter ocks\u00e5 UNIK p\u00e5 norsk \ud83c\uddf3\ud83c\uddf4)&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:521,&quot;3&quot;:{&quot;1&quot;:0},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:[null,2,0]},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;12&quot;:0}\">Anv\u00e4nd UNIK-<\/span><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Anv\u00e4nd UNIK funktionen f\u00f6r att h\u00e4mta och hantera unika v\u00e4rden inom ett cellomr\u00e5de!\\n\\nMatrisfunktionaliteten hj\u00e4lper oss skapa en lista unika v\u00e4rden, h\u00e4mtade fr\u00e5n en annan lista, som ocks\u00e5 uppdateras dynamiskt n\u00e4r ny data kommer in.\\nMan kan v\u00e4lja om man vill se unik v\u00e4rden p\u00e5 raderna eller kolumnerna, samt om man vill se alla unika v\u00e4rden eller endast de som f\u00f6rekommer endast en g\u00e5ng!\\n\\nKom ih\u00e5g att \u201dspill\u201d beteendet g\u00f6r att man m\u00e5ste \u00e4ndra formeln i f\u00f6rsta cellen f\u00f6r f\u00f6r\u00e4ndra resultatet i andra.\\n\\n(Funktionen heter ocks\u00e5 UNIK p\u00e5 norsk \ud83c\uddf3\ud83c\uddf4)&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:521,&quot;3&quot;:{&quot;1&quot;:0},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:[null,2,0]},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;12&quot;:0}\">funktionen f\u00f6r att h\u00e4mta och hantera unika v\u00e4rden inom ett cellomr\u00e5de!<\/span><\/p>\n<p>Matrisfunktionaliteten hj\u00e4lper oss skapa en lista unika v\u00e4rden, h\u00e4mtade fr\u00e5n en annan lista, som ocks\u00e5 uppdateras dynamiskt n\u00e4r ny data kommer in.<br \/>\nMan kan v\u00e4lja om man vill se unika v\u00e4rden p\u00e5 raderna eller kolumnerna, samt om man vill se alla unika v\u00e4rden eller endast de som f\u00f6rekommer endast en g\u00e5ng!<\/p>\n<p>Kom ih\u00e5g att \u201dspill\u201d-beteendet g\u00f6r att man m\u00e5ste \u00e4ndra formeln i f\u00f6rsta cellen f\u00f6r att f\u00f6r\u00e4ndra resultatet i den andra.<\/p>\n<p>(Funktionen heter \u00e4ven UNIK p\u00e5 norsk \ud83c\uddf3\ud83c\uddf4)<\/p>\n<p>&nbsp;<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/560909314?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>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c4nnu en vecka med Excels dynamiska matrisformler! Anv\u00e4nd UNIK-funktionen f\u00f6r att h\u00e4mta och hantera unika v\u00e4rden inom ett cellomr\u00e5de! Matrisfunktionaliteten hj\u00e4lper oss skapa en lista unika v\u00e4rden, h\u00e4mtade fr\u00e5n en annan lista, som ocks\u00e5 uppdateras [&hellip;]<\/p>\n","protected":false},"author":26679,"featured_media":88742,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[218,247,65,346],"class_list":["post-88741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-online","tag-excelfunktioner","tag-excelkurs","tag-unik"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/88741","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=88741"}],"version-history":[{"count":2,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/88741\/revisions"}],"predecessor-version":[{"id":135846,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/88741\/revisions\/135846"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/88742"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=88741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=88741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=88741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}