{"id":15875,"date":"2020-12-11T10:07:31","date_gmt":"2020-12-11T09:07:31","guid":{"rendered":"https:\/\/www.nemprogrammering.dk\/wp\/?p=15875"},"modified":"2020-12-11T10:07:31","modified_gmt":"2020-12-11T09:07:31","slug":"fjern-dubletter-i-excel","status":"publish","type":"post","link":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/","title":{"rendered":"Fjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel"},"content":{"rendered":"

Vi skal i denne lille guide se p\u00e5, hvordan man fjernet dubletter i Excel. Derudover skal vi ogs\u00e5 se p\u00e5, hvordan man i stedet for at fjerne dem blot markerer dem, s\u00e5 man kan se, hvilke de celler der har den samme v\u00e6rdi eller tekst-streng.<\/p>\n

Vi tager udgangspunkt i en fiktivt problem hvor webshoppen ipcam-shop.dk, som blandt andet s\u00e6lger alarm systemer<\/a>, skal finde frem til de produkter, der af en eller anden grund findes flere gang i shop-systemet.<\/p>\n

Husk p\u00e5, at hvis du vil bliver endnu bedre til Excel, s\u00e5 kan du altid tage mit Excel kursus<\/a> her p\u00e5 siden!<\/p>\n

Fjern dubletter i Excel<\/h2>\n

Herunder ser du den data vi gerne vil fjerne dubletter i. Ipcam-shop.dk har langt flere produkter end vist herunder, men vi begr\u00e6nser lige listen for eksemplets skyld:<\/p>\n

\"Dubletter\"<\/p>\n

I eksemplet kan vi med det blotte \u00f8je se, at vi har flere dubletter. Vi har to der koster 499 og to der koster 599. Men forestil dig, at du har 500 linjer i dit Excel-ark, s\u00e5 kan er det praktisk talt umuligt at fjerne dem der er ens.<\/p>\n

For at fjerne dem der er ens, markerer vi f\u00f8rste de kolonner vi \u00f8nsker at fjerne dubletter p\u00e5, som vist herunder. Derefter g\u00e5 vi ind under “Data” fanen og trykker p\u00e5 “Fjern dubletter”<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

I det du trykker p\u00e5 “Fjern dubletter” f\u00e5r du en dialog-boks, som sp\u00f8rger dig om, hvilke kolonner du vil fjerne dubletter p\u00e5. Hvis vi f.eks. har et produkt, som har den samme pris, men et andet model\/varenummer, vil denne ogs\u00e5 bliver fjernet, hvis vi kun vinger til i Pris.<\/p>\n

Derfor er det vigtigt, at n\u00e5r du fjerner dubletter, at du finger til i alle kolonner, s\u00e5 du kun f\u00e5r fjernet de r\u00e6kker, hvor alle kolonner er ens (hvis det alts\u00e5 er det du vil opn\u00e5).<\/p>\n

Og det er faktisk det, nu har vi fjernet alle dubletter, og vi har kun de reelle antal produkter og deres pris tilbage.<\/p>\n

\"\"<\/p>\n

Marker dubletter i Excel<\/h2>\n

Hvis vi kun \u00f8nsker at f\u00e5 markeret de r\u00e6kker, der er ens, kan vi selvf\u00f8lgelig ogs\u00e5 g\u00f8re det i Excel.<\/p>\n

Dette g\u00f8r vi igen ved at markere hele vores tabel, hvorefter vi g\u00e5r til “Hjem”-fanen, hvor vi v\u00e6lger “Betinget formatering”, som vist herunder.<\/p>\n

\"\"<\/p>\n

Under betinget formatering har vi muligheden for at v\u00e6lge “Dubletv\u00e6rdier” nederst.<\/p>\n

\"\"<\/p>\n

I det vi klikker p\u00e5 den f\u00e5r vi en dialog-boks, hvor vi kan v\u00e6lge, hvordan vi \u00f8nsker at markere dubletterne. Hvis du blot klikker OK, vil alle de r\u00e6kker, der er ens i tabellen blive markeret med r\u00f8dt og vi har hermed f\u00e5et fremh\u00e6vet de r\u00e6kker, som f\u00f8r blot blev fjernet.<\/p>\n

\"Markeret<\/p>\n

Med disse v\u00e6rkt\u00f8jer, kan du hurtigt f\u00e5 overblik over data, hvor der m\u00e5ske er fejl og dubletter – det er i hvert fald nemmere end at sidde og fink\u00e6mme sine r\u00e6kker manuelt ;-)<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Vi skal i denne lille guide se p\u00e5, hvordan man fjernet dubletter i Excel. Derudover skal vi ogs\u00e5 se p\u00e5, hvordan man i stedet for at fjerne dem blot markerer dem, s\u00e5 man kan se, hvilke de celler der har den samme v\u00e6rdi eller tekst-streng. Vi tager udgangspunkt i en fiktivt problem hvor webshoppen ipcam-shop.dk, […]<\/p>\n","protected":false},"author":249,"featured_media":15877,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73],"tags":[],"class_list":["post-15875","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\nFjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel<\/title>\n<meta name=\"description\" content=\"I denne guide skal vi se p\u00e5 hvordan du fjerner dubletter i Excel. Vi ser b\u00e5de p\u00e5, hvordan du fjerner og fremh\u00e6ver dubletter.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel\" \/>\n<meta property=\"og:description\" content=\"I denne guide skal vi se p\u00e5 hvordan du fjerner dubletter i Excel. Vi ser b\u00e5de p\u00e5, hvordan du fjerner og fremh\u00e6ver dubletter.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"NemProgrammering.dk\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-11T09:07:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2020\/12\/fjern-dubletter-i-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"885\" \/>\n\t<meta property=\"og:image:height\" content=\"270\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Thomas Iversen\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet af\" \/>\n\t<meta name=\"twitter:data1\" content=\"Thomas Iversen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutter\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel","description":"I denne guide skal vi se p\u00e5 hvordan du fjerner dubletter i Excel. Vi ser b\u00e5de p\u00e5, hvordan du fjerner og fremh\u00e6ver dubletter.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/","og_locale":"da_DK","og_type":"article","og_title":"Fjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel","og_description":"I denne guide skal vi se p\u00e5 hvordan du fjerner dubletter i Excel. Vi ser b\u00e5de p\u00e5, hvordan du fjerner og fremh\u00e6ver dubletter.","og_url":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/","og_site_name":"NemProgrammering.dk","article_published_time":"2020-12-11T09:07:31+00:00","og_image":[{"width":885,"height":270,"url":"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2020\/12\/fjern-dubletter-i-excel.png","type":"image\/png"}],"author":"Thomas Iversen","twitter_misc":{"Skrevet af":"Thomas Iversen","Estimeret l\u00e6setid":"2 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#article","isPartOf":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/"},"author":{"name":"Thomas Iversen","@id":"https:\/\/www.nemprogrammering.dk\/wp\/#\/schema\/person\/5954716500923309d5bfc0c0a5d4c317"},"headline":"Fjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel","datePublished":"2020-12-11T09:07:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/"},"wordCount":509,"commentCount":2,"image":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2020\/12\/fjern-dubletter-i-excel.png","articleSection":["Excel"],"inLanguage":"da-DK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/","url":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/","name":"Fjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel","isPartOf":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2020\/12\/fjern-dubletter-i-excel.png","datePublished":"2020-12-11T09:07:31+00:00","author":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/#\/schema\/person\/5954716500923309d5bfc0c0a5d4c317"},"description":"I denne guide skal vi se p\u00e5 hvordan du fjerner dubletter i Excel. Vi ser b\u00e5de p\u00e5, hvordan du fjerner og fremh\u00e6ver dubletter.","breadcrumb":{"@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/"]}]},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#primaryimage","url":"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2020\/12\/fjern-dubletter-i-excel.png","contentUrl":"https:\/\/www.nemprogrammering.dk\/wp\/wp-content\/uploads\/2020\/12\/fjern-dubletter-i-excel.png","width":885,"height":270,"caption":"Fjern dubletter i Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.nemprogrammering.dk\/wp\/fjern-dubletter-i-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/www.nemprogrammering.dk\/wp\/"},{"@type":"ListItem","position":2,"name":"Fjern dubletter i Excel | S\u00e5dan fjerner og markerer du dubletter i Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.nemprogrammering.dk\/wp\/#website","url":"https:\/\/www.nemprogrammering.dk\/wp\/","name":"NemProgrammering.dk","description":"Gratis HTML, CSS, PHP, WORDPRESS TUTORIALS OG GUIDES","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.nemprogrammering.dk\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":"Person","@id":"https:\/\/www.nemprogrammering.dk\/wp\/#\/schema\/person\/5954716500923309d5bfc0c0a5d4c317","name":"Thomas Iversen","image":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/secure.gravatar.com\/avatar\/e0031fa642aa4be8499828051754ed72b7922639dad9a1f211dd63a90ad79504?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e0031fa642aa4be8499828051754ed72b7922639dad9a1f211dd63a90ad79504?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e0031fa642aa4be8499828051754ed72b7922639dad9a1f211dd63a90ad79504?s=96&d=mm&r=g","caption":"Thomas Iversen"},"url":"https:\/\/www.nemprogrammering.dk\/wp\/author\/t-s-iversen\/"}]}},"_links":{"self":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts\/15875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/users\/249"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/comments?post=15875"}],"version-history":[{"count":4,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts\/15875\/revisions"}],"predecessor-version":[{"id":15888,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/posts\/15875\/revisions\/15888"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/media\/15877"}],"wp:attachment":[{"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/media?parent=15875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/categories?post=15875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nemprogrammering.dk\/wp\/wp-json\/wp\/v2\/tags?post=15875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}