Yth. Mr. Kid dan M. Ade
hmmmmm hehehehe .. terlihat kasat penglihatan saya semacam itu Mr. Kid
(hasilnya 0 sama tampak seperti blank). untuk tanda tanya yang pertama dan
ketiga, saya belum mudeng .. hehehehemohon kiranya berkenan memberi penjelasan
..
Terima kasih
On Friday, June 9, 2017 6:52 AM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
hehehe...
trus apa beda sebenarnya ? apa iya sekedar hasilnya 0 sama tampak seperti blank
?
kok bisa beda hasilnya ?
Regards,
Kid
On Thu, Jun 8, 2017 at 8:46 AM, Eira I Arie cheivory_bri...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
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
#yiv6278175647 #yiv6278175647 -- #yiv6278175647ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6278175647
#yiv6278175647ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6278175647
#yiv6278175647ygrp-mkp #yiv6278175647hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6278175647 #yiv6278175647ygrp-mkp #yiv6278175647ads
{margin-bottom:10px;}#yiv6278175647 #yiv6278175647ygrp-mkp .yiv6278175647ad
{padding:0 0;}#yiv6278175647 #yiv6278175647ygrp-mkp .yiv6278175647ad p
{margin:0;}#yiv6278175647 #yiv6278175647ygrp-mkp .yiv6278175647ad a
{color:#0000ff;text-decoration:none;}#yiv6278175647 #yiv6278175647ygrp-sponsor
#yiv6278175647ygrp-lc {font-family:Arial;}#yiv6278175647
#yiv6278175647ygrp-sponsor #yiv6278175647ygrp-lc #yiv6278175647hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6278175647
#yiv6278175647ygrp-sponsor #yiv6278175647ygrp-lc .yiv6278175647ad
{margin-bottom:10px;padding:0 0;}#yiv6278175647 #yiv6278175647actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6278175647
#yiv6278175647activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6278175647
#yiv6278175647activity span {font-weight:700;}#yiv6278175647
#yiv6278175647activity span:first-child
{text-transform:uppercase;}#yiv6278175647 #yiv6278175647activity span a
{color:#5085b6;text-decoration:none;}#yiv6278175647 #yiv6278175647activity span
span {color:#ff7900;}#yiv6278175647 #yiv6278175647activity span
.yiv6278175647underline {text-decoration:underline;}#yiv6278175647
.yiv6278175647attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6278175647 .yiv6278175647attach div a
{text-decoration:none;}#yiv6278175647 .yiv6278175647attach img
{border:none;padding-right:5px;}#yiv6278175647 .yiv6278175647attach label
{display:block;margin-bottom:5px;}#yiv6278175647 .yiv6278175647attach label a
{text-decoration:none;}#yiv6278175647 blockquote {margin:0 0 0
4px;}#yiv6278175647 .yiv6278175647bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6278175647
.yiv6278175647bold a {text-decoration:none;}#yiv6278175647 dd.yiv6278175647last
p a {font-family:Verdana;font-weight:700;}#yiv6278175647 dd.yiv6278175647last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6278175647
dd.yiv6278175647last p span.yiv6278175647yshortcuts
{margin-right:0;}#yiv6278175647 div.yiv6278175647attach-table div div a
{text-decoration:none;}#yiv6278175647 div.yiv6278175647attach-table
{width:400px;}#yiv6278175647 div.yiv6278175647file-title a, #yiv6278175647
div.yiv6278175647file-title a:active, #yiv6278175647
div.yiv6278175647file-title a:hover, #yiv6278175647 div.yiv6278175647file-title
a:visited {text-decoration:none;}#yiv6278175647 div.yiv6278175647photo-title a,
#yiv6278175647 div.yiv6278175647photo-title a:active, #yiv6278175647
div.yiv6278175647photo-title a:hover, #yiv6278175647
div.yiv6278175647photo-title a:visited {text-decoration:none;}#yiv6278175647
div#yiv6278175647ygrp-mlmsg #yiv6278175647ygrp-msg p a
span.yiv6278175647yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6278175647
.yiv6278175647green {color:#628c2a;}#yiv6278175647 .yiv6278175647MsoNormal
{margin:0 0 0 0;}#yiv6278175647 o {font-size:0;}#yiv6278175647
#yiv6278175647photos div {float:left;width:72px;}#yiv6278175647
#yiv6278175647photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6278175647
#yiv6278175647photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6278175647
#yiv6278175647reco-category {font-size:77%;}#yiv6278175647
#yiv6278175647reco-desc {font-size:77%;}#yiv6278175647 .yiv6278175647replbq
{margin:4px;}#yiv6278175647 #yiv6278175647ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6278175647 #yiv6278175647ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6278175647
#yiv6278175647ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6278175647
#yiv6278175647ygrp-mlmsg select, #yiv6278175647 input, #yiv6278175647 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6278175647
#yiv6278175647ygrp-mlmsg pre, #yiv6278175647 code {font:115%
monospace;}#yiv6278175647 #yiv6278175647ygrp-mlmsg *
{line-height:1.22em;}#yiv6278175647 #yiv6278175647ygrp-mlmsg #yiv6278175647logo
{padding-bottom:10px;}#yiv6278175647 #yiv6278175647ygrp-msg p a
{font-family:Verdana;}#yiv6278175647 #yiv6278175647ygrp-msg
p#yiv6278175647attach-count span {color:#1E66AE;font-weight:700;}#yiv6278175647
#yiv6278175647ygrp-reco #yiv6278175647reco-head
{color:#ff7900;font-weight:700;}#yiv6278175647 #yiv6278175647ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6278175647 #yiv6278175647ygrp-sponsor
#yiv6278175647ov li a {font-size:130%;text-decoration:none;}#yiv6278175647
#yiv6278175647ygrp-sponsor #yiv6278175647ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6278175647
#yiv6278175647ygrp-sponsor #yiv6278175647ov ul {margin:0;padding:0 0 0
8px;}#yiv6278175647 #yiv6278175647ygrp-text
{font-family:Georgia;}#yiv6278175647 #yiv6278175647ygrp-text p {margin:0 0 1em
0;}#yiv6278175647 #yiv6278175647ygrp-text tt {font-size:120%;}#yiv6278175647
#yiv6278175647ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6278175647
