{"id":3284,"date":"2020-04-21T15:20:49","date_gmt":"2020-04-21T08:20:49","guid":{"rendered":"https:\/\/www.puskomedia.id\/bantuan\/?post_type=kb&p=3284"},"modified":"2020-04-21T15:20:49","modified_gmt":"2020-04-21T08:20:49","slug":"cara-mengecek-nik-ganda-sebelum-impor-penduduk","status":"publish","type":"kb","link":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/","title":{"rendered":"Cara Mengecek NIK Ganda Sebelum Impor Penduduk"},"content":{"rendered":"

Cara Menemukan Data Ganda (Duplikat) <\/b><\/strong>pada Data Exel Penduduk<\/b><\/strong><\/h3>\n

Dalam pendataan penduduk sering ditemui beberapa permasalahan, salah satunya data ganda (duplikat). Panda\u00a0 sebagai salah satu aplikasi yang juga memuat data penduduk, tidak bisa menginput apabila data tersebut ada kesamaan (data duplikat). Oleh karena itu sebelum menginput data, para pengguna Panda\u00a0 bisa untuk memastikan bahwa data yang disiapkan sudah benar dan tidak ada data yang sama.<\/p>\n

Untuk melakukan pengecekan bisa menggunakan\u00a0fitur conditional formatting. Conditional Formatting <\/b><\/strong>adalah\u00a0salah satu fitur excel yang dapat digunakan untuk menemukan data ganda di excel atau data yang sama.<\/p>\n

Untuk mencari data ganda atau duplikat serta untuk mengetahui data double di excel, bisa\u00a0melakukan tutorial\u00a0dibawah ini :<\/p>\n

    \n
  1. Pilih rentang data yang kita ingin cari data duplikatnya, lalu di blok. Contoh Blok data NIK (lihat kotak merah)<\/li>\n<\/ol>\n

     <\/p>\n

    \"\"<\/p>\n

    2. Pilih menu: Home<\/b><\/strong>—Conditional Formatting<\/b><\/strong>—Highlights Cells Rules (lihat kotak merah)<\/b><\/strong><\/p>\n

    \"\"3. Lalu pilih duplikat value lalu OK<\/p>\n

    \"\"<\/p>\n

    4. Akan tampil sebagai berikut, yang berwarna merah adalah data yang sama (duplikat)<\/p>\n

    \"\"<\/p>\n

    Selamat mencoba!<\/p>\n","protected":false},"excerpt":{"rendered":"

    Cara Menemukan Data Ganda (Duplikat) pada Data Exel Penduduk Dalam pendataan penduduk sering ditemui beberapa permasalahan, salah satunya data ganda (duplikat). Panda\u00a0 sebagai salah satu aplikasi yang juga memuat data penduduk, tidak bisa menginput apabila data tersebut ada kesamaan (data duplikat). Oleh karena itu sebelum menginput data, para pengguna Panda\u00a0 bisa untuk memastikan bahwa data […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"kbtopic":[90],"kbtag":[115,116,113,109,117,114,77,108,100],"class_list":["post-3284","kb","type-kb","status-publish","hentry","kbtopic-kependudukan","kbtag-data","kbtag-data-penduduk","kbtag-exel","kbtag-impor-data","kbtag-nik","kbtag-panda","kbtag-panda-sid","kbtag-penduduk","kbtag-tutorial"],"yoast_head":"\nCara Mengecek NIK Ganda Sebelum Impor Penduduk - PuskoMedia Indonesia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengecek NIK Ganda Sebelum Impor Penduduk - PuskoMedia Indonesia\" \/>\n<meta property=\"og:description\" content=\"Cara Menemukan Data Ganda (Duplikat) pada Data Exel Penduduk Dalam pendataan penduduk sering ditemui beberapa permasalahan, salah satunya data ganda (duplikat). Panda\u00a0 sebagai salah satu aplikasi yang juga memuat data penduduk, tidak bisa menginput apabila data tersebut ada kesamaan (data duplikat). Oleh karena itu sebelum menginput data, para pengguna Panda\u00a0 bisa untuk memastikan bahwa data […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/\" \/>\n<meta property=\"og:site_name\" content=\"PuskoMedia Indonesia\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/04\/ini-dulu.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/\",\"url\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/\",\"name\":\"Cara Mengecek NIK Ganda Sebelum Impor Penduduk - PuskoMedia Indonesia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/ini-dulu.png\",\"datePublished\":\"2020-04-21T08:20:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/ini-dulu.png\",\"contentUrl\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/ini-dulu.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Mengecek NIK Ganda Sebelum Impor Penduduk\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/#website\",\"url\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/\",\"name\":\"PuskoMedia Indonesia\",\"description\":\"Mendunia Makin Mudah\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Mengecek NIK Ganda Sebelum Impor Penduduk - PuskoMedia Indonesia","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:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengecek NIK Ganda Sebelum Impor Penduduk - PuskoMedia Indonesia","og_description":"Cara Menemukan Data Ganda (Duplikat) pada Data Exel Penduduk Dalam pendataan penduduk sering ditemui beberapa permasalahan, salah satunya data ganda (duplikat). Panda\u00a0 sebagai salah satu aplikasi yang juga memuat data penduduk, tidak bisa menginput apabila data tersebut ada kesamaan (data duplikat). Oleh karena itu sebelum menginput data, para pengguna Panda\u00a0 bisa untuk memastikan bahwa data […]","og_url":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/","og_site_name":"PuskoMedia Indonesia","og_image":[{"url":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/04\/ini-dulu.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/","url":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/","name":"Cara Mengecek NIK Ganda Sebelum Impor Penduduk - PuskoMedia Indonesia","isPartOf":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/#primaryimage"},"image":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/04\/ini-dulu.png","datePublished":"2020-04-21T08:20:49+00:00","breadcrumb":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/#primaryimage","url":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/04\/ini-dulu.png","contentUrl":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/04\/ini-dulu.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-mengecek-nik-ganda-sebelum-impor-penduduk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.puskomedia.id\/bantuan\/"},{"@type":"ListItem","position":2,"name":"Cara Mengecek NIK Ganda Sebelum Impor Penduduk"}]},{"@type":"WebSite","@id":"https:\/\/www.puskomedia.id\/bantuan\/#website","url":"https:\/\/www.puskomedia.id\/bantuan\/","name":"PuskoMedia Indonesia","description":"Mendunia Makin Mudah","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.puskomedia.id\/bantuan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"}]}},"_links":{"self":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb\/3284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/comments?post=3284"}],"version-history":[{"count":2,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb\/3284\/revisions"}],"predecessor-version":[{"id":3319,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb\/3284\/revisions\/3319"}],"wp:attachment":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/media?parent=3284"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kbtopic?post=3284"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kbtag?post=3284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}