\u00d6rne\u011fin, \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgiler i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu ve Tak\u0131m<\/strong> s\u00fctununda yinelenen de\u011ferlere sahip sat\u0131rlar\u0131 kald\u0131rmak, ancak Puanlar<\/strong> s\u00fctununda maksimum de\u011fere sahip sat\u0131r\u0131 tutmak 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 D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n:<\/span><\/p>\n Bu, veri k\u00fcmesinden benzersiz tak\u0131m adlar\u0131n\u0131n bir listesini olu\u015fturur:<\/span> <\/p>\n Daha sonra, her benzersiz tak\u0131m ad\u0131yla ili\u015fkili puan s\u00fctunundaki maksimum de\u011feri bulmak i\u00e7in E2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n:<\/span><\/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><\/span> <\/p>\n D ve E s\u00fctunlar\u0131 art\u0131k orijinal veri k\u00fcmesini, ekip s\u00fctununda yinelenen de\u011ferlere sahip olan ve puan s\u00fctununda yaln\u0131zca maksimum de\u011fere sahip sat\u0131rlar\u0131 tutan kald\u0131r\u0131lm\u0131\u015f sat\u0131rlarla g\u00f6steriyor.<\/span><\/p>\n \u00d6rne\u011fin tak\u0131m s\u00fctununda yinelenen “Mavs” de\u011ferine sahip \u00fc\u00e7 sat\u0131r var ancak bu \u00fc\u00e7 sat\u0131r aras\u0131nda maksimum puan de\u011ferine sahip olan sat\u0131r 28 puanl\u0131 olan\u0131d\u0131r:<\/span> <\/p>\n Bu, filtrelenmi\u015f veri k\u00fcmesindeki \u201cMavs\u201d sat\u0131rlar\u0131 aras\u0131nda tutulan sat\u0131rd\u0131r.<\/span><\/p>\n Ayn\u0131 s\u00fcre\u00e7 Spurs ve Rockets i\u00e7in de tekrarlan\u0131yor.<\/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’de yinelenen sat\u0131rlar\u0131 kald\u0131rmak, ancak maksimum de\u011feri i\u00e7eren sat\u0131r\u0131 belirli bir s\u00fctunda tutmak isteyebilirsiniz. \u00d6rne\u011fin, \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgiler i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu ve Tak\u0131m s\u00fctununda yinelenen de\u011ferlere sahip sat\u0131rlar\u0131 kald\u0131rmak, ancak Puanlar s\u00fctununda maksimum de\u011fere sahip sat\u0131r\u0131 tutmak istedi\u011finizi varsayal\u0131m: A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. \u00d6rnek: […]<\/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-4819","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/km1.png\")
<\/p>\n \u00d6rnek: Yinelenenleri kald\u0131r\u0131n ancak Excel’de sat\u0131r\u0131 maksimum de\u011ferde tutun<\/strong><\/h2>\n
=SINGLE( A2:A10 )<\/span><\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/km2.png\")
<\/p>\n =MAX(IF( $A$2:$A$10<\/span> = D2<\/span> , $B$2:$B$10<\/span> ))<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/km3.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/km4.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
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":"