\u00d6rne\u011fin, a\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 adlar\u0131 listesine sahip oldu\u011funuzu ve tekrarlanan adlar\u0131n say\u0131s\u0131n\u0131 saymak istedi\u011finizi varsayal\u0131m:<\/span> <\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler a\u015fa\u011f\u0131daki hesaplamalar\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6stermektedir:<\/span><\/p>\n 1.<\/strong> Her benzersiz tak\u0131m ad\u0131n\u0131n ka\u00e7 kez tekrarland\u0131\u011f\u0131n\u0131 say\u0131n<\/span><\/p>\n 2.<\/strong> Tekrarlanan tak\u0131m adlar\u0131n\u0131n toplam say\u0131s\u0131n\u0131 say\u0131n (1. olu\u015fum dahil)<\/span><\/p>\n 3.<\/strong> Tekrarlanan tak\u0131m adlar\u0131n\u0131n toplam say\u0131s\u0131n\u0131 say\u0131n (ilk tekrar\u0131 saymadan)<\/span><\/p>\n Hadi gidelim!<\/span><\/p>\n Her benzersiz tak\u0131m ad\u0131n\u0131n ka\u00e7 kez tekrarland\u0131\u011f\u0131n\u0131 saymak i\u00e7in, \u00f6nce C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazarak benzersiz tak\u0131m adlar\u0131n\u0131n bir listesini alabiliriz:<\/span> <\/p>\n Daha sonra, her tak\u0131m ad\u0131n\u0131n ka\u00e7 kez tekrarland\u0131\u011f\u0131n\u0131 saymak i\u00e7in D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span> <\/p>\n S\u00fctun D art\u0131k her benzersiz tak\u0131m ad\u0131n\u0131n ka\u00e7 kez g\u00f6r\u00fcnd\u00fc\u011f\u00fcn\u00fc g\u00f6steriyor.<\/span><\/p>\n Tak\u0131m s\u00fctunundaki toplam tekrar say\u0131s\u0131n\u0131 (1. olu\u015fum dahil) saymak i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabilirsiniz:<\/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 Form\u00fcl bize tak\u0131m s\u00fctununda toplam 8<\/strong> tekrarlanan kelimenin (1. ge\u00e7i\u015f dahil) bulundu\u011funu s\u00f6yl\u00fcyor.<\/span><\/p>\n Tekrarlanan 8 kelimeyi manuel olarak tan\u0131mlayarak bunun do\u011fru oldu\u011funu do\u011frulayabiliriz:<\/span> <\/p>\n Tak\u0131m s\u00fctunundaki toplam tekrar say\u0131s\u0131n\u0131 saymak i\u00e7in (1. olu\u015fumu saymaz), \u00f6nce her sat\u0131r\u0131n bir tekrar\u0131 temsil edip etmedi\u011fini belirlemek i\u00e7in B2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Daha sonra, tak\u0131m s\u00fctununda tekrarlanan kelimelerin toplam say\u0131s\u0131n\u0131 (1. tekrar\u0131 saymadan) saymak i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/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 Tak\u0131m s\u00fctununda toplamda (1. ge\u00e7i\u015f hari\u00e7) 5 adet<\/strong> tekrarlanan kelime oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer genel g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: h\u00fccreler metin i\u00e7eriyorsa nas\u0131l say\u0131l\u0131r<\/a> \u00c7o\u011fu zaman, Excel’deki bir s\u00fctunda bir kelimenin ka\u00e7 kez tekrarland\u0131\u011f\u0131n\u0131 saymak isteyebilirsiniz. \u00d6rne\u011fin, a\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 adlar\u0131 listesine sahip oldu\u011funuzu ve tekrarlanan adlar\u0131n say\u0131s\u0131n\u0131 saymak istedi\u011finizi varsayal\u0131m: A\u015fa\u011f\u0131daki \u00f6rnekler a\u015fa\u011f\u0131daki hesaplamalar\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6stermektedir: 1. Her benzersiz tak\u0131m ad\u0131n\u0131n ka\u00e7 kez tekrarland\u0131\u011f\u0131n\u0131 say\u0131n 2. Tekrarlanan tak\u0131m adlar\u0131n\u0131n toplam say\u0131s\u0131n\u0131 say\u0131n (1. olu\u015fum dahil) 3. Tekrarlanan […]<\/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-4830","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep1.png\")
<\/p>\n \u00d6rnek 1: Her kelimenin ka\u00e7 kez tekrarland\u0131\u011f\u0131n\u0131 say\u0131n<\/strong><\/span><\/h2>\n
=SINGLE( A2:A11<\/span> )<\/strong> <\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep2.png\")
<\/p>\n =COUNTIF( $A$2:$A$11<\/span> , C2<\/span> )<\/strong> <\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep3.png\")
<\/p>\n \u00d6rnek 2: Tekrarlanan kelimelerin toplam say\u0131s\u0131n\u0131 say\u0131n (1. ge\u00e7i\u015f dahil)<\/strong><\/span><\/h2>\n
=ROWS( $A$2:$A$11<\/span> )-SUM(IF(COUNTIF( $A$2:$A$11<\/span> , $A$2:$A$11<\/span> ) =1,1,0))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crep4.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crepe5.png\")
<\/p>\n \u00d6rnek 3: Tekrarlanan kelimelerin toplam say\u0131s\u0131n\u0131 say\u0131n (ilk tekrar\u0131 saymadan)<\/strong><\/span><\/h2>\n
=IF(COUNTIF( $A$2:$A2<\/span> , A2<\/span> )>1,\"Yes\",\"No\")<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crepe6.png\")
<\/p>\n =COUNTIF( B2:B11<\/span> , \"Yes\")<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/crepe7.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: benzersiz de\u011ferlerin gruba g\u00f6re nas\u0131l say\u0131laca\u011f\u0131<\/a>
Excel: birden fazla kritere g\u00f6re benzersiz de\u011ferlerin nas\u0131l say\u0131laca\u011f\u0131<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"