{"id":1624,"date":"2023-11-15T05:22:32","date_gmt":"2023-11-15T05:22:32","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/"},"modified":"2023-12-10T06:04:58","modified_gmt":"2023-12-10T06:04:58","slug":"benzersiz-degerleri-say","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/","title":{"rendered":"Pivot tablodaki benzersiz de\u011ferleri say\u0131n"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2761016681\"><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> <h2 class=\"wp-block-heading\">PivotTable ile Veri Modeli Kullanma<\/h2><p> Veri modeli, Microsoft Excel&#8217;in yeni s\u00fcr\u00fcmlerinde ho\u015fuma giden ba\u015fka bir \u015fey. Microsoft 365 i\u00e7in Excel, Excel 2019, Excel 2016 ve Excel 2013 kullan\u0131yorsan\u0131z veri modeline eri\u015febilirsiniz.<\/p><ol><li> Ba\u015flamak i\u00e7in verilerdeki herhangi bir h\u00fccreye t\u0131klay\u0131n ve \u015feridinizdeki &#8220;Ek&#8221; sekmesine gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-ekleme sekmesine git\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-insert-tab\" width=\"457\" height=\"151\"><\/li><li> Pivot tabloda buraya t\u0131klad\u0131\u011f\u0131n\u0131zda bir ileti\u015fim kutusu g\u00f6r\u00fcn\u00fcr. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-t\u0131klatmal\u0131 pivot tablo-ileti\u015fim kutusu-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-la-boite-de-dialogue-du-tableau-croise-dynamique-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-on-pivot-table-dialogue-box\" width=\"437\" height=\"392\"><\/li><li> \u015eimdi ileti\u015fim kutusunun alt\u0131ndaki &#8220;Bu verileri veri modeline ekle&#8221; kutusunu i\u015faretleyin ve Tamam&#8217;a bas\u0131n.<\/li><li> Bundan sonra, her zamanki gibi bir pivot tablo elde edecek ve daha \u00f6nce yapt\u0131\u011f\u0131n\u0131z gibi pivot tablo alanlar\u0131ndaki verilerinizi d\u00fczenleyeceksiniz. Bu size daha \u00f6nce sahip oldu\u011funuz pivot tablonun ayn\u0131s\u0131n\u0131 verecektir, ancak pivot tablo alanlar\u0131 biraz farkl\u0131d\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-ola\u011fan-pivot-dizi-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-tableau-croise-dynamique-habituel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"usual-pivot-table\" width=\"599\" height=\"370\"><\/li><li> \u0130\u015fin p\u00fcf noktas\u0131 \u015fu: PivotTable alanlar\u0131nda &#8220;Hizmet Sa\u011flay\u0131c\u0131 Say\u0131s\u0131&#8221;n\u0131n yan\u0131ndaki k\u00fc\u00e7\u00fck oku t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-hizmet-sa\u011flay\u0131c\u0131-say\u0131-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nombre-de-fournisseur-de-services-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"count-of-service-provider\" width=\"335\" height=\"199\"><\/li><li> Bundan sonra \u201cDe\u011fer Alan\u0131 Ayarlar\u0131\u201dna t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 de\u011ferli alan parametreleri -1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-parametres-de-champ-de-valeur-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"value-field-settings\" width=\"194\" height=\"260\"><\/li><li> \u015eimdi \u201cAyr\u0131 Hesap\u201d almak i\u00e7in sonuna kadar kayd\u0131r\u0131n ve Tamam&#8217;a t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-farkl\u0131-saya\u00e7-t\u0131klama-tamam-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-compte-distinct-cliquez-sur-ok-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"distinct-count-click-ok\" width=\"396\" height=\"357\"><\/li><li> \u0130\u015fte ba\u015fl\u0131yoruz: Pivot tablodaki her b\u00f6lge i\u00e7in farkl\u0131\/benzersiz bir numaran\u0131z var. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-her nedenin-farkl\u0131-say\u0131-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-nombre-distinct-de-chaque-raison-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"distinct-count-of-each-reason\" width=\"293\" height=\"117\"><\/li><\/ol><p> Bu nedenle \u00fclkede yaln\u0131zca 18 benzersiz hizmet sa\u011flay\u0131c\u0131m\u0131z var.<\/p><h2 class=\"wp-block-heading\"> E\u011eERSAY i\u015flevini kullanma<\/h2><p> Benzersiz giri\u015fleri hesaplaman\u0131n ba\u015fka bir yakla\u015f\u0131m\u0131 da veri sayfan\u0131zda COUNTIF form\u00fcl\u00fcn\u00fc kullanmakt\u0131r.<\/p><ul><li> Verilerinize se\u00e7ti\u011finiz ba\u015fl\u0131\u011f\u0131 i\u00e7eren bir s\u00fctun ekleyerek ba\u015flayal\u0131m. Burada buna \u201cSayma No\u201d diyece\u011fiz.<\/li><li> Bu form\u00fcl\u00fc (=E\u011eER (E\u011eERSAY ($B$2:B2,B2)&gt;1,0,1)) D2 h\u00fccresine ekleyin ve sonuna s\u00fcr\u00fckleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59147\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-en-utilisant-la-fonction-countif-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"sayma fonksiyonunu kullanma\" width=\"310\" height=\"120\"><\/figure><\/div><h3 class=\"wp-block-heading\"> <strong>Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/h3><p> \u00d6ncelikle Mutlak olarak da adland\u0131r\u0131lan aral\u0131\u011f\u0131n ba\u015flang\u0131\u00e7 noktas\u0131n\u0131 yani $B$2&#8217;yi belirliyoruz. Bu, form\u00fcl\u00fcn\u00fcz\u00fc a\u015fa\u011f\u0131 s\u00fcr\u00fckleseniz bile de\u011fi\u015fmeyece\u011fi anlam\u0131na gelir. Art\u0131k form\u00fcl\u00fc D3&#8217;e s\u00fcr\u00fckledi\u011finizde, bu form\u00fcl IF(COUNTIF($B$2:B3,B3)&gt;1,0,1) olur.<\/p><p> \u015e\u00f6yle oku<\/p><p> <strong>Countif<\/strong> ( <strong>$B$2:B3<\/strong> , <strong>B3<\/strong> ), <strong>B3&#8217;\u00fcn<\/strong> <strong>$B$2:B3 aral\u0131\u011f\u0131 aras\u0131nda ka\u00e7 kez bulundu\u011funu size verecektir.<\/strong> IF i\u015flevi bir ko\u015ful eklemek i\u00e7in kullan\u0131l\u0131r: IF (( <strong>belirli bir aral\u0131kta B3&#8217;\u00fcn bulunma say\u0131s\u0131<\/strong> ) 1&#8217;den b\u00fcy\u00fckse, 0 verin, aksi halde 1 d\u00f6nd\u00fcr\u00fcn)<\/p><p> \u015eimdi, e\u011fer verilen s\u00fctundaki isim birden fazla \u00e7\u0131karsa form\u00fcl size 0 de\u011ferini d\u00f6nd\u00fcrecektir, aksi halde 1 elde edeceksiniz. Dolay\u0131s\u0131yla t\u00fcm bu tekrarlanan isimler i\u00e7in Say\u0131m no s\u00fctununda 0 elde edeceksiniz.<\/p><ol><li> \u015eimdi verilerinizle bir pivot tablo olu\u015fturun. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-bir-pivot-tahtas\u0131-olu\u015ftur-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-creer-un-tableau-croise-dynamique-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-a-pivot-table\" width=\"433\" height=\"143\"><\/li><li> Burada ROWS&#8217;a Location ve de\u011ferlere Count No&#8217;yu eklemeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-sat\u0131ra-1 konum ekleme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-ajouter-des-emplacements-a-la-rangee-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-locations-to-the-row\" width=\"310\" height=\"386\"><\/li><li> Boom!! Pivot tablo, her pivot tabloda benzersiz giri\u015flerle haz\u0131rd\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"Benzersiz giri\u015flere sahip 11 pivot tablo\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-tableau-croise-dynamique-avec-des-entrees-uniques-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"pivot-table-with-unique-entries\" width=\"156\" height=\"141\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Benzersiz de\u011ferleri saymak i\u00e7in Power Pivot&#8217;u kullan\u0131n<\/h2><p> \u0130\u015fte benzersiz giri\u015fleri tan\u0131mlaman\u0131n en g\u00fc\u00e7l\u00fc y\u00f6ntemi; G\u00fc\u00e7 pivotu. \u015eeridinizde Power Pivot sekmesinin bulundu\u011fundan emin olun. Sekmeyi bulam\u0131yorsan\u0131z <a href=\"https:\/\/exceladvisor.org\/tr\/guc-pivotunu-etkinlestir\/\" data-wpil=\"url\">bu e\u011fiticiye g\u00f6z at\u0131n<\/a> .<\/p><ol><li> Daha \u00f6nce de s\u00f6yledi\u011fimiz gibi \u00f6ncelikle Power Pivot sekmesinin etkin oldu\u011fundan emin olun. <br><img loading=\"lazy\" decoding=\"async\" title=\"Benzersiz de\u011ferleri saymak i\u00e7in 12 g\u00fc\u00e7l\u00fc pivot\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-pivots-de-puissance-pour-compter-les-valeurs-uniques.png\" sizes=\"auto, \" srcset=\"\" alt=\"power-pivot-to-count-unique-values\" width=\"612\" height=\"155\"><\/li><li> Bundan sonra veri modeline gidin ve <strong>Y\u00f6net d\u00fc\u011fmesine<\/strong> t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"13-veri modeli-y\u00f6net-d\u00fc\u011fmesine t\u0131klay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-modele-de-donnees-cliquez-sur-le-bouton-gerer.png\" sizes=\"auto, \" srcset=\"\" alt=\"data-model-click-manage-button\" width=\"608\" height=\"154\"><\/li><li> Burada, verileri ilk kez i\u00e7e aktarman\u0131z durumunda kesinlikle bo\u015f olacak bir pencere a\u00e7\u0131lacakt\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"14-bo\u015f-pencere-a\u00e7\u0131k\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-fenetre-vierge-ouverte.png\" sizes=\"auto, \" srcset=\"\" alt=\"blank-window-opened\" width=\"652\" height=\"694\"><\/li><li> Ana Sayfa \u2192 D\u0131\u015f Verileri Al&#8217;a t\u0131klay\u0131n <br><img loading=\"lazy\" decoding=\"async\" title=\"15-eve gitme-t\u0131klama-harici-veri\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-aller-a-la-maison-cliquer-sur-les-donnees-externes.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-home-click-external-data\" width=\"564\" height=\"228\"><\/li><li> Burada verileri indirmek i\u00e7in \u00e7e\u015fitli se\u00e7enekler ve kaynaklar bulacaks\u0131n\u0131z. Ancak basit bir excel indirmemiz gerekiyor. Bu y\u00fczden ad\u0131mlar\u0131 ve ekran g\u00f6r\u00fcnt\u00fclerini takip edin ve \u201cDi\u011fer kaynaklardan\u201d se\u00e7ene\u011fini t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"16-veri-y\u00fckleme-i\u00e7in-\u00e7oklu-se\u00e7enekler\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-options-multiples-pour-telecharger-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"multiple-options-to-upload-data\" width=\"576\" height=\"233\"><\/li><li> \u015eimdi tekrar a\u00e7\u0131k bir ileti\u015fim kutusu g\u00f6receksiniz. Excel dosyas\u0131 se\u00e7ene\u011fini almak i\u00e7in sonuna kadar kayd\u0131r\u0131n ve \u0130leri&#8217;ye t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"17 diyalog\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-boite-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"dialogue-box\" width=\"655\" height=\"528\"><\/li><li> Burada ba\u011flant\u0131y\u0131 varsay\u0131lan ad\u0131 olan \u201cExcel\u201dden yeniden adland\u0131rabilirsiniz. Veri dosyan\u0131z\u0131n yolunu se\u00e7mek i\u00e7in G\u00f6zat&#8217;\u0131 t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"18-ba\u011flant\u0131y\u0131 yeniden adland\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-renommer-la-connexion-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"rename-the-connection\" width=\"649\" height=\"524\"><\/li><li> Ayr\u0131ca \u00fcstteki s\u00fctunun ba\u015fl\u0131k sat\u0131r\u0131 olmas\u0131n\u0131 istiyorsan\u0131z \u201c\u0130lk sat\u0131r\u0131 s\u00fctun ba\u015fl\u0131\u011f\u0131 olarak kullan\u201d se\u00e7ene\u011fini i\u015faretleyin ve \u0130leri\u2019ye t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"Ba\u015fl\u0131k sat\u0131r\u0131 olacak 19 s\u00fctun\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-colonne-pour-etre-la-ligne-den-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"column-to-be-header-row\" width=\"625\" height=\"504\"><\/li><li> Sonunda dosya veri modeline aktar\u0131l\u0131r ve bitir&#8217;e t\u0131klan\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"Verilerde i\u00e7e aktar\u0131lan 20 dosya\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-fichier-importe-dans-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"file-imported-to-the-data\" width=\"622\" height=\"502\"><\/li><li> \u0130\u015fte ba\u015fl\u0131yoruz: 28 sat\u0131r\u0131n tamam\u0131 i\u00e7e aktar\u0131ld\u0131\u011f\u0131nda ba\u015far\u0131l\u0131 oldu. \u015eimdi yak\u0131ndan sald\u0131r\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"21 sat\u0131r i\u00e7e aktar\u0131lan isabet kapatma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-lignes-importees-cloturees.png\" sizes=\"auto, \" srcset=\"\" alt=\"rows-imported-hit-close\" width=\"644\" height=\"519\"><\/li><li> \u015eimdi g\u00f6r\u00fcnen bu. <br><img loading=\"lazy\" decoding=\"async\" title=\"22 \u00f6rnek gibi g\u00f6r\u00fcn\u00fcyor\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-echantillon-ressemble.png\" sizes=\"auto, \" srcset=\"\" alt=\"sample-looks-like\" width=\"428\" height=\"468\"><\/li><li> Buradan Ana Sayfa \u2192 Pivot Tablo ile bir pivot tablo olu\u015fturaca\u011f\u0131z <br><img loading=\"lazy\" decoding=\"async\" title=\"23-ev ba\u015f\u0131na bir pivot tahtas\u0131 olu\u015fturun\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-creer-un-tableau-croise-dynamique-par-maison.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-pivot-table-by-home\" width=\"692\" height=\"223\"><\/li><li> Sayfa 1\u2019de veriler elimizde oldu\u011fu i\u00e7in yan\u0131ndaki k\u00fc\u00e7\u00fck \u00fc\u00e7gene t\u0131klayarak s\u00fctunlar\u0131 geni\u015fletece\u011fiz. <br><img loading=\"lazy\" decoding=\"async\" title=\"24-s\u00fctunlar\u0131-geni\u015flet\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-developper-les-colonnes-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"expand-the-columns\" width=\"585\" height=\"371\"><\/li><li> \u015eimdi daha \u00f6nce yapt\u0131\u011f\u0131m\u0131z gibi lokasyonu hatlara, servis sa\u011flay\u0131c\u0131lar\u0131 da de\u011ferlere koyun. Bu, toplam hizmet sa\u011flay\u0131c\u0131 say\u0131s\u0131n\u0131 i\u00e7eren basit bir pivot tabloyla sonu\u00e7lanacakt\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"S\u0131ralardaki 25 yerin konumu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Emplacement-de-25-places-sur-les-rangs.png\" sizes=\"auto, \" srcset=\"\" alt=\"place-location-on-the-rows\" width=\"194\" height=\"135\"><\/li><li> \u0130\u015fin p\u00fcf noktas\u0131 burada. \u015eimdi PowerPivot penceresine gidin ve <strong>Yeni \u00d6l\u00e7\u00fcm<\/strong> se\u00e7ene\u011fini almak i\u00e7in <strong>\u00d6l\u00e7&#8217;e<\/strong> t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"26 G\u00fc\u00e7 Pivot Penceresi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-vitres-a-pivot-electrique.png\" sizes=\"auto, \" srcset=\"\" alt=\"power-pivot-window\" width=\"556\" height=\"347\"><\/li><li> \u015eimdi istedi\u011finiz ismin a\u00e7\u0131klamas\u0131n\u0131 ekleyin ve form\u00fcller b\u00f6l\u00fcm\u00fcne form\u00fcl\u00fc yazmaya ba\u015flay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"27-istenen-isim-ve-form\u00fcl\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-nom-et-formule-souhaites.png\" sizes=\"auto, \" srcset=\"\" alt=\"desired-name-and-formula\" width=\"502\" height=\"364\"><\/li><li> Yazmaya ba\u015flad\u0131\u011f\u0131n\u0131zda \u00f6nerileri otomatik olarak alacaks\u0131n\u0131z. Burada ayr\u0131 say\u0131m fonksiyonuna ihtiyac\u0131m\u0131z var. Farkl\u0131 sayma i\u015flevini se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"28-se\u00e7im-farkl\u0131-sayma fonksiyonu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-selectionner-la-fonction-de-comptage-distinct.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-distinct-count-function\" width=\"564\" height=\"410\"><\/li><li> Bundan sonra sekme tu\u015funa bas\u0131n veya bir parantez ba\u015flat\u0131n ( ve farkl\u0131 say\u0131ya ihtiyac\u0131m\u0131z olan s\u00fctunu se\u00e7in. Burada oldu\u011fu gibi farkl\u0131 say\u0131da servis sa\u011flay\u0131c\u0131ya ihtiyac\u0131m\u0131z var. Bu nedenle form\u00fcl\u00fcm\u00fcz \u015fu \u015fekilde g\u00f6r\u00fcnecektir = DISTINCTCOUNT(Sayfa1[Servis Sa\u011flay\u0131c\u0131 ]) ) <br><img loading=\"lazy\" decoding=\"async\" title=\"29-sekme d\u00fc\u011fmesine bas\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-appuyez-sur-le-bouton-de-tabulation.png\" sizes=\"auto, \" srcset=\"\" alt=\"press-the-tab-button\" width=\"567\" height=\"412\"><\/li><li> Sonunda kategoriyi se\u00e7in. Hizmet sa\u011flay\u0131c\u0131lar\u0131n benzersiz say\u0131s\u0131n\u0131 buldu\u011fumuz i\u00e7in \u201cNumaralar\u201d kategorisini se\u00e7ece\u011fiz. <br><img loading=\"lazy\" decoding=\"async\" title=\"30-kategori se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/30-selectionner-la-categorie.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-category\" width=\"497\" height=\"361\"><\/li><li> Format\u0131 \u201cTamsay\u0131\u201d olarak de\u011fi\u015ftirin ve Tamam&#8217;a bas\u0131n. Pivot tabloya size benzersiz giri\u015fleri sa\u011flayacak ba\u015fka bir s\u00fctun eklenecektir. <br><img loading=\"lazy\" decoding=\"async\" title=\"31-bi\u00e7imi-tam say\u0131ya-de\u011fi\u015ftirin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-changer-le-format-en-nombre-entier.png\" sizes=\"auto, \" srcset=\"\" alt=\"change-format-to-whole-number\" width=\"263\" height=\"120\"><\/li><\/ol><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Pivot tablolar hakk\u0131nda daha fazla bilgi edinin <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-3\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\">Hesaplanm\u0131\u015f bir alan ve \u00f6\u011fe ekleme (pivot tablodaki form\u00fcller)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rutbe-sutunu\/\">Excel&#8217;de pivot tabloya sat\u0131r ekleme<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/grup-tarihleri\/\">Tarihleri bir pivot tabloda gruplama<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\">Pivot Tablo E\u011fitimine<\/a> Geri D\u00f6n<\/p><\/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-1624","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>Pivot tablodaki benzersiz de\u011ferleri say\u0131n<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, farkl\u0131 y\u00f6ntemler kullanarak bir pivot tablodaki benzersiz de\u011ferlerin nas\u0131l say\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenebilirsiniz.\" \/>\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-say\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot tablodaki benzersiz de\u011ferleri say\u0131n\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, farkl\u0131 y\u00f6ntemler kullanarak bir pivot tablodaki benzersiz de\u011ferlerin nas\u0131l say\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenebilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.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=\"5 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-say\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/\",\"name\":\"Pivot tablodaki benzersiz de\u011ferleri say\u0131n\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\",\"datePublished\":\"2023-11-15T05:22:32+00:00\",\"dateModified\":\"2023-12-10T06:04:58+00:00\",\"description\":\"Bu e\u011fitimde, farkl\u0131 y\u00f6ntemler kullanarak bir pivot tablodaki benzersiz de\u011ferlerin nas\u0131l say\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenebilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pivot tablodaki benzersiz de\u011ferleri say\u0131n\"}]},{\"@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":"Pivot tablodaki benzersiz de\u011ferleri say\u0131n","description":"Bu e\u011fitimde, farkl\u0131 y\u00f6ntemler kullanarak bir pivot tablodaki benzersiz de\u011ferlerin nas\u0131l say\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenebilirsiniz.","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-say\/","og_locale":"tr_TR","og_type":"article","og_title":"Pivot tablodaki benzersiz de\u011ferleri say\u0131n","og_description":"Bu e\u011fitimde, farkl\u0131 y\u00f6ntemler kullanarak bir pivot tablodaki benzersiz de\u011ferlerin nas\u0131l say\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenebilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png","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\/benzersiz-degerleri-say\/","url":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/","name":"Pivot tablodaki benzersiz de\u011ferleri say\u0131n","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png","datePublished":"2023-11-15T05:22:32+00:00","dateModified":"2023-12-10T06:04:58+00:00","description":"Bu e\u011fitimde, farkl\u0131 y\u00f6ntemler kullanarak bir pivot tablodaki benzersiz de\u011ferlerin nas\u0131l say\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenebilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-aller-a-longlet-inserer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-say\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Pivot tablodaki benzersiz de\u011ferleri say\u0131n"}]},{"@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\/1624","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=1624"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1624\/revisions"}],"predecessor-version":[{"id":2781,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1624\/revisions\/2781"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}