\u00d6rne\u011fin, \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu varsayal\u0131m:<\/span> <\/p>\n Yinelenen de\u011ferlere sahip herhangi bir tak\u0131m i\u00e7in Ekip<\/b> s\u00fctunundaki yinelenen ve orijinal de\u011ferleri kald\u0131rmak istedi\u011finizi varsayal\u0131m.<\/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 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 Daha sonra, tak\u0131m adlar\u0131n\u0131n birden \u00e7ok kez g\u00f6r\u00fcnd\u00fc\u011f\u00fc t\u00fcm sat\u0131rlar\u0131n kald\u0131r\u0131lmas\u0131 amac\u0131yla veri k\u00fcmesini filtrelemek i\u00e7in F2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n:<\/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 tam olarak bir 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 D s\u00fctunundaki kar\u015f\u0131l\u0131k gelen de\u011ferin FALSE<\/strong> oldu\u011fu sat\u0131rlar i\u00e7in A’dan C’ye kadar olan s\u00fctunlar\u0131 filtrelemek i\u00e7in FILTER<\/strong> i\u015flevini kulland\u0131\u011f\u0131m\u0131z\u0131 unutmay\u0131n.<\/span><\/p>\n Bu, yinelenen de\u011ferlere sahip herhangi bir tak\u0131m i\u00e7in Ekip<\/b> s\u00fctunundaki yinelenen ve orijinal de\u011ferleri kald\u0131rmam\u0131za olanak sa\u011flad\u0131.<\/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: kopyalar\u0131n nas\u0131l say\u0131laca\u011f\u0131<\/a> \u00c7o\u011fu zaman Excel’deki bir veri k\u00fcmesindeki yinelenen ve orijinal de\u011ferleri kald\u0131rmak isteyebilirsiniz. \u00d6rne\u011fin, \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu varsayal\u0131m: Yinelenen de\u011ferlere sahip herhangi bir tak\u0131m i\u00e7in Ekip s\u00fctunundaki yinelenen ve orijinal de\u011ferleri kald\u0131rmak istedi\u011finizi varsayal\u0131m. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. \u00d6rnek: Excel’de Yinelenen ve Orijinal De\u011ferleri […]<\/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-4821","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bd1.png\")
<\/p>\n \u00d6rnek: Excel’de Yinelenen ve Orijinal De\u011ferleri Kald\u0131rma<\/strong><\/h2>\n
=COUNTIF( $A$2:$A11<\/span> , $A2<\/span> )>1<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bd2.png\")
<\/p>\n =FILTER( A2:C11<\/span> , D2:D11<\/span> =FALSE)<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/bd3.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":"