{"id":3386,"date":"2023-07-17T18:34:49","date_gmt":"2023-07-17T18:34:49","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/"},"modified":"2023-07-17T18:34:49","modified_gmt":"2023-07-17T18:34:49","slug":"excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/","title":{"rendered":"Excel: cara mengekstrak data dari sheet lain berdasarkan kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fitur <strong>filter lanjutan<\/strong> Excel untuk mengekstrak data dari satu lembar ke lembar lainnya berdasarkan kriteria.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan data di lembar pertama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut ke dalam lembar pertama buku kerja Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28405 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tirer1.jpg\" alt=\"\" width=\"434\" height=\"524\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tentukan kriterianya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin mengekstrak setiap baris yang berisi &#8220;Mavs&#8221; di kolom Team di <strong>Sheet2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat mendefinisikan kriteria ini di <strong>Sheet2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28406 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tirer2.jpg\" alt=\"\" width=\"480\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Ekstrak data dari lembar pertama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya kita bisa klik pada tab <strong>Data<\/strong> , lalu klik tombol <strong>Advanced Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28407 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tirer0.jpg\" alt=\"\" width=\"593\" height=\"122\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Salin ke lokasi lain<\/strong> lalu isi informasi berikut:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28408\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tirer3.jpg\" alt=\"Excel mengekstrak data dari lembar lain berdasarkan kriteria\" width=\"468\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , baris dari <strong>Sheet1<\/strong> yang kolom Timnya sama dengan &#8220;Mavs&#8221; akan secara otomatis diekstraksi ke <strong>Sheet2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28409 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tirer4.jpg\" alt=\"\" width=\"459\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tiga baris di mana kolom Team sama dengan &#8220;Mavs&#8221; diekstraksi dari <strong>Sheet1<\/strong> ke <strong>Sheet2<\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <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\/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\/muka-filter-excel-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Filter lanjutan Excel: menampilkan baris dengan nilai yang tidak kosong<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fitur filter lanjutan Excel untuk mengekstrak data dari satu lembar ke lembar lainnya berdasarkan kriteria. Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Langkah 1: Masukkan data di lembar pertama Pertama, masukkan kumpulan data berikut ke dalam lembar pertama buku kerja Excel: Langkah 2: Tentukan kriterianya Sekarang 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 data dari sheet lain berdasarkan kriteria - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak data dari sheet lain di Excel berdasarkan kriteria, 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\/excel-mengekstrak-data-dari-lembar-lain-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 data dari sheet lain berdasarkan kriteria - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak data dari sheet lain di Excel berdasarkan kriteria, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T18:34:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tirer1.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\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/\",\"name\":\"Excel: Cara mengekstrak data dari sheet lain berdasarkan kriteria - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T18:34:49+00:00\",\"dateModified\":\"2023-07-17T18:34:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak data dari sheet lain di Excel berdasarkan kriteria, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengekstrak data dari sheet lain 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 data dari sheet lain berdasarkan kriteria - Statorials","description":"Tutorial ini menjelaskan cara mengekstrak data dari sheet lain di Excel berdasarkan kriteria, 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\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengekstrak data dari sheet lain berdasarkan kriteria - Statorials","og_description":"Tutorial ini menjelaskan cara mengekstrak data dari sheet lain di Excel berdasarkan kriteria, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-17T18:34:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tirer1.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\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/","url":"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/","name":"Excel: Cara mengekstrak data dari sheet lain berdasarkan kriteria - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T18:34:49+00:00","dateModified":"2023-07-17T18:34:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak data dari sheet lain di Excel berdasarkan kriteria, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengekstrak-data-dari-lembar-lain-berdasarkan-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengekstrak data dari sheet lain 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\/3386"}],"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=3386"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3386\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}