{"id":2817,"date":"2023-07-20T13:53:04","date_gmt":"2023-07-20T13:53:04","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/"},"modified":"2023-07-20T13:53:04","modified_gmt":"2023-07-20T13:53:04","slug":"excel-10-besar-berdasarkan-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/","title":{"rendered":"Excel: cara mencari 10 nilai teratas berdasarkan kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menemukan 10 nilai teratas di Excel berdasarkan kriteria:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: temukan 10 teratas berdasarkan satu kriteria<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LARGE(IF( <span style=\"color: #3366ff;\">A2:A20<\/span> =\"Value\", <span style=\"color: #ff0000;\">C2:C20<\/span> ,\"\"),ROW( <span style=\"color: #800080;\">A1:A10<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menemukan 10 nilai pertama dalam rentang <strong>C2:C20<\/strong> , dengan nilai dalam rentang <strong>A2:A20<\/strong> sama dengan &#8220;Nilai&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Temukan 10 teratas berdasarkan beberapa kriteria<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LARGE(IF(( <span style=\"color: #3366ff;\">A2:A20<\/span> =\"Value\")*(-- <span style=\"color: #ff0000;\">B2:B20<\/span> &gt;10), <span style=\"color: #800080;\">C2:C20<\/span> ,\"\"),ROW( <span style=\"color: #008000;\">A1:A10<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mencari 10 nilai pertama pada rentang <strong>C2:C20<\/strong> dimana nilai pada rentang <strong>A2:A20<\/strong> sama dengan &#8220;Nilai&#8221; dan nilai pada rentang <strong>B2:B20<\/strong> lebih besar dari 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Temukan 10 nilai teratas berdasarkan satu kriteria<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mencari 10 nilai teratas pada kolom <strong>Poin<\/strong> dimana nilai pada kolom <strong>Tim<\/strong> sama dengan &#8220;Mavs&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LARGE(IF( <span style=\"color: #3366ff;\">A2:A20<\/span> =\"Mavs\", <span style=\"color: #ff0000;\">C2:C20<\/span> ,\"\"),ROW( <span style=\"color: #800080;\">A1:A10<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Pastikan untuk menekan <strong>Ctrl+Shift+Enter<\/strong> setelah mengetik rumus ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24732\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10criteres1.jpg\" alt=\"Excel: 10 Nilai Teratas Berdasarkan Kriteria\" width=\"585\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kolom E menunjukkan 10 nilai pertama pada kolom <strong>Poin<\/strong> dimana kolom <strong>Tim<\/strong> sama dengan \u201cMavs\u201d.<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Temukan 10 nilai teratas berdasarkan beberapa kriteria<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mencari 10 nilai teratas pada kolom <strong>Points<\/strong> dimana nilai pada kolom <strong>Team<\/strong> sama dengan \u201cMavs\u201d dan nilai pada kolom <strong>Rebounds<\/strong> lebih besar dari 6:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LARGE(IF(( <span style=\"color: #3366ff;\">A2:A20<\/span> =\"Mavs\")*(-- <span style=\"color: #ff0000;\">B2:B20<\/span> &gt;6), <span style=\"color: #800080;\">C2:C20<\/span> ,\"\"),ROW( <span style=\"color: #008000;\">A1:A10<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Pastikan untuk menekan <strong>Ctrl+Shift+Enter<\/strong> setelah mengetik rumus ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24733\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10criteres2.jpg\" alt=\"Excel 10 teratas berdasarkan beberapa kriteria\" width=\"672\" height=\"549\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom E menunjukkan 10 nilai teratas pada kolom <strong>Poin<\/strong> dimana kolom <strong>Tim<\/strong> sama dengan \u201cMavs\u201d dan kolom \u201cRebounds\u201d sama dengan lebih besar dari 6.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rangkuman Lima Angka di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean dan Deviasi Standar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menemukan 10 nilai teratas di Excel berdasarkan kriteria: Metode 1: temukan 10 teratas berdasarkan satu kriteria =LARGE(IF( A2:A20 =&#8221;Value&#8221;, C2:C20 ,&#8221;&#8221;),ROW( A1:A10 )) Rumus ini menemukan 10 nilai pertama dalam rentang C2:C20 , dengan nilai dalam rentang A2:A20 sama dengan &#8220;Nilai&#8221;. Metode 2: Temukan 10 teratas berdasarkan beberapa kriteria [&hellip;]<\/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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Cara Mencari 10 Nilai Teratas Berdasarkan Kriteria - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari 10 nilai teratas di Excel berdasarkan kriteria, termasuk beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Mencari 10 Nilai Teratas Berdasarkan Kriteria - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari 10 nilai teratas di Excel berdasarkan kriteria, termasuk beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T13:53:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10criteres1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/\",\"name\":\"Excel: Cara Mencari 10 Nilai Teratas Berdasarkan Kriteria - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T13:53:04+00:00\",\"dateModified\":\"2023-07-20T13:53:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari 10 nilai teratas di Excel berdasarkan kriteria, termasuk beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mencari 10 nilai teratas berdasarkan kriteria\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Cara Mencari 10 Nilai Teratas Berdasarkan Kriteria - Statorials","description":"Tutorial ini menjelaskan cara mencari 10 nilai teratas di Excel berdasarkan kriteria, termasuk beberapa contoh.","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:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Mencari 10 Nilai Teratas Berdasarkan Kriteria - Statorials","og_description":"Tutorial ini menjelaskan cara mencari 10 nilai teratas di Excel berdasarkan kriteria, termasuk beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-20T13:53:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top10criteres1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/","url":"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/","name":"Excel: Cara Mencari 10 Nilai Teratas Berdasarkan Kriteria - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T13:53:04+00:00","dateModified":"2023-07-20T13:53:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari 10 nilai teratas di Excel berdasarkan kriteria, termasuk beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-10-besar-berdasarkan-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mencari 10 nilai teratas berdasarkan kriteria"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2817"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2817"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2817\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}