{"id":1713,"date":"2023-11-10T09:08:34","date_gmt":"2023-11-10T09:08:34","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/"},"modified":"2023-12-06T06:19:58","modified_gmt":"2023-12-06T06:19:58","slug":"nomor-yang-paling-sering","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/","title":{"rendered":"Dapatkan nomor yang paling sering muncul dalam sebuah array"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1530528096\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Ada dua fungsi di Excel yang bisa Anda gunakan untuk mendapatkan nomor paling sering dari daftar nomor. Yang pertama adalah MODE dan yang kedua adalah MODE.MULT. Fungsi pertama membantu Anda mendapatkan nomor yang paling sering, dan fungsi kedua membantu Anda mendapatkan lebih dari satu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79886\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\" sizes=\"auto, \" srcset=\"\" alt=\"mendapatkan nomor yang paling sering\" width=\"577\" height=\"418\"><\/figure><\/div><p> Mari kita pelajari kedua rumus tersebut satu per satu.<\/p><h2 class=\"wp-block-heading\"> Rumus untuk mendapatkan angka yang paling sering (MODE)<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama masukkan fungsi MODE di sel.<\/li><li> Setelah itu, masukkan tanda kurung awal.<\/li><li> Kemudian lihat rentang di mana Anda memiliki daftar nomornya.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79887\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-mode-pour-obtenir-le-numero-le-plus-frequent.png\" sizes=\"auto, \" srcset=\"\" alt=\"mode-untuk-mendapatkan-nomor-unik-paling-sering\" width=\"363\" height=\"474\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MODE(A1:A9)<\/code><\/pre><p> MODE adalah fungsi lama tetapi masih tersedia untuk kompatibilitas mundur. Namun ada kekurangan pada fungsi ini. Jika Anda memiliki dua nomor dalam daftar yang muncul sama dalam daftar, MODE tidak akan dapat memberikan Anda kedua nomor tersebut pada hasilnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79888\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-modes-de-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"mode hasil\" width=\"371\" height=\"505\"><\/figure><\/div><p> Pada contoh di atas, Anda mempunyai 30 dan 10; kedua angka muncul empat kali dalam daftar, tetapi MODE mengembalikan hasil 30, bukan 10 atau keduanya 10 dan 30.<\/p><h2 class=\"wp-block-heading\"> Rumus untuk mendapatkan beberapa bilangan frekuensi (MODE.MULT)<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama masukkan fungsi MODE.MULT Excel di sel.<\/li><li> Setelah itu, masukkan tanda kurung awal.<\/li><li> Selanjutnya, lihat rentang sel di mana kamu mempunyai daftar angkanya.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79889\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-obtenir-plusieurs-numeros-frequents.png\" sizes=\"auto, \" srcset=\"\" alt=\"mendapatkan beberapa nomor yang sering\" width=\"377\" height=\"457\"><\/figure><\/div><p> MODE.MULT adalah fungsi array dinamis yang dapat mengembalikan hasil dalam beberapa sel. Itu sebabnya ia mengembalikan hasil 30 dan 10, karena kedua angka tersebut muncul sama rata dalam daftar.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MODE.MULT(A1:A9)<\/code><\/pre><p> Dan jika Anda ingin mendapatkan hasil dalam bentuk horizontal dalam suatu rentang, Anda bisa menggunakan fungsi TRANSPOSE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79890\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-modes-de-transposition-multi-resultats.png\" sizes=\"auto, \" srcset=\"\" alt=\"transpose-mode.mult-hasil\" width=\"606\" height=\"271\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TRANSPOSE(MODE.MULT(A1:A9))<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-le-plus-frequent.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/koefisien-variasi\/\">Hitung koefisien variasi (CV) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/maksimal-jika\/\">MAX JIKA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/laporan\/\">Hitung rasio dengan cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/nilai-terendah\/\">Temukan nilai terendah dari daftar angka (N)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1713","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Dapatkan nomor yang paling sering dari sebuah array<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan angka paling sering dari daftar angka. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dapatkan nomor yang paling sering dari sebuah array\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan angka paling sering dari daftar angka. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/\",\"name\":\"Dapatkan nomor yang paling sering dari sebuah array\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\",\"datePublished\":\"2023-11-10T09:08:34+00:00\",\"dateModified\":\"2023-12-06T06:19:58+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan angka paling sering dari daftar angka. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dapatkan nomor yang paling sering muncul dalam sebuah array\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dapatkan nomor yang paling sering dari sebuah array","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan angka paling sering dari daftar angka. Mari kita periksa ini\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/","og_locale":"id_ID","og_type":"article","og_title":"Dapatkan nomor yang paling sering dari sebuah array","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan angka paling sering dari daftar angka. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/","url":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/","name":"Dapatkan nomor yang paling sering dari sebuah array","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png","datePublished":"2023-11-10T09:08:34+00:00","dateModified":"2023-12-06T06:19:58+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan angka paling sering dari daftar angka. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/nomor-yang-paling-sering\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Dapatkan nomor yang paling sering muncul dalam sebuah array"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1713"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1713\/revisions"}],"predecessor-version":[{"id":2889,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1713\/revisions\/2889"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}