Terima kasih rekan Susilo dan rekan Alfarid atas pencerahannya.. Sangat membantu sekali.. :-)
On Tuesday, February 14, 2017 3:14 PM, "Susilo - [email protected] [belajar-excel]" <[email protected]> wrote: Hai Ary Untuk memanipulasi data hidden coba gunakan rumus subtotal ketik di sel A4 rumus berikut =SUBTOTAL(103,B$4:B4) Copykan rumusnya ke bawahSilakan dicoba Terima kasihSusilo Pada 14 Februari 2017 14.35, Aku Ary [email protected] [belajar-excel] <[email protected]> menulis: Dear Para Suhu, Mohon bimbingannya..Apabila melakukan hide pada baris tertentu, maka nomor urut secara otomatis akan ikut berubah mengikuti sesuai urutan yang ada (hanya tampil urutan dari data yang tidak di hidden). Terima kasih atas bantuan dan pencerahannya. Mohon maaf apabila sudah pernah dibahas sebelumnya.. salam,ary *terlampir contoh kasus sederhana #yiv3510131499 -- #yiv3510131499ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3510131499 #yiv3510131499ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3510131499 #yiv3510131499ygrp-mkp #yiv3510131499hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3510131499 #yiv3510131499ygrp-mkp #yiv3510131499ads {margin-bottom:10px;}#yiv3510131499 #yiv3510131499ygrp-mkp .yiv3510131499ad {padding:0 0;}#yiv3510131499 #yiv3510131499ygrp-mkp .yiv3510131499ad p {margin:0;}#yiv3510131499 #yiv3510131499ygrp-mkp .yiv3510131499ad a {color:#0000ff;text-decoration:none;}#yiv3510131499 #yiv3510131499ygrp-sponsor #yiv3510131499ygrp-lc {font-family:Arial;}#yiv3510131499 #yiv3510131499ygrp-sponsor #yiv3510131499ygrp-lc #yiv3510131499hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3510131499 #yiv3510131499ygrp-sponsor #yiv3510131499ygrp-lc .yiv3510131499ad {margin-bottom:10px;padding:0 0;}#yiv3510131499 #yiv3510131499actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3510131499 #yiv3510131499activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3510131499 #yiv3510131499activity span {font-weight:700;}#yiv3510131499 #yiv3510131499activity span:first-child {text-transform:uppercase;}#yiv3510131499 #yiv3510131499activity span a {color:#5085b6;text-decoration:none;}#yiv3510131499 #yiv3510131499activity span span {color:#ff7900;}#yiv3510131499 #yiv3510131499activity span .yiv3510131499underline {text-decoration:underline;}#yiv3510131499 .yiv3510131499attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3510131499 .yiv3510131499attach div a {text-decoration:none;}#yiv3510131499 .yiv3510131499attach img {border:none;padding-right:5px;}#yiv3510131499 .yiv3510131499attach label {display:block;margin-bottom:5px;}#yiv3510131499 .yiv3510131499attach label a {text-decoration:none;}#yiv3510131499 blockquote {margin:0 0 0 4px;}#yiv3510131499 .yiv3510131499bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3510131499 .yiv3510131499bold a {text-decoration:none;}#yiv3510131499 dd.yiv3510131499last p a {font-family:Verdana;font-weight:700;}#yiv3510131499 dd.yiv3510131499last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3510131499 dd.yiv3510131499last p span.yiv3510131499yshortcuts {margin-right:0;}#yiv3510131499 div.yiv3510131499attach-table div div a {text-decoration:none;}#yiv3510131499 div.yiv3510131499attach-table {width:400px;}#yiv3510131499 div.yiv3510131499file-title a, #yiv3510131499 div.yiv3510131499file-title a:active, #yiv3510131499 div.yiv3510131499file-title a:hover, #yiv3510131499 div.yiv3510131499file-title a:visited {text-decoration:none;}#yiv3510131499 div.yiv3510131499photo-title a, #yiv3510131499 div.yiv3510131499photo-title a:active, #yiv3510131499 div.yiv3510131499photo-title a:hover, #yiv3510131499 div.yiv3510131499photo-title a:visited {text-decoration:none;}#yiv3510131499 div#yiv3510131499ygrp-mlmsg #yiv3510131499ygrp-msg p a span.yiv3510131499yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3510131499 .yiv3510131499green {color:#628c2a;}#yiv3510131499 .yiv3510131499MsoNormal {margin:0 0 0 0;}#yiv3510131499 o {font-size:0;}#yiv3510131499 #yiv3510131499photos div {float:left;width:72px;}#yiv3510131499 #yiv3510131499photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3510131499 #yiv3510131499photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3510131499 #yiv3510131499reco-category {font-size:77%;}#yiv3510131499 #yiv3510131499reco-desc {font-size:77%;}#yiv3510131499 .yiv3510131499replbq {margin:4px;}#yiv3510131499 #yiv3510131499ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3510131499 #yiv3510131499ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3510131499 #yiv3510131499ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3510131499 #yiv3510131499ygrp-mlmsg select, #yiv3510131499 input, #yiv3510131499 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3510131499 #yiv3510131499ygrp-mlmsg pre, #yiv3510131499 code {font:115% monospace;}#yiv3510131499 #yiv3510131499ygrp-mlmsg * {line-height:1.22em;}#yiv3510131499 #yiv3510131499ygrp-mlmsg #yiv3510131499logo {padding-bottom:10px;}#yiv3510131499 #yiv3510131499ygrp-msg p a {font-family:Verdana;}#yiv3510131499 #yiv3510131499ygrp-msg p#yiv3510131499attach-count span {color:#1E66AE;font-weight:700;}#yiv3510131499 #yiv3510131499ygrp-reco #yiv3510131499reco-head {color:#ff7900;font-weight:700;}#yiv3510131499 #yiv3510131499ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3510131499 #yiv3510131499ygrp-sponsor #yiv3510131499ov li a {font-size:130%;text-decoration:none;}#yiv3510131499 #yiv3510131499ygrp-sponsor #yiv3510131499ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3510131499 #yiv3510131499ygrp-sponsor #yiv3510131499ov ul {margin:0;padding:0 0 0 8px;}#yiv3510131499 #yiv3510131499ygrp-text {font-family:Georgia;}#yiv3510131499 #yiv3510131499ygrp-text p {margin:0 0 1em 0;}#yiv3510131499 #yiv3510131499ygrp-text tt {font-size:120%;}#yiv3510131499 #yiv3510131499ygrp-vital ul li:last-child {border-right:none !important;}#yiv3510131499
