{"id":3397,"date":"2023-07-17T17:12:54","date_gmt":"2023-07-17T17:12:54","guid":{"rendered":"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/"},"modified":"2023-07-17T17:12:54","modified_gmt":"2023-07-17T17:12:54","slug":"kiri-bergabung-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/","title":{"rendered":"Cara melakukan gabung kiri di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Gabungan kiri<\/strong> memungkinkan Anda menggabungkan dua tabel yang setiap baris pada tabel kiri disimpan dan hanya baris yang memiliki nilai yang cocok pada kolom tertentu pada tabel kanan yang disimpan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsi <strong>VLOOKUP<\/strong> untuk melakukan penggabungan kiri di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai untuk setiap tabel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai berikut untuk dua tabel di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28498 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche1.jpg\" alt=\"\" width=\"560\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan melakukan penggabungan kiri di mana kami akan menyimpan semua baris dari tabel kiri dan hanya menggabungkan baris dari tabel kanan yang memiliki nilai yang cocok di kolom <strong>Tim<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat salinan tabel pertama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, salin dan tempel nilai dari tabel pertama ke dalam rentang sel baru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28499 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche2.jpg\" alt=\"\" width=\"600\" height=\"564\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Lakukan gabung kiri menggunakan VLOOKUP<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan mengetikkan rumus berikut di sel C13:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VLOOKUP( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$E$2:$G$9<\/span> , {2,3}, FALSE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28500\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche3.jpg\" alt=\"kiri bergabung di Excel\" width=\"536\" height=\"589\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan juga header kolom <strong>Assists<\/strong> dan <strong>Rebounds<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28501 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche4.jpg\" alt=\"\" width=\"525\" height=\"492\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Gabungan kiri sekarang selesai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setiap baris di tabel kiri disimpan dan hanya baris dengan nama tim yang cocok di tabel kanan yang disimpan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tim tertentu tidak mempunyai permainan pada tabel di sebelah kanan, maka nilai <strong>#N\/A<\/strong> ditampilkan untuk kolom Assist dan Rebound.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Mavs ada pada tabel di sebelah kanan, sehingga mereka memiliki nilai assist dan rebound yang sesuai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Warriors tidak berada di braket kanan, jadi mereka memiliki <strong>#N\/A<\/strong> untuk assist dan rebound.<\/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> <a href=\"https:\/\/statorials.org\/id\/filter-excel-berisi-beberapa-kata\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memfilter sel yang berisi banyak kata<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-excel-beberapa-nilai\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memfilter kolom berdasarkan beberapa nilai<\/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>Gabungan kiri memungkinkan Anda menggabungkan dua tabel yang setiap baris pada tabel kiri disimpan dan hanya baris yang memiliki nilai yang cocok pada kolom tertentu pada tabel kanan yang disimpan. Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsi VLOOKUP untuk melakukan penggabungan kiri di Excel. Langkah 1: Masukkan nilai untuk setiap tabel Mari [&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>Cara Melakukan Gabungan Kiri di Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan gabung kiri di Excel, dengan 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\/kiri-bergabung-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Gabungan Kiri di Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan gabung kiri di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T17:12:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche1.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\/kiri-bergabung-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/\",\"name\":\"Cara Melakukan Gabungan Kiri di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T17:12:54+00:00\",\"dateModified\":\"2023-07-17T17:12:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan gabung kiri di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan gabung kiri 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 Melakukan Gabungan Kiri di Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara melakukan gabung kiri di Excel, dengan 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\/kiri-bergabung-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Gabungan Kiri di Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan gabung kiri di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-17T17:12:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche1.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\/kiri-bergabung-di-excel\/","url":"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/","name":"Cara Melakukan Gabungan Kiri di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T17:12:54+00:00","dateModified":"2023-07-17T17:12:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan gabung kiri di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan gabung kiri 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\/3397"}],"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=3397"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3397\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}