{"id":4892,"date":"2023-07-06T19:00:19","date_gmt":"2023-07-06T19:00:19","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-en-sik-kullanilan-5-sayiyi-bulma\/"},"modified":"2023-07-06T19:00:19","modified_gmt":"2023-07-06T19:00:19","slug":"excel-en-sik-kullanilan-5-sayiyi-bulma","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-en-sik-kullanilan-5-sayiyi-bulma\/","title":{"rendered":"Excel: en s\u0131k kullan\u0131lan 5 say\u0131 nas\u0131l bulunur?"},"content":{"rendered":"

<\/p>\n

\n

Excel’deki bir listede en s\u0131k kullan\u0131lan 5 say\u0131y\u0131 bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =MODE(IF(ISERROR(MATCH( $A$2:$A$24<\/span> , C$1:C1<\/span> ,0)), $A$2:$A$24<\/span> ))<\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl A2:A24<\/strong> aral\u0131\u011f\u0131nda en s\u0131k g\u00f6r\u00fclen de\u011feri bulacakt\u0131r.<\/span><\/p>\n
 Daha sonra A2:A24<\/strong> aral\u0131\u011f\u0131nda en s\u0131k kullan\u0131lan 5 say\u0131y\u0131 bulmak i\u00e7in bu form\u00fcl\u00fc t\u0131klay\u0131p d\u00f6rt ek h\u00fccreye s\u00fcr\u00fckleyebilirsiniz.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n
 \u00d6rnek: Excel’de en s\u0131k kullan\u0131lan 5 say\u0131y\u0131 bulun<\/strong><\/span><\/h2>\n
 Excel’de a\u015fa\u011f\u0131daki say\u0131 listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 Bu listede en s\u0131k kullan\u0131lan 5 say\u0131y\u0131 bulmak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n
 Bunu yapmak i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n
 =MODE(IF(ISERROR(MATCH( $A$2:$A$24<\/span> , C$1:C1<\/span> ,0)), $A$2:$A$24<\/span> ))<\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p C s\u00fctunundaki di\u011fer d\u00f6rt h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n
\"Excel<\/p>\n
 C s\u00fctunu art\u0131k A s\u00fctunundaki en s\u0131k g\u00f6r\u00fclen be\u015f say\u0131y\u0131 g\u00f6r\u00fcnt\u00fcl\u00fcyor.<\/span><\/span><\/p>\n
 Her say\u0131n\u0131n s\u0131kl\u0131\u011f\u0131n\u0131 bulmak i\u00e7in D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n
 =COUNTIF( $A$2:$A$24<\/span> , C2<\/span> )<\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p D s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n
\"\"<\/p>\n
 Sonu\u00e7tan \u015funlar\u0131 g\u00f6rebiliriz:<\/span><\/p>\n