Yth. Mr. Kid Formula pertama = menghasilkan 0Formula kedua = menghasilkan kosong " " fungsi trim sepanjang saya tahu berguna untuk menghilangkan spasi yang berlebih. tetapi sheet baru kan masih bersih yaa .. setelah saya praktekkan arahan Mr. Kid dalam case ini sudah berhasil. terima kasih Mr. Kid
On Thursday, June 8, 2017 5:29 AM, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote: Hai Eria, Coba buat sheet baru. Seluruh cells dalam sheet baru pastilah masih kosong beneran (blank). di A1 tulis formula =B1 enter di A2 tulis formula =Trim( B1 ) Apa beda dari kedua formula tersebut (kedua formula sama-sama merujuk ke cells B1 bukan) ? Regards, Kid On Wed, Jun 7, 2017 at 11:11 AM, Eira I Arie cheivory_bri...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Yth > Pak Nang dan Mr. Kid terima kasih atas bantuannya .. Mohon maaf tanya lagi masih terkait case tersebut .. dalam case tersebut terdapat formula misalnya =IF(H40<>"";COUNTA($H$26:H40); "") .. beberapa rujukan dari formula tersebut sebenarnya adalah kosong / tidak ada isinya tetapi mengapa hasilnya ada ya ? yang akhirnya dalam case ini menyebabkan baris (mestinya) kosong tidak terhidden... Mengapa ya kira2 bisa seperti itu dan mohon solusinya .. Terima kasih On Wednesday, June 7, 2017 5:46 AM, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com > wrote: Wa'alaikumussalam wr wb File terlampir. Wassalamu'alaikum wr wb Kid 2017-06-02 13:56 GMT+07:00 cheivory_bri...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com >: Yth. Be-Exceler Assalaamu'alaikum Wr Wb Mohon bantuannya untuk case terlampir. Terima Kasih Wassalaamu'alaikum Wr Wb Ari #yiv7894604330 #yiv7894604330 -- #yiv7894604330ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7894604330 #yiv7894604330ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7894604330 #yiv7894604330ygrp-mkp #yiv7894604330hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7894604330 #yiv7894604330ygrp-mkp #yiv7894604330ads {margin-bottom:10px;}#yiv7894604330 #yiv7894604330ygrp-mkp .yiv7894604330ad {padding:0 0;}#yiv7894604330 #yiv7894604330ygrp-mkp .yiv7894604330ad p {margin:0;}#yiv7894604330 #yiv7894604330ygrp-mkp .yiv7894604330ad a {color:#0000ff;text-decoration:none;}#yiv7894604330 #yiv7894604330ygrp-sponsor #yiv7894604330ygrp-lc {font-family:Arial;}#yiv7894604330 #yiv7894604330ygrp-sponsor #yiv7894604330ygrp-lc #yiv7894604330hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7894604330 #yiv7894604330ygrp-sponsor #yiv7894604330ygrp-lc .yiv7894604330ad {margin-bottom:10px;padding:0 0;}#yiv7894604330 #yiv7894604330actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7894604330 #yiv7894604330activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7894604330 #yiv7894604330activity span {font-weight:700;}#yiv7894604330 #yiv7894604330activity span:first-child {text-transform:uppercase;}#yiv7894604330 #yiv7894604330activity span a {color:#5085b6;text-decoration:none;}#yiv7894604330 #yiv7894604330activity span span {color:#ff7900;}#yiv7894604330 #yiv7894604330activity span .yiv7894604330underline {text-decoration:underline;}#yiv7894604330 .yiv7894604330attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7894604330 .yiv7894604330attach div a {text-decoration:none;}#yiv7894604330 .yiv7894604330attach img {border:none;padding-right:5px;}#yiv7894604330 .yiv7894604330attach label {display:block;margin-bottom:5px;}#yiv7894604330 .yiv7894604330attach label a {text-decoration:none;}#yiv7894604330 blockquote {margin:0 0 0 4px;}#yiv7894604330 .yiv7894604330bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7894604330 .yiv7894604330bold a {text-decoration:none;}#yiv7894604330 dd.yiv7894604330last p a {font-family:Verdana;font-weight:700;}#yiv7894604330 dd.yiv7894604330last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7894604330 dd.yiv7894604330last p span.yiv7894604330yshortcuts {margin-right:0;}#yiv7894604330 div.yiv7894604330attach-table div div a {text-decoration:none;}#yiv7894604330 div.yiv7894604330attach-table {width:400px;}#yiv7894604330 div.yiv7894604330file-title a, #yiv7894604330 div.yiv7894604330file-title a:active, #yiv7894604330 div.yiv7894604330file-title a:hover, #yiv7894604330 div.yiv7894604330file-title a:visited {text-decoration:none;}#yiv7894604330 div.yiv7894604330photo-title a, #yiv7894604330 div.yiv7894604330photo-title a:active, #yiv7894604330 div.yiv7894604330photo-title a:hover, #yiv7894604330 div.yiv7894604330photo-title a:visited {text-decoration:none;}#yiv7894604330 div#yiv7894604330ygrp-mlmsg #yiv7894604330ygrp-msg p a span.yiv7894604330yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7894604330 .yiv7894604330green {color:#628c2a;}#yiv7894604330 .yiv7894604330MsoNormal {margin:0 0 0 0;}#yiv7894604330 o {font-size:0;}#yiv7894604330 #yiv7894604330photos div {float:left;width:72px;}#yiv7894604330 #yiv7894604330photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7894604330 #yiv7894604330photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7894604330 #yiv7894604330reco-category {font-size:77%;}#yiv7894604330 #yiv7894604330reco-desc {font-size:77%;}#yiv7894604330 .yiv7894604330replbq {margin:4px;}#yiv7894604330 #yiv7894604330ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7894604330 #yiv7894604330ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7894604330 #yiv7894604330ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7894604330 #yiv7894604330ygrp-mlmsg select, #yiv7894604330 input, #yiv7894604330 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7894604330 #yiv7894604330ygrp-mlmsg pre, #yiv7894604330 code {font:115% monospace;}#yiv7894604330 #yiv7894604330ygrp-mlmsg * {line-height:1.22em;}#yiv7894604330 #yiv7894604330ygrp-mlmsg #yiv7894604330logo {padding-bottom:10px;}#yiv7894604330 #yiv7894604330ygrp-msg p a {font-family:Verdana;}#yiv7894604330 #yiv7894604330ygrp-msg p#yiv7894604330attach-count span {color:#1E66AE;font-weight:700;}#yiv7894604330 #yiv7894604330ygrp-reco #yiv7894604330reco-head {color:#ff7900;font-weight:700;}#yiv7894604330 #yiv7894604330ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7894604330 #yiv7894604330ygrp-sponsor #yiv7894604330ov li a {font-size:130%;text-decoration:none;}#yiv7894604330 #yiv7894604330ygrp-sponsor #yiv7894604330ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7894604330 #yiv7894604330ygrp-sponsor #yiv7894604330ov ul {margin:0;padding:0 0 0 8px;}#yiv7894604330 #yiv7894604330ygrp-text {font-family:Georgia;}#yiv7894604330 #yiv7894604330ygrp-text p {margin:0 0 1em 0;}#yiv7894604330 #yiv7894604330ygrp-text tt {font-size:120%;}#yiv7894604330 #yiv7894604330ygrp-vital ul li:last-child {border-right:none !important;}#yiv7894604330