\u00d6rne\u011fin, farkl\u0131 basketbol tak\u0131mlar\u0131n\u0131n adlar\u0131n\u0131 i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki veri k\u00fcmesinde yaln\u0131zca yinelenen de\u011ferlere sahip tak\u0131mlar tutulacak \u015fekilde veri k\u00fcmesini filtrelemek istiyorsunuz.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n \u00d6ncelikle birden fazla kez g\u00f6r\u00fcnen tak\u0131m adlar\u0131n\u0131n bulundu\u011fu sat\u0131rlar\u0131 tan\u0131mlamam\u0131z gerekiyor.<\/span><\/p>\n Bunu yapmak i\u00e7in B2<\/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 Bu form\u00fcl, A s\u00fctunundaki her tak\u0131m ad\u0131n\u0131n birden fazla g\u00f6r\u00fcn\u00fcp g\u00f6r\u00fcnmedi\u011fini kontrol eder.<\/span><\/p>\n Tak\u0131m ad\u0131 birden fazla kez g\u00f6r\u00fcn\u00fcyorsa form\u00fcl TRUE<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Aksi takdirde form\u00fcl FALSE de\u011ferini<\/strong> d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Daha sonra, yaln\u0131zca birden fazla g\u00f6r\u00fcnen tak\u0131m adlar\u0131n\u0131n korunmas\u0131n\u0131 sa\u011flayacak \u015fekilde de\u011ferleri filtrelemek i\u00e7in D2<\/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 Filtrelenen veri k\u00fcmesinin yaln\u0131zca birden fazla kez ger\u00e7ekle\u015fen ekiplere ait sat\u0131rlar\u0131 i\u00e7erdi\u011fini fark ettim.<\/span><\/p>\n \u00d6rne\u011fin, a\u015fa\u011f\u0131daki tak\u0131mlar\u0131n t\u00fcm\u00fc filtrelendi:<\/span><\/p>\n Bu tak\u0131m adlar\u0131n\u0131n her biri orijinal veri k\u00fcmesinde yaln\u0131zca bir kez g\u00f6r\u00fcnd\u00fc.<\/span><\/p>\n B s\u00fctunundaki kar\u015f\u0131l\u0131k gelen de\u011ferin TRUE<\/strong> oldu\u011fu sat\u0131rlar i\u00e7in A s\u00fctununu filtrelemek amac\u0131yla FILTER<\/strong> i\u015flevini kulland\u0131\u011f\u0131m\u0131z\u0131 unutmay\u0131n.<\/span><\/p>\n Bu, orijinal listeyi, birden fazla kez meydana gelen herhangi bir tak\u0131m i\u00e7in yaln\u0131zca Tak\u0131m<\/b> s\u00fctunu de\u011ferlerini i\u00e7erecek \u015fekilde filtrelememize olanak sa\u011flad\u0131.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: kopyalar\u0131n nas\u0131l say\u0131laca\u011f\u0131<\/a> \u00c7o\u011fu zaman Excel’deki bir veri k\u00fcmesinde yaln\u0131zca yinelenen de\u011ferleri tutmak isteyebilirsiniz. \u00d6rne\u011fin, farkl\u0131 basketbol tak\u0131mlar\u0131n\u0131n adlar\u0131n\u0131 i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu varsayal\u0131m: Diyelim ki veri k\u00fcmesinde yaln\u0131zca yinelenen de\u011ferlere sahip tak\u0131mlar tutulacak \u015fekilde veri k\u00fcmesini filtrelemek istiyorsunuz. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. \u00d6rnek: Excel’de Yaln\u0131zca Yinelenen De\u011ferleri Tutun \u00d6ncelikle birden fazla […]<\/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-4822","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garded1.png\")
<\/p>\n \u00d6rnek: Excel’de Yaln\u0131zca Yinelenen De\u011ferleri Tutun<\/strong><\/h2>\n
=COUNTIF( $A$2:$A13<\/span> , $A2<\/span> )>1<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garded2.png\")
<\/p>\n =FILTER( A2:A13<\/span> , B2:B13<\/span> =TRUE)<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garded3.png\")
<\/p>\n\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: yinelenen sat\u0131rlar\u0131n nas\u0131l vurgulanaca\u011f\u0131<\/a>
Excel: D\u00dc\u015eEYARA Kullan\u0131larak Yinelenenler Nas\u0131l Bulunur?<\/a>
Excel: \u0130ki S\u00fctuna Dayal\u0131 Yinelenen Sat\u0131rlar\u0131 Kald\u0131rma<\/a>
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"