{"id":4659,"date":"2023-07-09T05:14:14","date_gmt":"2023-07-09T05:14:14","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/"},"modified":"2023-07-09T05:14:14","modified_gmt":"2023-07-09T05:14:14","slug":"excel-mengurutkan-berdasarkan-nama-belakang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/","title":{"rendered":"Cara mengurutkan berdasarkan nama belakang di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan proses dua langkah sederhana untuk mengurutkan baris berdasarkan nama belakang di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1:<\/strong> Buat kolom baru yang berisi nama belakang.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2:<\/strong> Gunakan fungsi sortir untuk mengurutkan berdasarkan nama belakang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara mengurutkan baris berdasarkan nama belakang di Excel dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar nama berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36359 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trierdernier1.png\" alt=\"\" width=\"439\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat kolom baru yang berisi nama belakang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mengekstrak nama belakang dari setiap nama lengkap:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=RIGHT(A2,LEN( <span style=\"color: #3366ff;\">A2<\/span> )-FIND(\"*\",SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\" \",\"*\",LEN( <span style=\"color: #3366ff;\">A2<\/span> )-LEN(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\" \",\"\")))))<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel <strong>B2<\/strong> , lalu menyeret dan mengisinya ke sel tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36360 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trierdernier2.png\" alt=\"\" width=\"466\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang berisi nama belakang setiap nama lengkap di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumusnya berfungsi baik nama tersebut mengandung nama tengah atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Rumus ini bekerja dengan mengganti spasi terakhir pada nama dengan tanda bintang (*) lalu menggunakan fungsi <strong>FIND<\/strong> untuk mencari lokasi tanda bintang dan mengekstrak sejumlah karakter dari nama mulai dari kanan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Urutkan berdasarkan nama belakang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat menyorot rentang <strong>A1:B11<\/strong> , lalu klik tab <strong>Data<\/strong> lalu klik ikon <strong>Sortir<\/strong> di grup <strong>Sortir &amp; Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36361 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sort.png\" alt=\"\" width=\"599\" height=\"132\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, pilih kolom berlabel <strong>Nama Belakang<\/strong> dari menu tarik-turun ke <strong>Urutkan berdasarkan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36362 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trierdernier3.png\" alt=\"\" width=\"608\" height=\"278\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , baris akan diurutkan berdasarkan nama belakang dari A hingga Z:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36363 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trierdernier4.png\" alt=\"\" width=\"463\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat menghapus kolom berjudul <strong>Nama Belakang<\/strong> jika Anda sebenarnya tidak ingin membuat kolom terpisah dengan nama belakang setiap orang.<\/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\/menghitung-frekuensi-teks-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung frekuensi teks di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara memeriksa apakah sel berisi teks daftar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-sel-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika sel berisi teks di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan proses dua langkah sederhana untuk mengurutkan baris berdasarkan nama belakang di Excel: Langkah 1: Buat kolom baru yang berisi nama belakang. Langkah 2: Gunakan fungsi sortir untuk mengurutkan berdasarkan nama belakang. Contoh langkah demi langkah berikut menunjukkan cara mengurutkan baris berdasarkan nama belakang di Excel dalam praktiknya. Langkah 1: Masukkan nama Misalkan [&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 Mengurutkan Berdasarkan Nama Belakang di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan berdasarkan nama belakang 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\/excel-mengurutkan-berdasarkan-nama-belakang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengurutkan Berdasarkan Nama Belakang di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan berdasarkan nama belakang di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T05:14:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trierdernier1.png\" \/>\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-mengurutkan-berdasarkan-nama-belakang\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/\",\"name\":\"Cara Mengurutkan Berdasarkan Nama Belakang di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T05:14:14+00:00\",\"dateModified\":\"2023-07-09T05:14:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan berdasarkan nama belakang di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengurutkan berdasarkan nama belakang 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 Mengurutkan Berdasarkan Nama Belakang di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengurutkan berdasarkan nama belakang 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\/excel-mengurutkan-berdasarkan-nama-belakang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengurutkan Berdasarkan Nama Belakang di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengurutkan berdasarkan nama belakang di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/","og_site_name":"Statorials","article_published_time":"2023-07-09T05:14:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trierdernier1.png"}],"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-mengurutkan-berdasarkan-nama-belakang\/","url":"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/","name":"Cara Mengurutkan Berdasarkan Nama Belakang di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T05:14:14+00:00","dateModified":"2023-07-09T05:14:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan berdasarkan nama belakang di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengurutkan-berdasarkan-nama-belakang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengurutkan berdasarkan nama belakang 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\/4659"}],"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=4659"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4659\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}