{"id":4734,"date":"2023-07-08T11:50:18","date_gmt":"2023-07-08T11:50:18","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/"},"modified":"2023-07-08T11:50:18","modified_gmt":"2023-07-08T11:50:18","slug":"excel-membalikkan-urutan-baris","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/","title":{"rendered":"Cara membalik urutan baris di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut di Excel untuk membalikkan urutan baris dengan cepat:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SORTBY( <span style=\"color: #3366ff;\">$A$2:$C$11<\/span> ,ROW( <span style=\"color: #ff0000;\">A2:A11<\/span> ),-1)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan membalikkan urutan garis dalam rentang <strong>A2:C11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara membalikkan urutan baris di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36966 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revo1.png\" alt=\"\" width=\"522\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membalikkan urutan baris dalam rentang <strong>A2:C11<\/strong> , misalnya menampilkan baris dengan Mavs sebagai baris terakhir dan baris dengan Jazz sebagai baris pertama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SORTBY( <span style=\"color: #3366ff;\">$A$2:$C$11<\/span> ,ROW( <span style=\"color: #ff0000;\">A2:A11<\/span> ),-1)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36967\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revo2.png\" alt=\"Urutan baris terbalik Excel\" width=\"561\" height=\"384\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa rumusnya membalikkan urutan garis.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Baris pertama kini menjadi baris terakhir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Baris kedua kini menjadi baris kedua dari belakang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Bagaimana cara kerja rumus ini?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Ingat rumus yang kami gunakan untuk membalik urutan baris:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SORTBY( <span style=\"color: #3366ff;\">$A$2:$C$11<\/span> ,ROW( <span style=\"color: #ff0000;\">A2:A11<\/span> ),-1)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menggunakan fungsi <strong>SORTBY<\/strong> yang menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>SORT(array, menurut_array, sort_order,\u2026)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>array<\/strong> : Array yang akan diurutkan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>by_array<\/strong> : array yang akan diurutkan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>sort_order<\/strong> : 1 = menaik, -1 = menurun<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dalam argumen pertama, kami menentukan bahwa kami ingin mengurutkan rentang <strong>A2:C11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam argumen kedua, kita menentukan bahwa kita ingin menggunakan nomor baris dalam rentang <strong>A2:A11<\/strong> sebagai nilai pengurutan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada argumen ketiga, kita menggunakan nilai <strong>-1<\/strong> untuk menentukan bahwa kita ingin mengurutkan berdasarkan nomor baris dalam urutan menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasil akhirnya adalah kita dapat membalikkan urutan baris dalam rentang <strong>A2:C11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>SORTBY<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/excel-menggabungkan-baris-dengan-id-yang-sama\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggabungkan baris dengan pengenal yang sama<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung baris dengan teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menyorot-baris-duplikat\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menyorot baris duplikat<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut di Excel untuk membalikkan urutan baris dengan cepat: =SORTBY( $A$2:$C$11 ,ROW( A2:A11 ),-1) Contoh khusus ini akan membalikkan urutan garis dalam rentang A2:C11 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Cara membalikkan urutan baris di Excel Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi [&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 Membalik Urutan Baris di Excel (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membalikkan urutan baris 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-membalikkan-urutan-baris\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membalik Urutan Baris di Excel (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membalikkan urutan baris di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T11:50:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revo1.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-membalikkan-urutan-baris\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/\",\"name\":\"Cara Membalik Urutan Baris di Excel (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T11:50:18+00:00\",\"dateModified\":\"2023-07-08T11:50:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membalikkan urutan baris di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membalik urutan baris 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 Membalik Urutan Baris di Excel (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara membalikkan urutan baris 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-membalikkan-urutan-baris\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membalik Urutan Baris di Excel (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara membalikkan urutan baris di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/","og_site_name":"Statorials","article_published_time":"2023-07-08T11:50:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/revo1.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-membalikkan-urutan-baris\/","url":"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/","name":"Cara Membalik Urutan Baris di Excel (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T11:50:18+00:00","dateModified":"2023-07-08T11:50:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membalikkan urutan baris di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-membalikkan-urutan-baris\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membalik urutan baris 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\/4734"}],"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=4734"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4734\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}