{"id":2149,"date":"2023-09-28T20:04:28","date_gmt":"2023-09-28T20:04:28","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/"},"modified":"2023-12-10T06:05:50","modified_gmt":"2023-12-10T06:05:50","slug":"yinelenen-degerleri-vurgula","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/","title":{"rendered":"Vba ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3078265536\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>B\u00fcy\u00fck verilerle \u00e7al\u0131\u015f\u0131rken yinelenen de\u011ferler her zaman sorun te\u015fkil eder. \u00c7o\u011fu zaman t\u00fcm bu de\u011ferleri kald\u0131rmak i\u00e7in kopyalar\u0131 kald\u0131r se\u00e7ene\u011fini kullan\u0131yorum. Ve eminim siz de ayn\u0131 \u015feyi yap\u0131yorsunuzdur.<\/p><p> Ancak bu yinelenen de\u011ferleri kald\u0131rmak veya yaln\u0131zca saymak sorunu asla \u00e7\u00f6zmez. \u00d6nemli olan t\u00fcm kopya de\u011ferleri kald\u0131rmadan \u00f6nce incelemektir.<\/p><p> Evet bu do\u011fru. T\u00fcm bu de\u011ferleri vurgulad\u0131ktan sonra kontrol edebilir ve ard\u0131ndan silebilirsiniz. Bug\u00fcn bu yaz\u0131mda yinelenen de\u011ferleri vurgulamak i\u00e7in 4 farkl\u0131 VBA kodunu sizlerle payla\u015fmak istiyorum.<\/p><p> Mesele \u015fu ki, bu kodlar h\u00fccreleri farkl\u0131 \u015fekillerde vurgulayabiliyor. Bunlar\u0131 kopyalay\u0131p VBA d\u00fczenleyicinize yap\u0131\u015ft\u0131rabilir ve kullanabilirsiniz.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> 1. Her sat\u0131rda<\/h2><p> Bu VBA kodu, sat\u0131rdaki t\u00fcm h\u00fccreleri kontrol eder ve sat\u0131rda \u00e7o\u011falt\u0131lan t\u00fcm h\u00fccreleri vurgular. Basit bir ifadeyle, bir sat\u0131r\u0131n de\u011feri iki kez &#8220;522&#8221; ise kopya olarak kabul edilir. Ancak di\u011fer 522 ba\u015fka bir s\u0131radaysa benzersiz say\u0131lacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif\" sizes=\"\" srcset=\"\" alt=\"VBA kodunu kullanarak her sat\u0131r\u0131n yinelenen de\u011ferlerini vurgulay\u0131n\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub DuplicateValuesFromRow() 'Declare All Variables. Dim myCell As Range Dim myRow As Integer Dim myRange As Range Dim myCol As Integer Dim i As Integer 'Count Number of Rows and Columns myRow = Range(Cells(1, 1), Cells(1, 1).End(xlDown)).Count myCol = Range(Cells(1, 1), Cells(1, 1).End(xlToRight)).Count 'Loop Each Row To Check Duplicate Values and Highlight cells. For i = 2 To myRow Set myRange = Range(Cells(i, 2), Cells(i, myCol)) For Each myCell In myRange If WorksheetFunction.CountIf(myRange, myCell.Value) &gt; 1 Then myCell.Interior.ColorIndex = 3 End If Next Next End Sub<\/code><\/pre><p> Bu makroya bakarsan\u0131z, her sat\u0131r\u0131 yinelenen de\u011ferler a\u00e7\u0131s\u0131ndan kontrol etmek ve bunlar\u0131 bir renkle vurgulamak i\u00e7in bir d\u00f6ng\u00fc kulland\u0131\u011f\u0131m\u0131z\u0131 g\u00f6receksiniz.<\/p><h3 class=\"wp-block-heading\"> \u00d6nemli noktalar<\/h3><ol><li> Verileriniz bo\u015f bir sat\u0131r veya s\u00fctun i\u00e7ermemelidir, aksi takdirde bu h\u00fccre dikkate al\u0131nmaz.<\/li><li> Verilerinizin ba\u015flang\u0131\u00e7 h\u00fccresi \u201cA1\u201d h\u00fccresi olmal\u0131d\u0131r. Ba\u015flang\u0131\u00e7 noktas\u0131n\u0131 ayarlamak istiyorsan\u0131z kodu da ayarlaman\u0131z gerekir.<\/li><li> Veri sayfan\u0131z\u0131n ilk sat\u0131r\u0131 ve ilk s\u00fctunu ba\u015fl\u0131k olmal\u0131d\u0131r.<\/li><\/ol><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> 2. Her s\u00fctunda<\/h2><p> Bu VBA kodu, bir s\u00fctundaki t\u00fcm h\u00fccreleri kontrol eder ve her s\u00fctunda kopyalanan t\u00fcm h\u00fccreleri vurgular. Basit bir ifadeyle, bir s\u00fctun iki kez &#8220;231&#8221; de\u011ferine sahipse kopya olarak kabul edilecektir. Ancak ba\u015fka bir s\u00fctunda ba\u015fka bir \u201c231\u201d varsa benzersiz kabul edilecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-colonne-a-laide-du-code-VBA.gif\" sizes=\"\" srcset=\"\" alt=\"VBA kodunu kullanarak her s\u00fctunun yinelenen de\u011ferlerini vurgulay\u0131n\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub DuplicateValuesFromColumns() 'Declare All Variables Dim myCell As Range Dim myRow As Integer Dim myRange As Range Dim myCol As Integer Dim i As Integer 'Count number of rows &amp; column myRow = Range(Cells(1, 1), Cells(1, 1).End(xlDown)).Count myCol = Range(Cells(1, 1), Cells(1, 1).End(xlToRight)).Count 'Loop each column to check duplicate values &amp; highlight them. For i = 2 To myRow Set myRange = Range(Cells(2, i), Cells(myRow, i)) For Each myCell In myRange If WorksheetFunction.CountIf(myRange, myCell.Value) &gt; 1 Then myCell.Interior.ColorIndex = 3 End If Next Next End Sub<\/code><\/pre><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> 3. Se\u00e7imde<\/h2><p> Diyelim ki se\u00e7imdeki yinelenen de\u011ferlere sahip h\u00fccreleri vurgulamak istiyorsunuz, bu kod size yard\u0131mc\u0131 olabilir. Bu kodu kullanmak i\u00e7in bir h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ip bu kodu \u00e7al\u0131\u015ft\u0131rman\u0131z yeterlidir. Se\u00e7imle birlikte her h\u00fccreyi kontrol eder ve bir h\u00fccrede yinelenen bir de\u011fer varsa k\u0131rm\u0131z\u0131 renkle vurgulan\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-la-selection-a-laide-du-code-VBA.gif\" sizes=\"\" srcset=\"\" alt=\"VBA kodunu kullanarak se\u00e7imdeki yinelenen de\u011ferleri vurgulay\u0131n\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub DuplicateValuesFromSelection() Dim myRange As Range Dim i As Integer Dim j As Integer Dim myCell As Range Set myRange = Selection For Each myCell In myRange If WorksheetFunction.CountIf(myRange, myCell.Value) &gt; 1 Then myCell.Interior.ColorIndex = 3 End If Next End Sub<\/code><\/pre><h2 id=\"tab-con-0\" class=\"wp-block-heading\"> 4. Tamsay\u0131 verileri<\/h2><p> B\u00fcy\u00fck bir veri k\u00fcmeniz varsa, verilerin eksiksizli\u011fini do\u011frulamak ve yinelenen de\u011ferleri vurgulamak i\u00e7in bu makro kodunu kullanabilirsiniz. Bu kod her h\u00fccreden tek tek ge\u00e7erek kopya olan t\u00fcm h\u00fccrelere k\u0131rm\u0131z\u0131 rengi uygular.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub DuplicateValuesFromTable() Dim myRange As Range Dim i As Integer Dim j As Integer Dim myCell As Range Set myRange = Range(\u201cTable1\u201d) For Each myCell In myRange If WorksheetFunction.CountIf(myRange, myCell.Value) &gt; 1 Then myCell.Interior.ColorIndex = 3 End If Next End Sub<\/code><\/pre><p class=\"qt-tip\"> <span style=\"color: #ea493f;\"><strong>\u00d6nemli Not:<\/strong><\/span> Yukar\u0131daki kodda Tablo1 ad\u0131n\u0131 kulland\u0131k, bu ad\u0131 koddan de\u011fi\u015ftirebilirsiniz. Art\u0131k bir aral\u0131\u011f\u0131n\u0131z varsa yaln\u0131zca aral\u0131k ad\u0131n\u0131 kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> [Bonus \u0130pucu] Yinelenen de\u011ferleri say\u0131n<\/h2><p> Bu kod, se\u00e7imdeki yinelenen de\u011ferlerin say\u0131s\u0131n\u0131 sayman\u0131za yard\u0131mc\u0131 olur. Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, numaray\u0131 g\u00f6steren bir mesaj kutusu d\u00f6nd\u00fcr\u00fcr.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub CountDuplicates() Dim i As Integer Dim j As Integer Dim myCell As Range Dim myRange As Integer myRange = Range(\"Table1\").Count j = 0 For Each myCell In Range(\"Table1\") If WorksheetFunction.CountIf(Range(\"Table1\"), myCell.Value) &gt; 1 Then j = j + 1 End If Next MsgBox j End Sub<\/code><\/pre><p> Yukar\u0131daki kodda yine bir tablo ad\u0131 kulland\u0131k ve siz bunu bir aral\u0131kla de\u011fi\u015ftirir veya de\u011fi\u015ftirirsiniz.<\/p><h2 class=\"wp-block-heading\"> \u00d6rnek dosya<\/h2><p> Daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/mettre-en-evidence-les-valeurs-en-double.zip\">bu \u00f6rnek dosyay\u0131 buradan indirin<\/a> .<\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Farkl\u0131 durumlarda, yinelenen de\u011ferleri farkl\u0131 \u015fekillerde kontrol etmemiz gerekir. Ve yukar\u0131daki kodlar\u0131n t\u00fcm\u00fc bu konuda size yard\u0131mc\u0131 olabilir. \u0130sterseniz renk indeks numaras\u0131n\u0131 kullanarak kodlardan vurgu rengini de\u011fi\u015ftirebilirsiniz.<\/p><p> \u015eimdi bana bir konuda yard\u0131m et.<\/p><p> <strong>Bu kodlar\u0131 nerede geli\u015ftirebiliriz?<\/strong><\/p><p> L\u00fctfen yorum k\u0131sm\u0131nda d\u00fc\u015f\u00fcncelerinizi benimle payla\u015f\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopru-baglantisini-cikar\/\">K\u00f6pr\u00fc adresini (URL) VBA&#8217;dan \u00e7\u0131kar\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/giris-alani\/\">VBA&#8217;daki giri\u015f kutusu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/\">VBA bir metin dosyas\u0131 olu\u015fturma ve yazma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ekran-guncellemesi\/\">VBA Ekran G\u00fcncellemesi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/durum-cubugu-1\/\">VBA durum \u00e7ubu\u011fu (gizle, g\u00f6ster ve ilerleme)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2149","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?<\/title>\n<meta name=\"description\" content=\"Bunlar, Excel&#039;deki yinelenen de\u011ferleri farkl\u0131 \u015fekillerde vurgulayan d\u00f6rt VBA kodudur. Koyabilirsin\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bunlar, Excel&#039;deki yinelenen de\u011ferleri farkl\u0131 \u015fekillerde vurgulayan d\u00f6rt VBA kodudur. Koyabilirsin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:05:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\",\"name\":\"VBA ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif\",\"datePublished\":\"2023-09-28T20:04:28+00:00\",\"dateModified\":\"2023-12-10T06:05:50+00:00\",\"description\":\"Bunlar, Excel&#39;deki yinelenen de\u011ferleri farkl\u0131 \u015fekillerde vurgulayan d\u00f6rt VBA kodudur. Koyabilirsin\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?","description":"Bunlar, Excel&#39;deki yinelenen de\u011ferleri farkl\u0131 \u015fekillerde vurgulayan d\u00f6rt VBA kodudur. Koyabilirsin","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:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?","og_description":"Bunlar, Excel&#39;deki yinelenen de\u011ferleri farkl\u0131 \u015fekillerde vurgulayan d\u00f6rt VBA kodudur. Koyabilirsin","og_url":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:05:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/","url":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/","name":"VBA ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif","datePublished":"2023-09-28T20:04:28+00:00","dateModified":"2023-12-10T06:05:50+00:00","description":"Bunlar, Excel&#39;deki yinelenen de\u011ferleri farkl\u0131 \u015fekillerde vurgulayan d\u00f6rt VBA kodudur. Koyabilirsin","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-surbrillance-les-valeurs-en-double-de-chaque-ligne-a-laide-du-code-VBA.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba ile yinelenen de\u011ferler nas\u0131l vurgulan\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2149"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2149\/revisions"}],"predecessor-version":[{"id":2835,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2149\/revisions\/2835"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}