Y\u00f6ntem 1: Tek bir kritere g\u00f6re benzersiz de\u011ferleri say\u0131n<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl, C2<\/strong> :C10 aral\u0131\u011f\u0131nda kar\u015f\u0131l\u0131k gelen de\u011ferin 30’dan b\u00fcy\u00fck oldu\u011fu A2:<\/strong> A10 aral\u0131\u011f\u0131ndaki benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 sayar.<\/span><\/p>\n Y\u00f6ntem 2: Birden fazla kritere g\u00f6re benzersiz de\u011ferleri say\u0131n<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl, B2:B10<\/strong> aral\u0131\u011f\u0131ndaki kar\u015f\u0131l\u0131k gelen de\u011ferin “\u0130leri”ye e\u015fit oldu\u011fu ve C2<\/strong> :C10 aral\u0131\u011f\u0131ndaki de\u011ferin 20’den k\u00fc\u00e7\u00fck oldu\u011fu A2:A10<\/strong> aral\u0131\u011f\u0131ndaki benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 sayar.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, Google E-Tablolar’daki a\u015fa\u011f\u0131daki veri k\u00fcmesiyle her y\u00f6ntemin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n Tak\u0131m<\/strong> s\u00fctunundaki benzersiz de\u011ferleri saymak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaln\u0131zca Puan<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen de\u011ferler 30’dan b\u00fcy\u00fck oldu\u011funda kullanabiliriz:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n Sonu\u00e7 bize, Tak\u0131m<\/strong> s\u00fctununda yaln\u0131zca 2<\/strong> benzersiz de\u011fer bulundu\u011funu ve Puan<\/strong> s\u00fctununda kar\u015f\u0131l\u0131k gelen de\u011ferin 30’dan b\u00fcy\u00fck oldu\u011funu s\u00f6yler.<\/span><\/p>\n Orijinal veri setine bakarsak Puan<\/strong> s\u00fctunundaki de\u011ferin 30’dan b\u00fcy\u00fck oldu\u011fu 3 sat\u0131r oldu\u011funu g\u00f6rebiliriz ancak bu 3 sat\u0131r aras\u0131nda yaln\u0131zca iki benzersiz tak\u0131m ad\u0131 vard\u0131r: Mavs ve Spurs.<\/span><\/p>\n COUNTUNIQUEIFS<\/strong> form\u00fcl\u00fcn\u00fcn 2<\/strong> de\u011ferini d\u00f6nd\u00fcrmesinin nedeni budur.<\/span><\/p>\n Tak\u0131m<\/strong> s\u00fctunundaki benzersiz de\u011ferleri saymak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaln\u0131zca Konum<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen de\u011ferler “\u0130leri” oldu\u011funda ve Puanlar<\/strong> s\u00fctunundaki de\u011fer 20’den k\u00fc\u00e7\u00fck oldu\u011funda kullanabiliriz:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n Sonu\u00e7 bize, Tak\u0131m<\/strong> s\u00fctununda yaln\u0131zca 2<\/strong> benzersiz de\u011fer bulundu\u011funu, Konum<\/strong> s\u00fctununda kar\u015f\u0131l\u0131k gelen de\u011ferin “\u0130leri” oldu\u011funu ve Puan<\/strong> s\u00fctunundaki de\u011ferin 20’den k\u00fc\u00e7\u00fck oldu\u011funu s\u00f6yler.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar’da di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l yap\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Google E-Tablolar: Benzersiz Say\u0131larla PivotTable Olu\u015fturun<\/a> Google E-Tablolar’daki \u00f6l\u00e7\u00fctlere g\u00f6re benzersiz de\u011ferleri saymak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz: Y\u00f6ntem 1: Tek bir kritere g\u00f6re benzersiz de\u011ferleri say\u0131n = COUNTUNIQUEIFS ( A2:A10 , C2:C10 , ” >30 ” ) Bu \u00f6zel form\u00fcl, C2 :C10 aral\u0131\u011f\u0131nda kar\u015f\u0131l\u0131k gelen de\u011ferin 30’dan b\u00fcy\u00fck oldu\u011fu A2: A10 aral\u0131\u011f\u0131ndaki benzersiz de\u011ferlerin say\u0131s\u0131n\u0131 sayar. Y\u00f6ntem 2: Birden fazla kritere […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3809","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =<\/span> COUNTUNIQUEIFS<\/span> (<\/span> A2:A10<\/span> ,<\/span> C2:C10<\/span> ,<\/span> \" >30<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n =COUNTUNIQUEIFS( A2:A10<\/span> , B2:B10<\/span> , \" Forward<\/span> \"<\/span> , C2:C10<\/span> , \" <20<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ci1.jpg\")
<\/p>\n \u00d6rnek 1: Tek bir kritere g\u00f6re benzersiz de\u011ferleri say\u0131n<\/strong><\/span><\/h2>\n
=<\/span> COUNTUNIQUEIFS<\/span> (<\/span> A2:A10<\/span> ,<\/span> C2:C10<\/span> ,<\/span> \" >30<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n![\"Google](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ci2.jpg\")
<\/p>\n \u00d6rnek 2: Birden \u00e7ok kritere g\u00f6re benzersiz de\u011ferleri say\u0131n<\/strong><\/span><\/h2>\n
=COUNTUNIQUEIFS( A2:A10<\/span> , B2:B10<\/span> , \" Forward<\/span> \"<\/span> , C2:C10<\/span> , \" <20<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n![\"Google](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ci3.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Google E-Tablolar: Birden \u00e7ok s\u00fctunda tek bir liste olu\u015fturun<\/a>
Google E-Tablolar Sorgusu: Yaln\u0131zca benzersiz sat\u0131rlar nas\u0131l d\u00f6nd\u00fcr\u00fcl\u00fcr?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"