{"id":1825,"date":"2023-11-01T04:09:45","date_gmt":"2023-11-01T04:09:45","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/"},"modified":"2023-12-10T06:00:20","modified_gmt":"2023-12-10T06:00:20","slug":"benzersiz-degerleri-sayma-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/","title":{"rendered":"Excel&#39;de benzersiz de\u011ferleri sayman\u0131n 7 yolu"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-932010453\"><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>Her de\u011ferin birden \u00e7ok kez girildi\u011fi bir de\u011ferler listeniz oldu\u011funu varsayal\u0131m.<\/p><p> Ve \u015fimdi\u2026<\/p><p> \u0130\u00e7indeki de\u011ferlerin ger\u00e7ek say\u0131s\u0131n\u0131 elde etmek i\u00e7in bu listedeki benzersiz de\u011ferleri saymak istiyorsunuz.<\/p><p> Bunu yapmak i\u00e7in de\u011feri yaln\u0131zca bir kez sayacak ve listedeki di\u011fer t\u00fcm olu\u015fumlar\u0131 g\u00f6z ard\u0131 edecek bir y\u00f6ntem kullanman\u0131z gerekir.<\/p><p> Excel&#8217;de bir dizi benzersiz de\u011fer elde etmek i\u00e7in farkl\u0131 y\u00f6ntemler kullanabilirsiniz. Ne t\u00fcr de\u011ferlere sahip oldu\u011funuza ba\u011fl\u0131d\u0131r, dolay\u0131s\u0131yla bunun i\u00e7in en iyi y\u00f6ntemi kullanabilirsiniz.<\/p><p> Bug\u00fcnk\u00fc yaz\u0131mda, benzersiz de\u011ferleri saymak ve sahip oldu\u011funuz de\u011ferlerin t\u00fcr\u00fcne g\u00f6re bu y\u00f6ntemleri kullanmak i\u00e7in 6 farkl\u0131 y\u00f6ntemi sizlerle payla\u015fmak istiyorum.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/compter-les-donnees-de-valeurs-uniques.zip\" rel=\"nofollow\"><strong>veri.xlsx<\/strong><\/a><\/p><h2 class=\"wp-block-heading\"> Benzersiz de\u011fer say\u0131s\u0131n\u0131 elde etmek i\u00e7in geli\u015fmi\u015f filtre<\/h2><p> Geli\u015fmi\u015f bir filtre kullanmak, benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 kontrol etmenin en kolay yollar\u0131ndan biridir ve karma\u015f\u0131k form\u00fcllere bile ihtiyac\u0131n\u0131z yoktur. Burada bir isim listemiz var ve bu listeden benzersiz isimlerin say\u0131s\u0131n\u0131 sayman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"benzersiz de\u011ferleri saymak i\u00e7in bir liste\"><\/figure><\/div><p> Benzersiz de\u011ferleri elde etmek i\u00e7in gereken ad\u0131mlar \u015funlard\u0131r:<\/p><ol><li> \u00d6ncelikle listedeki <strong>h\u00fccrelerden birini se\u00e7in<\/strong> . <br><img decoding=\"async\" title=\"benzersiz-de\u011ferleri-min saymak i\u00e7in bir h\u00fccre se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-une-cellule-pour-compter-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"select a cell to count unique values\"><\/li><li> Bundan sonra Veri sekmesine gidin \u279c S\u0131rala ve Filtrele \u279c <strong>Geli\u015fmi\u015f&#8217;i t\u0131klay\u0131n<\/strong> . <br><img decoding=\"async\" title=\"benzersiz minimum de\u011ferleri saymak i\u00e7in t\u0131klamayla ilerleme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-avance-pour-compter-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"click on advance to count unique values\"><\/li><li> \u00dczerine t\u0131klad\u0131\u011f\u0131n\u0131zda, geli\u015fmi\u015f filtreleri uygulamak i\u00e7in bir a\u00e7\u0131l\u0131r pencere g\u00f6receksiniz.<\/li><li> \u015eimdi bu pencereden \u201c <strong>Ba\u015fka bir konuma kopyala<\/strong> \u201d se\u00e7ene\u011fini se\u00e7in.<\/li><li> &#8220;Kopyala&#8221; b\u00f6l\u00fcm\u00fcnde, benzersiz de\u011ferleri yap\u0131\u015ft\u0131rmak istedi\u011finiz <strong>bo\u015f bir h\u00fccreyi se\u00e7in<\/strong> .<\/li><li> \u015eimdi \u201c <strong>Yaln\u0131zca tek kay\u0131tlar<\/strong> \u201d kutusunu i\u015faretleyin ve Tamam&#8217;a t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"benzersiz-de\u011ferleri-min saymak i\u00e7in geli\u015fmi\u015f filtreli aral\u0131k se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-plage-avec-filtre-avance-pour-compter-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"select range with advance filter to count unique values\"><\/li><li> Bu noktada <strong>benzersiz de\u011ferlerin bir listesine<\/strong> sahipsiniz. <br><img decoding=\"async\" title=\"minimum-benzersiz-de\u011ferleri saymak i\u00e7in-benzersiz-de\u011ferlerin-listesini-alacaks\u0131n\u0131z\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vous-obtiendrez-une-liste-de-valeurs-uniques-pour-compter-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"you will get list of unique values to count unique values\"><\/li><li> \u015eimdi listedeki son h\u00fccrenin alt\u0131ndaki h\u00fccreye gidin ve <strong>a\u015fa\u011f\u0131daki form\u00fcl\u00fc ekleyip<\/strong> Enter tu\u015funa bas\u0131n.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTA(B2:B10)<\/code><\/pre><p> Bu ad listesindeki benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"geli\u015fmi\u015f filtreleri ve say\u0131m\u0131 kullanarak benzersiz de\u011ferleri say\u0131n\"><\/figure><\/div><p> Art\u0131k benzersiz de\u011ferlerin bir listesine sahipsiniz ve bunlar\u0131 da say\u0131yorsunuz. Bunun i\u00e7in herhangi bir karma\u015f\u0131k form\u00fcl yazman\u0131za gerek olmad\u0131\u011f\u0131ndan bu y\u00f6ntemi takip etmek basit ve kolayd\u0131r.<\/p><h2 class=\"wp-block-heading\"> Benzersiz de\u011ferleri saymak i\u00e7in SUM ve COUNTIF&#8217;i birle\u015ftirme<\/h2><p> Ayr\u0131 bir liste \u00e7\u0131karmadan tek bir h\u00fccredeki benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 bulmak istiyorsan\u0131z SUM ve COUNTIF kombinasyonunu kullanabilirsiniz.<\/p><p> Bu y\u00f6ntemde, yaln\u0131zca de\u011ferler listesine ba\u015fvurman\u0131z yeterlidir; form\u00fcl, benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir. Bu bir dizi form\u00fcl\u00fcd\u00fcr, bu nedenle onu tablo olarak girmeniz ve girerken Ctrl + Shift + Enter tu\u015flar\u0131n\u0131 kullanman\u0131z gerekir.<\/p><p> Ve form\u00fcl:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(1\/COUNTIF(A2:A17,A2:A17))<\/code><\/pre><p> Bu form\u00fcl\u00fc tablo halinde girdi\u011finizde a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecektir. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">{=SUM(1\/COUNTIF(A2:A17,A2:A17))}<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-les-valeurs-uniques-avec-somme-countif-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"countif sum ile benzersiz de\u011ferleri say\u0131n\" width=\"604\" height=\"416\" data-id=\"11957\"><\/p><h3 class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Bu form\u00fcl\u00fc anlamak i\u00e7in \u00fc\u00e7 par\u00e7aya ay\u0131rman\u0131z gerekiyor ve bu form\u00fcl\u00fc tablo halinde girdi\u011fimizi ve bu listede benzersiz de\u011fil toplam 16 de\u011ferin bulundu\u011funu hat\u0131rlaman\u0131z yeterli.<\/p><p> Tamam, \u00f6yleyse bak.<\/p><p> <strong>\u0130lk<\/strong> b\u00f6l\u00fcmde 16&#8217;dan ba\u015flayarak her bir de\u011ferin say\u0131s\u0131n\u0131 saymak i\u00e7in COUNIF&#8217;i kulland\u0131n\u0131z ve burada COUNTIF a\u015fa\u011f\u0131daki gibi de\u011ferler d\u00f6nd\u00fcr\u00fcyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/countif-comptera-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"countif benzersiz de\u011ferleri sayar\"><\/figure><\/div><p> <strong>\u0130kinci<\/strong> k\u0131s\u0131mda ise t\u00fcm de\u011ferleri 1&#8217;e b\u00f6l\u00fcyorsunuz ve bu \u015fekilde bir de\u011fer d\u00f6nd\u00fcr\u00fcyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/la-fonction-sum-additionnera-les-valeurs-uniques-min-1.png\" sizes=\"\" srcset=\"\" alt=\"toplam i\u015flevi benzersiz de\u011ferler ekleyecektir\"><\/figure><\/div><p class=\"content-box-green\"> Diyelim ki bir de\u011fer listede iki kez varsa her iki de\u011fer i\u00e7in de 0,5 de\u011ferini d\u00f6nd\u00fcrecek, b\u00f6ylece toplad\u0131\u011f\u0131n\u0131zda sonu\u00e7 1 olacak ve bir de\u011fer \u00fc\u00e7 kez varsa her biri i\u00e7in 0,333 de\u011ferini d\u00f6nd\u00fcrecek.<\/p><p> <strong>\u00dc\u00e7\u00fcnc\u00fc<\/strong> b\u00f6l\u00fcmde ise t\u00fcm bu de\u011ferleri toplamak i\u00e7in SUM fonksiyonunu kulland\u0131n\u0131z ve bir dizi benzersiz de\u011feriniz oldu.<\/p><p> Bu form\u00fcl olduk\u00e7a g\u00fc\u00e7l\u00fcd\u00fcr ve tek bir h\u00fccredeki say\u0131y\u0131 elde etmenize yard\u0131mc\u0131 olabilir.<\/p><h2 class=\"wp-block-heading\"> Bir listeden benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 almak i\u00e7in SUMproduct + COUNTIF kullan\u0131n<\/h2><p> Son y\u00f6ntemde SUM ve COUNTIF y\u00f6ntemlerini kulland\u0131n\u0131z. Ancak SUM yerine SUMproduct&#8217;\u0131 da kullanabilirsiniz.<\/p><p> Ve <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urun-2\/\">SUMproduct<\/a> kullan\u0131rken tablo bi\u00e7iminde bir form\u00fcl girmenize gerek yoktur. <a href=\"https:\/\/exceladvisor.org\/tr\/hucreyi-duzenle\/\">H\u00fccreyi d\u00fczenleyip a\u015fa\u011f\u0131daki form\u00fcl\u00fc girmeniz yeterlidir<\/a> .<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(1\/COUNTIF(A2:A17,A2:A17))<\/code><\/pre><p> Bu form\u00fcl\u00fc tablo halinde girdi\u011finizde a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecektir. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">{=SUMPRODUCT(1\/COUNTIF(A2:A17,A2:A17))}<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/sumproduct-pour-compter-les-valeurs-uniques-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"benzersiz de\u011ferleri saymak i\u00e7in sumproduct\" width=\"658\" height=\"414\" data-id=\"11964\"><\/p><h3 class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Bu form\u00fcl, yukar\u0131daki y\u00f6ntemde \u00f6\u011frendi\u011finizle tamamen ayn\u0131 \u015fekilde \u00e7al\u0131\u015f\u0131r; aradaki fark, SUM yerine SUMproduct&#8217;\u0131 kullanman\u0131zd\u0131r.<\/p><p> Ve SUMproduct, Ctrl+Shift+Enter kullanmadan bir dizi alabilir.<\/p><h2 class=\"wp-block-heading\"> Bir listeden yaln\u0131zca benzersiz metin de\u011ferlerini say\u0131n<\/h2><p> \u015eimdi, cep telefonu numaralar\u0131n\u0131z\u0131n da bulundu\u011fu bir ad listeniz oldu\u011funu ve benzersiz de\u011ferleri yaln\u0131zca metin de\u011ferlerinden saymak istedi\u011finizi varsayal\u0131m. Yani bu durumda a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(IF(ISTEXT(A2:A17),1\/COUNTIF(A2:A17, A2:A17),\u201d\u201d))<\/code><\/pre><p> Ve bu form\u00fcl\u00fc tablo halinde girdi\u011finizde. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">{=SUM(IF(ISTEXT(A2:A17),1\/COUNTIF(A2:A17, A2:A17),\u201d\u201d))}<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-les-valeurs-uniques-uniquement-le-texte-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"yaln\u0131zca benzersiz de\u011ferleri say metin\" width=\"749\" height=\"500\" data-id=\"11956\"><\/p><h3 id=\"tab-con-6\" class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Bu y\u00f6ntemde IF ve ISTEXT i\u015flevini kulland\u0131n\u0131z. ISTEXT \u00f6ncelikle t\u00fcm de\u011ferlerin metin olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve herhangi bir de\u011fer metin ise TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/istext-pour-compter-les-valeurs-uniques-uniquement-text-min-1.png\" sizes=\"\" srcset=\"\" alt=\"yaln\u0131zca benzersiz de\u011ferler i\u00e7in metni saymak i\u00e7in istext\"><\/figure><\/div><p> Bundan sonra IF, TRUE&#8217;ya sahip oldu\u011funuz ve di\u011fer de\u011ferlerin bo\u015f kald\u0131\u011f\u0131 t\u00fcm metin de\u011ferlerine COUNTIF uygular. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/si-la-fonction-compte-les-valeurs-uniques-uniquement-le-texte-min-1.png\" sizes=\"\" srcset=\"\" alt=\"i\u015flev yaln\u0131zca benzersiz de\u011ferleri say\u0131yorsa metin\"><\/figure><\/div><p> Ve sonunda SUM, metin olan t\u00fcm benzersiz de\u011ferlerin toplam\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr ve b\u00f6ylece benzersiz metin de\u011ferlerinin say\u0131s\u0131n\u0131 elde edersiniz.<\/p><h2 class=\"wp-block-heading\"> Bir listeden benzersiz say\u0131lar\u0131n say\u0131s\u0131n\u0131 al\u0131n<\/h2><p> Yaln\u0131zca bir de\u011fer listesinden benzersiz say\u0131lar\u0131 saymak istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(IF(ISNUMBER(A2:A17),1\/COUNTIF(A2:A17, A2:A17),\u201d\u201d))<\/code><\/pre><p> Bu form\u00fcl\u00fc tablo bi\u00e7iminde girin. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">{=SUM(IF(ISNUMBER(A2:A17),1\/COUNTIF(A2:A17, A2:A17),\u201d\u201d))}<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-les-valeurs-uniques-uniquement-nombre-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"benzersiz de\u011ferleri say yaln\u0131zca say\u0131\" width=\"768\" height=\"510\" data-id=\"11955\"><\/p><h3 id=\"tab-con-10\" class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Bu y\u00f6ntemde IF ve ISNUM fonksiyonlar\u0131n\u0131 kulland\u0131n\u0131z. ISNUMBER \u00f6ncelikle t\u00fcm de\u011ferlerin say\u0131sal olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve de\u011fer say\u0131 ise TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><p> Bundan sonra IF, TRUE&#8217;ya sahip oldu\u011funuz ve di\u011fer de\u011ferlerin bo\u015f kald\u0131\u011f\u0131 t\u00fcm say\u0131sal de\u011ferlere COUNTIF uygular.<\/p><p> Ve sonunda SUM, say\u0131 olan t\u00fcm benzersiz de\u011ferlerin toplam\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr ve b\u00f6ylece benzersiz say\u0131lar\u0131n say\u0131s\u0131n\u0131 elde edersiniz.<\/p><h2 class=\"wp-block-heading\"> UDF ile benzersiz de\u011ferleri say\u0131n<\/h2><p> Burada, herhangi bir form\u00fcl kullanmadan benzersiz de\u011ferleri sayman\u0131za yard\u0131mc\u0131 olabilecek <a href=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\">VBA&#8217;m (UDF)<\/a> var.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function CountUnique(ListRange As Range) As Integer Dim CellValue As Variant Dim UniqueValues As New Collection Application.Volatile On Error Resume Next For Each CellValue In ListRange UniqueValues.Add CellValue, CStr(CellValue) ' add the unique item Next CountUnique = UniqueValues.Count End Function<\/code><\/pre><p> Yeni bir mod\u00fcl ekleyerek bu i\u015flevi VBE&#8217;nize girin, ard\u0131ndan e-tablonuza gidin ve a\u015fa\u011f\u0131daki form\u00fcl\u00fc ekleyin. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CountUnique(range)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-les-valeurs-uniques-avec-vba-min-1.png\" sizes=\"\" srcset=\"\" alt=\"vba ile benzersiz de\u011ferleri say\u0131n\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/compter-les-valeurs-uniques2.zip\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> B\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken benzersiz de\u011ferleri saymak yararl\u0131 olabilir.<\/p><p> Burada kulland\u0131\u011f\u0131n\u0131z isimler listesinde m\u00fckerrer isimler vard\u0131 ve benzersiz say\u0131lar\u0131 hesaplad\u0131ktan sonra listede 10 benzersiz ismin oldu\u011funu elde ettik.<\/p><p> Burada \u00f6\u011frendi\u011finiz y\u00f6ntemlerin t\u00fcm\u00fc farkl\u0131 durumlarda faydal\u0131d\u0131r ve size en uygun oldu\u011funu d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcn\u00fcz y\u00f6ntemleri kullanabilirsiniz.<\/p><p> Bana sorarsan\u0131z geli\u015fmi\u015f filtre ve SUMproduct en sevdi\u011fim y\u00f6ntemlerdir ama \u015fimdi bana \u015funu s\u00f6ylemeniz gerekiyor:<\/p><p> <span style=\"color: #ea493f;\"><strong>Hangisi favorin?<\/strong><\/span><\/p><p> L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum b\u00f6l\u00fcm\u00fcnde 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-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/\">Excel&#8217;de metin i\u00e7eren h\u00fccreleri sayma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/belirli-karakterleri-say\/\">Excel&#8217;de belirli karakterleri say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-hucre-sayisini-say\/\">Excel&#8217;de bir aral\u0131ktaki toplam h\u00fccre say\u0131s\u0131n\u0131 say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/\">COUNT ve COUNTA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1825","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>2023&#039;te Excel&#039;de Benzersiz De\u011ferleri Sayman\u0131n 7 Yolu<\/title>\n<meta name=\"description\" content=\"Bunu yapmak i\u00e7in, bir de\u011feri yaln\u0131zca bir kez sayacak ve listedeki di\u011fer t\u00fcm olu\u015fumlar\u0131 yok sayacak bir y\u00f6ntem kullanman\u0131z gerekir...\" \/>\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\/benzersiz-degerleri-sayma-1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2023&#039;te Excel&#039;de Benzersiz De\u011ferleri Sayman\u0131n 7 Yolu\" \/>\n<meta property=\"og:description\" content=\"Bunu yapmak i\u00e7in, bir de\u011feri yaln\u0131zca bir kez sayacak ve listedeki di\u011fer t\u00fcm olu\u015fumlar\u0131 yok sayacak bir y\u00f6ntem kullanman\u0131z gerekir...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png\" \/>\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=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\",\"name\":\"2023&#39;te Excel&#39;de Benzersiz De\u011ferleri Sayman\u0131n 7 Yolu\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png\",\"datePublished\":\"2023-11-01T04:09:45+00:00\",\"dateModified\":\"2023-12-10T06:00:20+00:00\",\"description\":\"Bunu yapmak i\u00e7in, bir de\u011feri yaln\u0131zca bir kez sayacak ve listedeki di\u011fer t\u00fcm olu\u015fumlar\u0131 yok sayacak bir y\u00f6ntem kullanman\u0131z gerekir...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de benzersiz de\u011ferleri sayman\u0131n 7 yolu\"}]},{\"@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":"2023&#39;te Excel&#39;de Benzersiz De\u011ferleri Sayman\u0131n 7 Yolu","description":"Bunu yapmak i\u00e7in, bir de\u011feri yaln\u0131zca bir kez sayacak ve listedeki di\u011fer t\u00fcm olu\u015fumlar\u0131 yok sayacak bir y\u00f6ntem kullanman\u0131z gerekir...","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\/benzersiz-degerleri-sayma-1\/","og_locale":"tr_TR","og_type":"article","og_title":"2023&#39;te Excel&#39;de Benzersiz De\u011ferleri Sayman\u0131n 7 Yolu","og_description":"Bunu yapmak i\u00e7in, bir de\u011feri yaln\u0131zca bir kez sayacak ve listedeki di\u011fer t\u00fcm olu\u015fumlar\u0131 yok sayacak bir y\u00f6ntem kullanman\u0131z gerekir...","og_url":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/","url":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/","name":"2023&#39;te Excel&#39;de Benzersiz De\u011ferleri Sayman\u0131n 7 Yolu","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png","datePublished":"2023-11-01T04:09:45+00:00","dateModified":"2023-12-10T06:00:20+00:00","description":"Bunu yapmak i\u00e7in, bir de\u011feri yaln\u0131zca bir kez sayacak ve listedeki di\u011fer t\u00fcm olu\u015fumlar\u0131 yok sayacak bir y\u00f6ntem kullanman\u0131z gerekir...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-pour-compter-les-valeurs-uniques-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de benzersiz de\u011ferleri sayman\u0131n 7 yolu"}]},{"@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\/1825","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=1825"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1825\/revisions"}],"predecessor-version":[{"id":2398,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1825\/revisions\/2398"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}