\u00d6rne\u011fin, a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu ve renk ba\u015f\u0131na h\u00fccre say\u0131s\u0131n\u0131 saymak istedi\u011fimizi varsayal\u0131m:<\/span> <\/p>\n Bunu yapman\u0131n en kolay yolu Excel’de VBA kodu yazmakt\u0131r.<\/span><\/p>\n VBA’ya a\u015fina de\u011filseniz bu korkutucu g\u00f6r\u00fcnebilir, ancak s\u00fcre\u00e7 basittir ve a\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n \u0130lk \u00f6nce veri de\u011ferlerini Excel’e girin:<\/span> <\/p>\n Daha sonra, Geli\u015ftirici<\/strong> sekmesinin Excel’in \u00fcst \u015feridinde g\u00f6r\u00fcnd\u00fc\u011f\u00fcnden emin olmam\u0131z gerekiyor.<\/span><\/p>\n Bunu yapmak i\u00e7in Dosya<\/strong> sekmesini, ard\u0131ndan Se\u00e7enekler’i<\/strong> ve ard\u0131ndan \u015eeridi \u00d6zelle\u015ftir’i<\/strong> t\u0131klay\u0131n.<\/span><\/p>\n Ana Sekmeler<\/strong> ba\u015fl\u0131kl\u0131 b\u00f6l\u00fcm\u00fcn alt\u0131nda Geli\u015ftirici’nin<\/strong> yan\u0131ndaki kutuyu i\u015faretleyin ve ard\u0131ndan Tamam’a<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Daha sonra \u00fcst \u015feritteki Geli\u015ftirici<\/strong> sekmesine t\u0131klay\u0131n ve ard\u0131ndan Visual Basic<\/strong> simgesine t\u0131klay\u0131n:<\/span> <\/p>\n Ard\u0131ndan Ekle<\/strong> sekmesine t\u0131klay\u0131n ve ard\u0131ndan a\u00e7\u0131l\u0131r men\u00fcden Mod\u00fcl’e<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Daha sonra a\u015fa\u011f\u0131daki kodu mod\u00fcl\u00fcn kod d\u00fczenleyicisine yap\u0131\u015ft\u0131r\u0131n:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Daha sonra VB edit\u00f6r\u00fcn\u00fc kapat\u0131n.<\/span><\/p>\n Son olarak olu\u015fturdu\u011fumuz makroyu renk baz\u0131nda h\u00fccre say\u0131s\u0131n\u0131 saymak i\u00e7in kullanabiliriz.<\/span><\/p>\n \u00d6ncelikle C2:C4<\/strong> h\u00fccrelerini say\u0131s\u0131n\u0131 bulmak istedi\u011finiz renklerle doldurun.<\/span><\/p>\n Daha sonra D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n:<\/span><\/p>\n Bu form\u00fcl\u00fc D s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyip doldurun; form\u00fcl, belirli arka plan renklerine sahip h\u00fccrelerin her birini otomatik olarak sayar:<\/span> <\/p>\n \u00d6rne\u011fin \u015funu g\u00f6rebiliriz:<\/span><\/p>\n Not<\/strong> : C s\u00fctununda arama aral\u0131\u011f\u0131nda bulunmayan bir h\u00fccre rengi sa\u011flarsan\u0131z, i\u015flev yaln\u0131zca 0 de\u011ferini d\u00f6nd\u00fcrecektir.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de Renge G\u00f6re Ortalama Nas\u0131l Al\u0131n\u0131r?<\/a> \u00c7o\u011fu zaman Excel’deki h\u00fccrelerin say\u0131s\u0131n\u0131 renklerine g\u00f6re saymak isteyebilirsiniz. \u00d6rne\u011fin, a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu ve renk ba\u015f\u0131na h\u00fccre say\u0131s\u0131n\u0131 saymak istedi\u011fimizi varsayal\u0131m: Bunu yapman\u0131n en kolay yolu Excel’de VBA kodu yazmakt\u0131r. VBA’ya a\u015fina de\u011filseniz bu korkutucu g\u00f6r\u00fcnebilir, ancak s\u00fcre\u00e7 basittir ve a\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. 1. Ad\u0131m: Verileri […]<\/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-5089","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc2.png\")
<\/p>\n 1. Ad\u0131m: Verileri girin<\/strong><\/span><\/h2>\n
<\/p>\n Ad\u0131m 2: Excel’de Geli\u015ftirici Sekmesini G\u00f6ster<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc1.png\")
<\/p>\n 3. Ad\u0131m: VBA Kullanarak Makro Olu\u015fturma<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc3.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc4.png\")
<\/p>\n Function<\/span> CountByColor(CellRange As Range, CellColor As Range)\n\nDim<\/span> CellColorValue As<\/span> Integer\nDim<\/span> RunningCount As<\/span> Long\n\nCellColorValue = CellColor.Interior.ColorIndex\nSet<\/span> i = CellRange\n\nFor Each<\/span> i In<\/span> CellRange\n If<\/span> i.Interior.ColorIndex = CellColorValue Then<\/span>\n RunningCount = RunningCount + 1\nEnd If<\/span>\nNext<\/span> i\n\nCountByColor = RunningCount\n\nEnd Function\n<\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptecouleur0.png\")
<\/p>\n Ad\u0131m 4: Renge G\u00f6re Saymak i\u00e7in Makroyu Kullan\u0131n<\/strong><\/span><\/h2>\n
=CountByColor( $A$2:$A$11<\/span> , C2<\/span> )<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptecouleur2.png\")
<\/p>\n\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel’de gruba g\u00f6re sayma<\/a>
Excel’de gruba g\u00f6re benzersiz de\u011ferler nas\u0131l say\u0131l\u0131r?<\/a>
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"