{"id":4845,"date":"2023-07-07T07:36:09","date_gmt":"2023-07-07T07:36:09","guid":{"rendered":"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/"},"modified":"2023-07-07T07:36:09","modified_gmt":"2023-07-07T07:36:09","slug":"kolom-filter-excel-berdasarkan-kolom-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/","title":{"rendered":"Excel: cara memfilter kolom berdasarkan kolom lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>Filter Tingkat Lanjut<\/strong> di Excel untuk memfilter nilai di satu kolom berdasarkan nilai di kolom lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: memfilter kolom berdasarkan kolom lain<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37854 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base0.png\" alt=\"\" width=\"517\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita menentukan daftar nama tim tertentu di kolom E dan ingin memfilter baris dalam kumpulan data agar hanya berisi nama tim di kolom A yang termasuk dalam kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37855 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base1-1.png\" alt=\"\" width=\"472\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan filter ini, klik<\/span> tab <strong style=\"color: #000000;\">Data<\/strong> <span style=\"color: #000000;\">, lalu klik<\/span> tombol <strong style=\"color: #000000;\">Filter Lanjutan<\/strong> <span style=\"color: #000000;\">:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37646 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtre-avance.png\" alt=\"\" width=\"646\" height=\"144\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita akan memilih <strong>A1:C11<\/strong> sebagai <strong>rentang daftar<\/strong> dan <strong>E1:E5<\/strong> sebagai <strong>rentang kriteria<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37856\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base2-1.png\" alt=\"Excel memfilter kolom berdasarkan kolom lain\" width=\"554\" height=\"490\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita klik <strong>OK<\/strong> , dataset akan difilter untuk hanya menampilkan baris yang nama tim di kolom A sama dengan salah satu nama tim di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37857 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base3.png\" alt=\"\" width=\"332\" height=\"343\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>filter lanjutan<\/strong> hanya akan berfungsi jika tajuk kolom rentang kriteria cocok dengan tajuk kolom rentang daftar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, <strong>filter lanjutan<\/strong> khusus ini berfungsi karena tajuk kolom untuk rentang kriteria dan rentang daftar keduanya <strong>Team<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/filter-muka-excel-tidak-mengandung\/\" target=\"_blank\" rel=\"noopener\">Filter Tingkat Lanjut Excel: Cara Menggunakan \u201cTidak Berisi\u201d<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-muka-excel-berisi\/\" target=\"_blank\" rel=\"noopener\">Filter lanjutan Excel: cara menggunakan &#8220;Berisi&#8221;<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/muka-filter-excel-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Filter lanjutan Excel: menampilkan baris dengan nilai yang tidak kosong<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi Filter Tingkat Lanjut di Excel untuk memfilter nilai di satu kolom berdasarkan nilai di kolom lain. Contoh berikut menunjukkan cara melakukan hal ini. Contoh: memfilter kolom berdasarkan kolom lain Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket: Katakanlah kita menentukan daftar nama tim tertentu di [&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 memfilter kolom berdasarkan kolom lain - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter kolom di Excel berdasarkan nilai kolom lain, beserta sebuah 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\/kolom-filter-excel-berdasarkan-kolom-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara memfilter kolom berdasarkan kolom lain - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter kolom di Excel berdasarkan nilai kolom lain, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T07:36:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base0.png\" \/>\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\/kolom-filter-excel-berdasarkan-kolom-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/\",\"name\":\"Excel: Cara memfilter kolom berdasarkan kolom lain - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T07:36:09+00:00\",\"dateModified\":\"2023-07-07T07:36:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter kolom di Excel berdasarkan nilai kolom lain, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara memfilter kolom berdasarkan kolom lain\"}]},{\"@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 memfilter kolom berdasarkan kolom lain - Statorial","description":"Tutorial ini menjelaskan cara memfilter kolom di Excel berdasarkan nilai kolom lain, beserta sebuah 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\/kolom-filter-excel-berdasarkan-kolom-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara memfilter kolom berdasarkan kolom lain - Statorial","og_description":"Tutorial ini menjelaskan cara memfilter kolom di Excel berdasarkan nilai kolom lain, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-07T07:36:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/base0.png"}],"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\/kolom-filter-excel-berdasarkan-kolom-lain\/","url":"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/","name":"Excel: Cara memfilter kolom berdasarkan kolom lain - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T07:36:09+00:00","dateModified":"2023-07-07T07:36:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter kolom di Excel berdasarkan nilai kolom lain, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kolom-filter-excel-berdasarkan-kolom-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara memfilter kolom berdasarkan kolom lain"}]},{"@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\/4845"}],"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=4845"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4845\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}