{"id":3507,"date":"2023-07-17T03:11:02","date_gmt":"2023-07-17T03:11:02","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/"},"modified":"2023-07-17T03:11:02","modified_gmt":"2023-07-17T03:11:02","slug":"filter-secara-horizontal-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/","title":{"rendered":"Cara memfilter data secara horizontal di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan sintaks berikut untuk memfilter sel yang disusun secara horizontal di Excel:<\/span><\/p>\n

 =FILTER( B1:G4<\/span> , B2:G<\/span> 2<\/span> = \"value\")\n<\/span><\/strong><\/pre>\n
 Rumus khusus ini akan mengembalikan kolom dalam rentang B1:G4<\/strong> di mana sel dalam rentang B2:G2<\/strong> sama dengan “nilai”.<\/span><\/p>\n
 Contoh berikut memperlihatkan cara menggunakan sintaks ini dengan kumpulan data berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: Filter data secara horizontal berdasarkan string<\/strong><\/span><\/h2>\n
 Kita bisa mengetikkan rumus berikut di sel B8<\/b> untuk memfilter data agar hanya memperlihatkan kolom yang nilainya di baris Konferensi<\/strong> sama dengan “Barat”:<\/span><\/p>\n
 =FILTER( B1:G4<\/span> , B2:G<\/span> 2<\/span> = \"West\")<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"memfilter<\/p>\n
 Perhatikan bahwa hanya kolom yang berisi “Barat” di baris Konferensi<\/strong> yang dikembalikan.<\/span><\/p>\n
 Contoh 2: Filter data secara horizontal berdasarkan nilai numerik<\/strong><\/span><\/h2>\n
 Kita bisa mengetikkan rumus berikut di sel B8<\/b> untuk memfilter data agar hanya menampilkan kolom yang nilainya di baris Poin<\/strong> lebih besar dari 100:<\/span><\/p>\n
 =FILTER( B1:G4<\/span> , B3:G<\/span> 3<\/span> > 100)<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa hanya kolom dengan nilai lebih besar dari 100 pada baris Poin<\/b> yang dikembalikan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: cara menghapus baris dengan teks tertentu<\/a>
Excel: cara memeriksa apakah sel berisi sebagian teks<\/a>
 Excel: cara memeriksa apakah sel berisi teks daftar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan sintaks berikut untuk memfilter sel yang disusun secara horizontal di Excel: =FILTER( B1:G4 , B2:G 2 = “value”) Rumus khusus ini akan mengembalikan kolom dalam rentang B1:G4 di mana sel dalam rentang B2:G2 sama dengan “nilai”. Contoh berikut memperlihatkan cara menggunakan sintaks ini dengan kumpulan data berikut di Excel: Contoh 1: Filter […]<\/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 Data Secara Horizontal di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memfilter data secara horizontal di Excel, antara lain a\" \/>\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-secara-horizontal-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memfilter Data Secara Horizontal di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memfilter data secara horizontal di Excel, antara lain a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T03:11:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hor1.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-secara-horizontal-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/\",\"name\":\"Cara Memfilter Data Secara Horizontal di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T03:11:02+00:00\",\"dateModified\":\"2023-07-17T03:11:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memfilter data secara horizontal di Excel, antara lain a\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memfilter data secara horizontal di excel (dengan contoh)\"}]},{\"@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 Data Secara Horizontal di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara memfilter data secara horizontal di Excel, antara lain a","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-secara-horizontal-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memfilter Data Secara Horizontal di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara memfilter data secara horizontal di Excel, antara lain a","og_url":"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-17T03:11:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hor1.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-secara-horizontal-di-excel\/","url":"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/","name":"Cara Memfilter Data Secara Horizontal di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T03:11:02+00:00","dateModified":"2023-07-17T03:11:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memfilter data secara horizontal di Excel, antara lain a","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-secara-horizontal-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memfilter data secara horizontal di excel (dengan contoh)"}]},{"@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\/3507"}],"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=3507"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3507\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}