Y\u00f6ntem 1: En y\u00fcksek s\u0131ralamay\u0131 e\u015fit de\u011ferlere atay\u0131n<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl, B2:B11<\/strong> aral\u0131\u011f\u0131ndaki e\u015fit de\u011ferlere ayn\u0131 dereceyi atayacakt\u0131r.<\/span><\/p>\n \u00d6rne\u011fin, listedeki en y\u00fcksek de\u011fer i\u00e7in iki de\u011ferin her ikisi de e\u015fitse, her iki de\u011fer de 1.<\/strong> s\u0131ray\u0131 alacakt\u0131r.<\/span><\/p>\n Y\u00f6ntem 2: E\u015fit De\u011ferlere Ortalama S\u0131ra Atama<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl, ortalama s\u0131ralamay\u0131 B2:B11<\/strong> aral\u0131\u011f\u0131ndaki e\u015fit de\u011ferlere atayacakt\u0131r.<\/span><\/p>\n \u00d6rne\u011fin, listedeki en y\u00fcksek de\u011fer i\u00e7in iki de\u011ferin her ikisi de e\u015fitse, s\u0131ralamalar\u0131n\u0131n ortalamas\u0131 \u015fu \u015fekilde olaca\u011f\u0131ndan her iki de\u011fer de 1,5’lik<\/strong> bir s\u0131ralama alacakt\u0131r: (1 + 2) \/2 = 1,5<\/strong> .<\/span><\/p>\n Y\u00f6ntem 3: En y\u00fcksek s\u0131ralamay\u0131 ilk \u00f6nce g\u00f6r\u00fcnen de\u011fere atay\u0131n<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl , B2:B11<\/strong> aral\u0131\u011f\u0131nda iki e\u015fit de\u011fer aras\u0131nda ilk \u00f6nce g\u00f6r\u00fcnen de\u011fere en y\u00fcksek s\u0131ray\u0131 atayacakt\u0131r.<\/span><\/p>\n \u00d6rne\u011fin, listedeki en y\u00fcksek de\u011fer i\u00e7in iki de\u011ferin her ikisi de e\u015fitse, ilk olarak g\u00f6r\u00fcnen de\u011fer 1.<\/strong> s\u0131ray\u0131, ikinci olarak g\u00f6r\u00fcnen de\u011fer ise 2<\/strong> de\u011ferini alacakt\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu y\u00f6ntemlerin her birinin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n Diyelim ki Excel’de bir s\u0131n\u0131ftaki \u00e7e\u015fitli \u00f6\u011frencilerin ald\u0131\u011f\u0131 s\u0131nav puanlar\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahibiz:<\/span> <\/p>\n Her \u00f6\u011frencinin s\u0131nav puanlar\u0131n\u0131 s\u0131ralamak istedi\u011fimizi varsayal\u0131m; en y\u00fcksek puana 1, en d\u00fc\u015f\u00fck puana 10 de\u011feri atad\u0131k.<\/span><\/p>\n Farkl\u0131 s\u0131ralama y\u00f6ntemlerini uygulamak i\u00e7in C2<\/strong> , D2<\/strong> ve E2<\/strong> h\u00fccrelerine a\u015fa\u011f\u0131daki form\u00fclleri yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fclleri t\u0131klay\u0131p her s\u00fctunda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n En y\u00fcksek puan i\u00e7in e\u015fit olan iki de\u011fer oldu\u011funu unutmay\u0131n: Doug ve Eric’in her ikisi de 95 puan ald\u0131.<\/span><\/p>\n Her bir s\u0131ralama y\u00f6nteminin bu ba\u011f\u0131 nas\u0131l ele ald\u0131\u011f\u0131 a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span><\/p>\n Y\u00f6ntem 1: SIRALAMA<\/strong><\/span><\/p>\n Bu y\u00f6ntem basit\u00e7e bu iki en y\u00fcksek de\u011fere 1’lik<\/strong> bir derece atad\u0131.<\/span><\/p>\n Y\u00f6ntem 2: RANK.AVG<\/strong><\/span><\/p>\n Bu y\u00f6ntem, bu en y\u00fcksek iki de\u011fere, bu de\u011ferlerin her birinin kendi bireysel s\u0131ralamas\u0131n\u0131 almas\u0131 durumunda ortalama s\u0131ralama olan 1,5’lik<\/strong> bir s\u0131ralama atad\u0131.<\/span><\/p>\n \u00d6rne\u011fin Doug 1<\/strong> , Eric ise 2<\/strong> puan ald\u0131ysa bu ikisi aras\u0131ndaki ortalama 1,5<\/strong> olacakt\u0131r.<\/span><\/p>\n Y\u00f6ntem 3: RANK + COUNTIF<\/strong><\/span><\/p>\n Bu y\u00f6ntemde ortaya \u00e7\u0131kan ilk en y\u00fcksek de\u011fere 1<\/strong> , daha sonra olu\u015fan en y\u00fcksek de\u011fere ise 2<\/strong> puan\u0131 verilmi\u015ftir.<\/span><\/p>\n Doug veri k\u00fcmesinde ilk s\u0131rada yer ald\u0131\u011f\u0131ndan, 1.<\/strong> s\u0131ray\u0131 ald\u0131 ve ard\u0131ndan Eric 2.<\/strong> s\u0131ray\u0131 ald\u0131.<\/span><\/p>\n Kendi veri k\u00fcmenizdeki de\u011ferleri s\u0131n\u0131fland\u0131r\u0131rken tercih etti\u011finiz y\u00f6ntemi se\u00e7mekten \u00e7ekinmeyin.<\/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’de Y\u00fczdelik S\u0131ralama Nas\u0131l Hesaplan\u0131r?<\/a> Excel’de bir de\u011ferler listesini s\u0131ralarken ba\u011flar\u0131 ele alman\u0131n \u00fc\u00e7 yolu vard\u0131r: Y\u00f6ntem 1: En y\u00fcksek s\u0131ralamay\u0131 e\u015fit de\u011ferlere atay\u0131n =RANK( B2 , $B$2:$B$11 ) Bu \u00f6zel form\u00fcl, B2:B11 aral\u0131\u011f\u0131ndaki e\u015fit de\u011ferlere ayn\u0131 dereceyi atayacakt\u0131r. \u00d6rne\u011fin, listedeki en y\u00fcksek de\u011fer i\u00e7in iki de\u011ferin her ikisi de e\u015fitse, her iki de\u011fer de 1. s\u0131ray\u0131 alacakt\u0131r. Y\u00f6ntem 2: […]<\/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-4843","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =RANK( B2<\/span> , $B$2:$B$11<\/span> )\n<\/span><\/strong><\/pre>\n =RANK.AVG( B2<\/span> , $B$2:$B$11<\/span> ) \n<\/span><\/strong><\/pre>\n =RANK( B2<\/span> , $B$2:$B$11<\/span> )+COUNTIF( B$2:B2<\/span> , B2<\/span> )-1\n<\/span><\/strong><\/pre>\n \u00d6rnek: Excel’deki ba\u011flant\u0131larla de\u011ferler nas\u0131l s\u0131ralan\u0131r<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rang1.png\")
<\/p>\n\n
![\"Ba\u011flarla](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rang-egalite2.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
De\u011ferler Excel’de gruba g\u00f6re nas\u0131l s\u0131ralan\u0131r<\/a>
\u00d6\u011feleri Excel’de birden \u00e7ok \u00f6l\u00e7\u00fcte g\u00f6re s\u0131n\u0131fland\u0131rma<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"