{"id":4925,"date":"2023-07-06T08:27:24","date_gmt":"2023-07-06T08:27:24","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/"},"modified":"2023-07-06T08:27:24","modified_gmt":"2023-07-06T08:27:24","slug":"google-sheet-urutkan-berdasarkan-nama-belakang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/","title":{"rendered":"Cara mengurutkan berdasarkan nama belakang di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mengurutkan nama dalam kolom di Google Spreadsheet berdasarkan nama belakang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar nama berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38447 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier1.png\" alt=\"\" width=\"478\" height=\"417\" 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: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=TRIM(RIGHT(SUBSTITUTE( <span style=\"color: #ff6600;\">A2<\/span> ,\" \",REPT(\" \",LEN( <span style=\"color: #ff6600;\">A2<\/span> ))),LEN( <span style=\"color: #ff6600;\">A2<\/span> )))\n<\/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-38448 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier2.png\" alt=\"\" width=\"631\" height=\"396\" 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<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Urutkan berdasarkan nama belakang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, kita bisa menyorot range <strong>B2:A11<\/strong> , lalu klik tab <strong>Data<\/strong> lalu klik <strong>Sort Range<\/strong> lalu klik <strong>Sort Range by Column B (A to Z)<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38449 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier3.png\" alt=\"\" width=\"674\" height=\"371\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis-garis tersebut akan diurutkan berdasarkan nama belakang dari A sampai Z:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38450 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier4.png\" alt=\"\" width=\"519\" height=\"433\" 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 Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/pengurutan-lembar-google-mengabaikan-yang-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara mengurutkan dan mengabaikan spasi kosong<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-keluaran-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara mengurutkan tabel pivot<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara mengurutkan berdasarkan tanggal<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mengurutkan nama dalam kolom di Google Spreadsheet berdasarkan nama belakang. Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya. Langkah 1: Masukkan nama Katakanlah kita memiliki daftar nama berikut di Google Spreadsheet: Langkah 2: Buat kolom baru yang berisi nama belakang Kita bisa menggunakan rumus berikut [&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 Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan baris berdasarkan nama belakang di Google Sheets, dengan contoh lengkap.\" \/>\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\/google-sheet-urutkan-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 Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan baris berdasarkan nama belakang di Google Sheets, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T08:27:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier1.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\/google-sheet-urutkan-berdasarkan-nama-belakang\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/\",\"name\":\"Cara mengurutkan berdasarkan nama belakang di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T08:27:24+00:00\",\"dateModified\":\"2023-07-06T08:27:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan baris berdasarkan nama belakang di Google Sheets, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-urutkan-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 google sheets\"}]},{\"@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 Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara mengurutkan baris berdasarkan nama belakang di Google Sheets, dengan contoh lengkap.","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\/google-sheet-urutkan-berdasarkan-nama-belakang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengurutkan berdasarkan nama belakang di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mengurutkan baris berdasarkan nama belakang di Google Sheets, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/","og_site_name":"Statorials","article_published_time":"2023-07-06T08:27:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier1.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\/google-sheet-urutkan-berdasarkan-nama-belakang\/","url":"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/","name":"Cara mengurutkan berdasarkan nama belakang di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T08:27:24+00:00","dateModified":"2023-07-06T08:27:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan baris berdasarkan nama belakang di Google Sheets, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-urutkan-berdasarkan-nama-belakang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-urutkan-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 google sheets"}]},{"@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\/4925"}],"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=4925"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4925\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}