{"id":124992,"date":"2022-01-10T18:02:37","date_gmt":"2022-01-10T16:02:37","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/unik\/"},"modified":"2023-07-25T18:37:02","modified_gmt":"2023-07-25T17:37:02","slug":"unik","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/unik\/","title":{"rendered":"UNIK"},"content":{"rendered":"\n<p><em>Se \u00e4ven:<\/em> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/filter\/\" data-type=\"excel-functions\" data-id=\"125025\">FILTER<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/sortera\/\" data-type=\"excel-functions\" data-id=\"125024\">SORTERA<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/sorteraefter\/\" data-type=\"excel-functions\" data-id=\"124991\">SORTERAEFTER<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/sekvens\/\" data-type=\"excel-functions\" data-id=\"125032\">SEKVENS<\/a> |<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\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\"><div class=\"wp-block-embed__wrapper\">\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<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga andra finner man i Learnesys f\u00f6rdjupningskurs i Excel, <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/\">Excelfunktioner F\u00f6rdjupning<\/a><\/em>.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>UNIK-funktionen returnerar en lista med unika v\u00e4rden i en lista eller ett intervall. V\u00e4rdena kan vara i text-, siffer-, datum-, tidformat osv.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Syfte<\/strong><br>Extrahera unika v\u00e4rden fr\u00e5n ett intervall<br><br><strong>Argument<\/strong><br><em>matris<\/em> \u2013 omr\u00e5de eller matris fr\u00e5n vilken unika v\u00e4rden kan extraheras<br><em>[by_col]<\/em> \u2013 [valfritt] hur man j\u00e4mf\u00f6r och extraherar. F\u00f6r rad anv\u00e4nds <em>FALSKT<\/em> (standard) och f\u00f6r kolumn anv\u00e4nds <em>SANT<\/em><br><em>[exactly_once] <\/em>\u2013 [valfritt] F\u00f6r v\u00e4rden som \u00e4r unika i den meningen att de intr\u00e4ffar endast en g\u00e5ng anv\u00e4nds SANT. F\u00f6r samtliga unika v\u00e4rden anv\u00e4nds FALSKT (standard)<br><br><strong>Returv\u00e4rde<\/strong><br>Unika v\u00e4rden fr\u00e5n ett angivet omr\u00e5de eller en matris<br><br><strong>Syntax<\/strong><br>=UNIK(matris;[by_col];[exactly once])<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Hur anv\u00e4nder man funktionen UNIK i Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 Grundl\u00e4ggande anv\u00e4ndning<\/h3>\n\n\n\n<p>I exemplet nedan anv\u00e4nds klammerparenteser &#8217;{}&#8217; f\u00f6r att definiera en matris i funktionen:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=UNIK({1;2;2;3;3;3;4})<\/pre>\n\n\n\n<p>Resultatet av funktionen blir i det h\u00e4r fallet 1, 2, 3, 4. Detta eftersom dessa fyra \u00e4r de <em>unika<\/em> v\u00e4rdena i denna matris. <\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 2 \u2013 grundl\u00e4ggande anv\u00e4ndning med andra och tredje argumentet<\/h3>\n\n\n\n<p>I det f\u00f6reg\u00e5ende exemplet anv\u00e4ndes matrisen {1;2;2;3;3;3;4}. Anv\u00e4nder vi det andra argumentet i funktionen likt nedan<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=UNIK({1;2;2;3;3;3;4};SANT)<\/pre>\n\n\n\n<p>f\u00e5r man resultatet 1, 2, 2, 3, 3, 3, 4. Detta pga att samtliga v\u00e4rden utg\u00f6r de enda v\u00e4rdena i varsin kolumn. Anv\u00e4nder man ist\u00e4llet <em>FALSKT<\/em> \u2013 vilket \u00e4r standard \u2013 kommer vi f\u00e5 samma resultat som i <em>Exempel 1<\/em>. <\/p>\n\n\n\n<p>I n\u00e4sta exempel anv\u00e4nds det tredje argumentet f\u00f6r att extrahera de v\u00e4rden som f\u00f6rekommer <em>endast en g\u00e5ng<\/em>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"807\" height=\"575\" src=\"\/wp-content\/uploads\/2023\/07\/excel-unik-1.png\" alt=\"excel-unik-1\" class=\"wp-image-245851\" srcset=\"\/wp-content\/uploads\/2023\/07\/excel-unik-1.png 807w, \/wp-content\/uploads\/2023\/07\/excel-unik-1-300x214.png 300w, \/wp-content\/uploads\/2023\/07\/excel-unik-1-768x547.png 768w\" sizes=\"auto, (max-width: 807px) 100vw, 807px\" \/><figcaption class=\"wp-element-caption\">Exempel 2: i detta exempel anv\u00e4nds det tredje argumentet i funktionen \u2013 <em>exactly_once<\/em>.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Mer om funktionen UNIK<\/h2>\n\n\n\n<p>UNIK-funktionen extraherar en lista med unika v\u00e4rden fr\u00e5n ett intervall eller en matris. Resultatet \u00e4r en dynamisk samling av unika v\u00e4rden. <\/p>\n\n\n\n<p>Om denna lista \u00e4r det slutliga resultatet (dvs. inte l\u00e4mnas \u00f6ver till en annan funktion), kommer v\u00e4rdena att &#8221;spilla&#8221; p\u00e5 kalkylbladet till ett intervall som automatiskt uppdateras n\u00e4r nya unika v\u00e4rden l\u00e4ggs till eller tas bort fr\u00e5n k\u00e4llintervallet. Detta ger upphov till felkoden #SPILL!.<\/p>\n\n\n\n<p>UNIK tar tre argument. Som standard extraherar UNIK unika v\u00e4rden i rader. F\u00f6r att tvinga UNIK att extrahera unika v\u00e4rden efter kolumner, st\u00e4ll in by_col till <em>SANT<\/em> eller 1. Det sista argumentet, exactly_once, anger beteendet f\u00f6r v\u00e4rden som visas mer \u00e4n en g\u00e5ng. Som standard extraherar UNIK alla unika v\u00e4rden, oavsett hur m\u00e5nga g\u00e5nger de visas i en matris. F\u00f6r att extrahera unika v\u00e4rden som bara visas en g\u00e5ng i matrisen, st\u00e4ll in exactly_once p\u00e5 <em>SANT<\/em> eller 1. <\/p>\n\n\n\n<p><em>Obs: UNIK-funktionen \u00e4r inte skiftl\u00e4gesk\u00e4nslig. UNIK kommer att behandla &#8221;\u00c4PPLE&#8221;, &#8221;\u00c4pple&#8221; och &#8221;\u00e4pple&#8221; som samma text.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bra att veta om SUMMA-funktionen<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>UNIK \u00e4r en matrisfunktion, och kan s\u00e5ledes ge upphov till <em>#SPILL<\/em>-fel.<\/li>\n\n\n\n<li>UNIK \u00e4r inte skiftesl\u00e4gesk\u00e4nslig.<\/li>\n\n\n\n<li>F\u00f6r att anv\u00e4nda UNIK med ett kriterium, kombinera UNIK och FILTER till en formel. <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Mer l\u00e4sning<\/h3>\n\n\n\n<p>Man l\u00e4r sig mer om UNIK-funktionen i v\u00e5r kurs <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a><\/em>!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Har du en fr\u00e5ga eller vill l\u00e4ra dig mer om funktionen? Bes\u00f6k d\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/sv\/forums\/excel\/\">forum<\/a> eller v\u00e5r <a href=\"https:\/\/learnesy.com\/sv\/resursbank\/\">resursbank<\/a>.<\/li>\n\n\n\n<li>Vill du har fler Exceltips? P\u00e5 Learnesys <a href=\"https:\/\/learnesy.com\/sv\/blogg\/\">blogg<\/a> hittar du massvis av tips! Eller, prenumerera p\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/newsletter\/\">nyhetsbrev<\/a>. <\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/courses\/\">Till v\u00e5ra kurssidor \u2192<\/a><\/li>\n<\/ul>\n","protected":false},"featured_media":0,"menu_order":0,"template":"","excel_function_category":[301],"class_list":["post-124992","excel-functions","type-excel-functions","status-publish","hentry","excel_function_category-matrisfunktioner-sv"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions\/124992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/excel-functions"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=124992"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=124992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}