{"id":3177,"date":"2023-07-18T20:18:45","date_gmt":"2023-07-18T20:18:45","guid":{"rendered":"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/"},"modified":"2023-07-18T20:18:45","modified_gmt":"2023-07-18T20:18:45","slug":"nilai-unik-excel-berdasarkan-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/","title":{"rendered":"Excel: cara mengekstrak nilai unik berdasarkan kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut untuk mengekstrak nilai unik berdasarkan kriteria di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE(FILTER( <span style=\"color: #3366ff;\">B2:B14<\/span> , <span style=\"color: #ff0000;\">A2:A14<\/span> =\"West\"))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menemukan nilai unik dalam rentang <strong>B2:B14<\/strong> dengan sel terkait dalam rentang <strong>A2:A14<\/strong> sama dengan &#8220;Barat&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Ekstrak nilai unik berdasarkan kriteria di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26992 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aleatoireunique1-1.jpg\" alt=\"\" width=\"437\" height=\"479\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E1<\/strong> untuk mengekstrak daftar nama tim unik yang kolom Konferensinya sama dengan &#8220;Barat&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE(FILTER( <span style=\"color: #3366ff;\">B2:B14<\/span> , <span style=\"color: #ff0000;\">A2:A14<\/span> =\"West\"))<\/strong><\/pre>\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-26993\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aleatoireunique2-1.jpg\" alt=\"Nilai unik Excel berdasarkan kriteria\" width=\"545\" height=\"445\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita melihat bahwa rumus tersebut mengembalikan nama empat tim unik milik Wilayah Barat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Danau<\/span><\/li>\n<li> <span style=\"color: #000000;\">Mav<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemasyhuran<\/span><\/li>\n<li> <span style=\"color: #000000;\">Roket<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>FILTER<\/strong> Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/sampel-acak-excel\/\">Cara memilih sampel acak di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/beberapa-kriteria-peringkat-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengklasifikasikan item berdasarkan beberapa kriteria di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/seleksi-acak-excel-dengan-kriteria\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sel secara acak berdasarkan kriteria di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus dasar berikut untuk mengekstrak nilai unik berdasarkan kriteria di Excel: =SINGLE(FILTER( B2:B14 , A2:A14 =&#8221;West&#8221;)) Rumus khusus ini menemukan nilai unik dalam rentang B2:B14 dengan sel terkait dalam rentang A2:A14 sama dengan &#8220;Barat&#8221;. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Ekstrak nilai unik berdasarkan kriteria di Excel Katakanlah [&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 mengekstrak nilai unik berdasarkan kriteria - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak nilai unik berdasarkan kriteria di Excel, termasuk contohnya.\" \/>\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\/nilai-unik-excel-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 mengekstrak nilai unik berdasarkan kriteria - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak nilai unik berdasarkan kriteria di Excel, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T20:18:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aleatoireunique1-1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/\",\"name\":\"Excel: Cara mengekstrak nilai unik berdasarkan kriteria - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T20:18:45+00:00\",\"dateModified\":\"2023-07-18T20:18:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak nilai unik berdasarkan kriteria di Excel, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengekstrak nilai unik 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 mengekstrak nilai unik berdasarkan kriteria - Statologi","description":"Tutorial ini menjelaskan cara mengekstrak nilai unik berdasarkan kriteria di Excel, termasuk contohnya.","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\/nilai-unik-excel-berdasarkan-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengekstrak nilai unik berdasarkan kriteria - Statologi","og_description":"Tutorial ini menjelaskan cara mengekstrak nilai unik berdasarkan kriteria di Excel, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-18T20:18:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aleatoireunique1-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/","url":"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/","name":"Excel: Cara mengekstrak nilai unik berdasarkan kriteria - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T20:18:45+00:00","dateModified":"2023-07-18T20:18:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak nilai unik berdasarkan kriteria di Excel, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nilai-unik-excel-berdasarkan-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengekstrak nilai unik 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\/3177"}],"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=3177"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3177\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}