{"id":3733,"date":"2023-07-15T21:03:02","date_gmt":"2023-07-15T21:03:02","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/"},"modified":"2023-07-15T21:03:02","modified_gmt":"2023-07-15T21:03:02","slug":"filter-excel-berdasarkan-daftar-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/","title":{"rendered":"Cara memfilter berdasarkan daftar nilai di excel"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan sintaks berikut untuk memfilter kumpulan data berdasarkan daftar nilai di Excel:<\/span><\/p>\n

 =<\/span> FILTER<\/span> (<\/span> A2:C11<\/span> ,<\/span> COUNTIF<\/span> (<\/span> E2:E5<\/span> ,<\/span> A2:A11<\/span> )<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini memfilter sel dalam rentang A2:C11<\/strong> untuk hanya mengembalikan baris yang sel dalam rentang A2:A11<\/strong> berisi nilai dari daftar nilai dalam rentang E2:E5<\/strong> .<\/span><\/p>\n
 Contoh langkah demi langkah berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n
 Pertama, masukkan dataset berikut ke dalam Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Langkah 2: Tentukan daftar nilai<\/strong><\/span><\/h2>\n
 Selanjutnya, mari kita tentukan daftar nilai tim yang ingin kita filter:<\/span> <\/p>\n
\"\"<\/p>\n
 Langkah 3: Filter berdasarkan daftar nilai<\/strong><\/span><\/h2>\n
 Selanjutnya, ketikkan rumus berikut ke dalam sel A14<\/strong> untuk memfilter kumpulan data berdasarkan daftar nama tim yang kita tentukan:<\/span><\/p>\n
 =<\/span> FILTER<\/span> (<\/span> A2:C11<\/span> ,<\/span> COUNTIF<\/span> (<\/span> E2:E5<\/span> ,<\/span> A2:A11<\/span> )<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Filter<\/p>\n
 Perhatikan bahwa kumpulan data yang difilter hanya berisi baris-baris yang nama tim kumpulan data aslinya dalam rentang A2:C11<\/strong> ditemukan dalam daftar nama dalam rentang E2:E5<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Fungsi FILTER<\/strong> tidak peka huruf besar-kecil. Artinya jika Anda mengetik “nets” dan bukan “Nets”, fungsi tersebut akan selalu mengembalikan baris dengan “Nets” di kolom Tim.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n
Excel: cara menggunakan karakter wildcard di fungsi FILTER<\/a>
 Excel: cara memfilter sel yang berisi banyak kata<\/a>
 Excel: cara menghitung baris yang difilter<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan sintaks berikut untuk memfilter kumpulan data berdasarkan daftar nilai di Excel: = FILTER ( A2:C11 , COUNTIF ( E2:E5 , A2:A11 ) ) Rumus khusus ini memfilter sel dalam rentang A2:C11 untuk hanya mengembalikan baris yang sel dalam rentang A2:A11 berisi nilai dari daftar nilai dalam rentang E2:E5 . Contoh langkah demi […]<\/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":"\nCara memfilter berdasarkan daftar nilai di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter berdasarkan daftar nilai di Excel, dengan contoh langkah demi langkah.\" \/>\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\/filter-excel-berdasarkan-daftar-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memfilter berdasarkan daftar nilai di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter berdasarkan daftar nilai di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T21:03:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre1.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\/filter-excel-berdasarkan-daftar-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/\",\"name\":\"Cara memfilter berdasarkan daftar nilai di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T21:03:02+00:00\",\"dateModified\":\"2023-07-15T21:03:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter berdasarkan daftar nilai di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memfilter berdasarkan daftar nilai di excel\"}]},{\"@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":"Cara memfilter berdasarkan daftar nilai di Excel - Statologi","description":"Tutorial ini menjelaskan cara memfilter berdasarkan daftar nilai di Excel, dengan contoh langkah demi langkah.","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\/filter-excel-berdasarkan-daftar-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memfilter berdasarkan daftar nilai di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara memfilter berdasarkan daftar nilai di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-15T21:03:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre1.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\/filter-excel-berdasarkan-daftar-nilai\/","url":"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/","name":"Cara memfilter berdasarkan daftar nilai di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T21:03:02+00:00","dateModified":"2023-07-15T21:03:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter berdasarkan daftar nilai di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-daftar-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memfilter berdasarkan daftar nilai di excel"}]},{"@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\/3733"}],"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=3733"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3733\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}