![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tn1.png\")
<\/p>\n
A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n B2:B13<\/strong> aral\u0131\u011f\u0131ndaki en b\u00fcy\u00fck de\u011feri bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n Bu form\u00fcl\u00fc D2<\/strong> h\u00fccresine yazaca\u011f\u0131z:<\/span><\/span> <\/p>\n Puan s\u00fctununda en b\u00fcy\u00fck de\u011ferin 99<\/strong> oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n Daha sonra, a\u015fa\u011f\u0131daki en b\u00fcy\u00fck d\u00f6rt de\u011feri bulmak i\u00e7in bu form\u00fcl\u00fc t\u0131klay\u0131p D s\u00fctunundaki d\u00f6rt ek h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n S\u00fctun D art\u0131k orijinal veri k\u00fcmesindeki ilk be\u015f puan\u0131 g\u00f6steriyor.<\/span><\/span><\/p>\n Daha sonra, en y\u00fcksek puana kar\u015f\u0131l\u0131k gelen ad\u0131 \u00e7\u0131karmak i\u00e7in E2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p E s\u00fctunundaki kalan h\u00fccrelere s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Art\u0131k ilk 5 puan\u0131, bu puanlara kar\u015f\u0131l\u0131k gelen isimlerle birlikte orijinal veri k\u00fcmesinden \u00e7\u0131kard\u0131k.<\/span><\/p>\n Her iki form\u00fclde de SATIRLAR<\/strong> i\u015flevi i\u00e7in rastgele bir aral\u0131k se\u00e7ti\u011fimizi unutmay\u0131n.<\/span><\/p>\n Ba\u015flang\u0131\u00e7 h\u00fccresi mutlak bir referans ve biti\u015f h\u00fccresi g\u00f6receli bir referans oldu\u011fu s\u00fcrece SATIRLAR<\/strong> i\u00e7in kullan\u0131lacak farkl\u0131 bir h\u00fccre aral\u0131\u011f\u0131 se\u00e7ebilirsiniz.<\/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: h\u00fccreler metin i\u00e7eriyorsa nas\u0131l say\u0131l\u0131r<\/a> Diyelim ki Excel’de farkl\u0131 \u00f6\u011frencilerin s\u0131nav puanlar\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setiniz var ve en iyi 5 puan\u0131 alan \u00f6\u011frencilerin isimleriyle birlikte en iyi 5 puan\u0131 bulmak istiyorsunuz: A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6sterir. \u00d6rnek: Excel’de \u0130lk 5 De\u011feri ve Ad\u0131 Bulun B2:B13 aral\u0131\u011f\u0131ndaki en b\u00fcy\u00fck de\u011feri bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =LARGE( $B$2:$B$13 ,ROWS( $C$2:$C2 […]<\/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-4802","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: Excel’de \u0130lk 5 De\u011feri ve Ad\u0131 Bulun<\/strong><\/span><\/h2>\n
=LARGE( $B$2:$B$13<\/span> ,ROWS( $C$2:$C2<\/span> ))\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tn2.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tn3.png\")
<\/p>\n =INDEX( $A$2:$A$13<\/span> ,MATCH(LARGE( $B$2:$B$13<\/span> ,ROWS( $C$2:$C2<\/span> )), $B$2:$B$13<\/span> ,0))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tn4.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":"