{"id":1800,"date":"2023-11-04T02:35:45","date_gmt":"2023-11-04T02:35:45","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/"},"modified":"2023-12-06T06:13:30","modified_gmt":"2023-12-06T06:13:30","slug":"penyaring-horisontal","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/","title":{"rendered":"Bagaimana cara membuat filter horizontal di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3673223066\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk menggunakan filter secara horizontal di Excel, Anda harus menggunakan fungsi FILTER yang memungkinkan Anda memfilter tabel berdasarkan kriteria yang Anda tentukan dalam fungsi tersebut. Anda dapat menentukan tabel, lalu menggunakan nama baris, menentukan kriteria yang akan difilter.<\/p><p> Dalam contoh berikut, Anda memiliki kumpulan data kecil yang berisi nama dan usia dalam bentuk horizontal (header berada dalam baris). Sekarang kita perlu memfilter data berdasarkan usia bila usianya sudah di atas 45 tahun. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69883\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png\" sizes=\"auto, \" srcset=\"\" alt=\"data dalam bentuk horizontal\" width=\"740\" height=\"390\"><\/figure><\/div><p> Disini kami memiliki total nama dan umur 40 orang, artinya rentang yang kami miliki dengan nama dan umur adalah A1:AO2. Di mana sel A1 dan B1 adalah headernya.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Menerapkan Filter Horizontal di Excel<\/h2><ol type=\"1\"><li> Di sel D2, mulailah menambahkan fungsi filter.<\/li><li> Dari sini, dalam argumen pertama, lihat rentang B2:AO2 di mana kita memiliki data aktual yang perlu kita filter.<\/li><li> Sekarang di argumen kedua mengacu pada kisaran di mana kita memiliki nilai usia.<\/li><li> Selanjutnya, masukkan lebih besar dari dan sama dengan operator.<\/li><li> Setelah itu masukkan angka 45 yang ingin kita jadikan kriteria.<\/li><li> Dalam argumen ketiga Anda dapat menggunakan tentukan nilai yang akan digunakan untuk sel yang tidak memiliki nilai.<\/li><li> Terakhir, masukkan tanda kurung tutup dan tekan Enter untuk mendapatkan data yang difilter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69884\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-appliquer-le-filtre-horizontal.png\" sizes=\"auto, \" srcset=\"\" alt=\"terapkan-filter-horizontal\" width=\"734\" height=\"407\"><\/figure><\/div><p> Seperti yang Anda lihat, kami memiliki data yang difilter dari data asli yang kami miliki dalam bentuk horizontal.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=FILTER(B1:AO2,B2:AO2&gt;=45)<\/code><\/pre><h2 class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Sebelum kita mencoba memahami rumus ini, perlu kita ketahui bahwa FILTER adalah fungsi DINAMIS yang memungkinkan Anda bekerja dengan beberapa nilai secara bersamaan dalam satu rumus dan kemudian mengembalikan nilai dalam beberapa sel.<\/p><p> Sekarang mari kita pisahkan fungsi ini menjadi dua bagian untuk memahaminya: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69885\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comment-fonctionne-le-filtre-horizontal.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara kerja-filter-horizontal\" width=\"713\" height=\"376\"><\/figure><\/div><p> Pada bagian pertama kita mengacu pada keseluruhan rentang dimana kita memiliki nama dan umur, yaitu B1:AO2. Saat Anda merujuknya, ia memberitahu Excel untuk mengambil dua tabel berbeda karena kita memiliki baris A dan B.<\/p><p> Sekarang di bagian kedua kita hanya mengacu pada kolom usia dan dengan itu kita telah menentukan kondisi untuk pengujian yang sama dengan dan lebih besar dari 45.<\/p><p> Sekarang semua keajaiban fungsi ini ada di bagian ini. Saat menentukan kondisi untuk difilter, ini menguji setiap nilai di kolom usia. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69886\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-tests-de-filtre-horizontaux-pour-chaque-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"filter-horizontal-menguji-setiap-nilai\" width=\"771\" height=\"303\"><\/figure><\/div><p> Saat pengujian, hanya ditemukan tiga nilai yang lebih besar atau sama dengan 45 pada kolom usia. Dan ini memberitahu fungsi FILTER bahwa ada tiga nilai yang perlu kita filter.<\/p><p> Seperti yang saya katakan, ini adalah fungsi dinamis saat memilih salah satu sel dari kumpulan data terfilter yang disorot. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69887\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-filtres-dynamiques-horizontaux.png\" sizes=\"auto, \" srcset=\"\" alt=\"filter dinamis horizontal\" width=\"667\" height=\"280\"><\/figure><\/div><p> Anda juga dapat melangkah lebih jauh dan mengubah urutan data serta memfilter data horizontal dan mengubah urutannya menjadi data vertikal menggunakan fungsi transpos. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69888\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-donnees-de-filtrage-et-de-transponse.png\" sizes=\"auto, \" srcset=\"\" alt=\"filter-dan-transpon-data\" width=\"641\" height=\"442\"><\/figure><\/div><p> Anda hanya perlu menggabungkan fungsi filter dalam fungsi transpose. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/filtre-horizontal-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\">Buat templat peringkat bintang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-file\/\">Dapatkan nama file di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-lembar\/\">Dapatkan nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/\">Hasilkan huruf acak dengan cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\">Acak daftar (pengurutan acak) di Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1800","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara membuat filter horizontal di Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini kita akan mempelajari cara membuat rumus yang dapat membantu Anda menerapkan filter horizontal, kami akan menggunakan\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membuat filter horizontal di Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini kita akan mempelajari cara membuat rumus yang dapat membantu Anda menerapkan filter horizontal, kami akan menggunakan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/\",\"name\":\"Bagaimana cara membuat filter horizontal di Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png\",\"datePublished\":\"2023-11-04T02:35:45+00:00\",\"dateModified\":\"2023-12-06T06:13:30+00:00\",\"description\":\"Dalam tutorial ini kita akan mempelajari cara membuat rumus yang dapat membantu Anda menerapkan filter horizontal, kami akan menggunakan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat filter horizontal di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara membuat filter horizontal di Excel? - Penasihat Excel","description":"Dalam tutorial ini kita akan mempelajari cara membuat rumus yang dapat membantu Anda menerapkan filter horizontal, kami akan menggunakan","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:\/\/exceladvisor.org\/id\/penyaring-horisontal\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membuat filter horizontal di Excel? - Penasihat Excel","og_description":"Dalam tutorial ini kita akan mempelajari cara membuat rumus yang dapat membantu Anda menerapkan filter horizontal, kami akan menggunakan","og_url":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/","url":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/","name":"Bagaimana cara membuat filter horizontal di Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png","datePublished":"2023-11-04T02:35:45+00:00","dateModified":"2023-12-06T06:13:30+00:00","description":"Dalam tutorial ini kita akan mempelajari cara membuat rumus yang dapat membantu Anda menerapkan filter horizontal, kami akan menggunakan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-sous-forme-horizontale.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat filter horizontal di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1800"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1800\/revisions"}],"predecessor-version":[{"id":2292,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1800\/revisions\/2292"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}