Y\u00f6ntem 1: E\u011eER SINIFLANDIR<\/strong><\/span><\/p>\n Bu form\u00fcl, B2<\/b> h\u00fccresindeki de\u011ferin B2:B11<\/strong> aral\u0131\u011f\u0131ndaki t\u00fcm de\u011ferler aras\u0131ndaki s\u0131ras\u0131n\u0131 bulur; burada A2:A11<\/strong> aral\u0131\u011f\u0131ndaki kar\u015f\u0131l\u0131k gelen de\u011fer, A2<\/strong> h\u00fccresindeki de\u011fere e\u015fittir.<\/span><\/p>\n Bu y\u00f6ntem kullan\u0131larak en b\u00fcy\u00fck de\u011fere 1 de\u011feri verilir.<\/strong><\/span><\/p>\n Y\u00f6ntem 2: IF RANK’\u0131 tersine \u00e7evirin<\/strong><\/span><\/p>\n Bu form\u00fcl, B2<\/b> h\u00fccresindeki de\u011ferin B2:B11<\/strong> aral\u0131\u011f\u0131ndaki t\u00fcm de\u011ferler aras\u0131ndaki s\u0131ras\u0131n\u0131 bulur; burada A2:A11<\/strong> aral\u0131\u011f\u0131ndaki kar\u015f\u0131l\u0131k gelen de\u011fer, A2<\/strong> h\u00fccresindeki de\u011fere e\u015fittir.<\/span><\/p>\n Bu y\u00f6ntem kullan\u0131larak en k\u00fc\u00e7\u00fck de\u011fere 1 de\u011feri verilir.<\/strong><\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, her y\u00f6ntemin Excel’deki a\u015fa\u011f\u0131daki veri k\u00fcmesiyle nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n B2<\/strong> h\u00fccresindeki puan de\u011ferinin “Mavs” tak\u0131m\u0131ndaki t\u00fcm oyuncular aras\u0131ndaki s\u0131ralamas\u0131n\u0131 hesaplamak i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Sonucun nas\u0131l yorumlanaca\u011f\u0131 a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span><\/p>\n Ve benzeri.<\/span><\/p>\n Bu form\u00fcl\u00fc kullanarak her tak\u0131mda en y\u00fcksek puan de\u011ferine sahip oyuncu 1. s\u0131ray\u0131 al\u0131r.<\/span><\/p>\n B2<\/strong> h\u00fccresindeki puan de\u011ferinin “Mavs” tak\u0131m\u0131ndaki t\u00fcm oyuncular aras\u0131ndaki s\u0131ralamas\u0131n\u0131 hesaplamak i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Sonucun nas\u0131l yorumlanaca\u011f\u0131 a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span><\/p>\n Ve benzeri.<\/span><\/p>\n Bu form\u00fcl\u00fc kullanarak her tak\u0131mda en d\u00fc\u015f\u00fck puan de\u011ferine sahip oyuncu 1. s\u0131ray\u0131 al\u0131r.<\/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 RANK IF form\u00fcl\u00fc olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz: Y\u00f6ntem 1: E\u011eER SINIFLANDIR =COUNTIFS( $A$2:$A$11 , A2 , $B$2:$B$1 1 ,”>”& B2 )+1 Bu form\u00fcl, B2 h\u00fccresindeki de\u011ferin B2:B11 aral\u0131\u011f\u0131ndaki t\u00fcm de\u011ferler aras\u0131ndaki s\u0131ras\u0131n\u0131 bulur; burada A2:A11 aral\u0131\u011f\u0131ndaki kar\u015f\u0131l\u0131k gelen de\u011fer, A2 h\u00fccresindeki de\u011fere e\u015fittir. Bu y\u00f6ntem kullan\u0131larak en b\u00fcy\u00fck de\u011fere 1 de\u011feri verilir. Y\u00f6ntem […]<\/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-3357","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =COUNTIFS( $A$2:$A$11<\/span> , A2<\/span> , $B$2:$B$1<\/span> 1<\/span> ,\">\"& B2<\/span> )+1\n<\/span><\/strong><\/pre>\n =COUNTIFS( $A$2:$A$11<\/span> , A2<\/span> , $B$2:$B$1<\/span> 1<\/span> ,\"<\"& B2<\/span> )+1\n<\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classementif1.jpg\")
<\/p>\n \u00d6rnek 1: SIRALAMA IF<\/strong><\/span><\/h2>\n
=COUNTIFS( $A$2:$A$11<\/span> , A2<\/span> , $B$2:$B$1<\/span> 1<\/span> ,\">\"& B2<\/span> )+1<\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classementif2.jpg\")
<\/p>\n\n
\u00d6rnek 2: IF RANK’\u0131 tersine \u00e7evirme<\/strong><\/span><\/h2>\n
=COUNTIFS( $A$2:$A$11<\/span> , A2<\/span> , $B$2:$B$1<\/span> 1<\/span> ,\"<\"& B2<\/span> )+1<\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classementif3.jpg\")
<\/p>\n\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><\/p>\n","protected":false},"excerpt":{"rendered":"