[belajar-excel] Digest Number 4101

Milis Belajar Microsoft Excel Group

4 Messages

Digest #4101

1a

Re: Logika AND by "Mr. Kid" nmkid.family@ymail.com

1b

Bls: [belajar-excel] Logika AND by "Fahmi Syaifullah" fahmisyaifullah20

2a

Re: menampilkan uraian berdasarkan pilihan bulan [1 Attachment] by "farud oke"

3

Bls: [belajar-excel] Meng-update nama barang [1 Attachment] by "ghozi alkatiri" ghozialkatiri

Messages

1a

Re: Logika AND

Tue Feb 21, 2017 6:39 am (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Wa'alaikumussalam wr wb

Hai Fahmi,

Sebaiknya diperiksa ulang lagi formula yang dibuar tersebut.

Wassalamu'alaikum wr wb
Kid

2017-02-21 21:19 GMT+07:00 Fahmi Syaifullah fahmisyaifullah20@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Assalamualaikum.
> Dear BeExceller
>
> mau tanya fungsi "and" kenapa ngaco yaa jika tidak diletakkan di field row
> yg tdk sama pada rujukan fungsinya (data yg dijadiin rumus itu satu row
> sama rumusnya baru bernilai valid) tapi kalau dilain row (data ada di row
> 13 dan rumus ditulis di row 17 )hasil output bernilai FALSE padahal jelas2
> itu bernilai TRUE. Apa memang seperti itu ya?..
> Mohon bantuannya..
>
> Terima kasih
> Wassalamu'alaikum
> fahmi
>
> Dikirim dari Yahoo Mail di Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Bls: [belajar-excel] Logika AND

Tue Feb 21, 2017 5:46 pm (PST) . Posted by:

"Fahmi Syaifullah" fahmisyaifullah20

assalamu'alaikum
berikut saya lampirkan filenya om kid apa ada yang salah dengan rumusnya
Terima kasihwassalamu'alaikumfahmi


Pada Selasa, 21 Februari 2017 21:40, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Wa'alaikumussalam wr wb

Hai Fahmi,

Sebaiknya diperiksa ulang lagi formula yang dibuar tersebut.

Wassalamu'alaikum wr wb
Kid

2017-02-21 21:19 GMT+07:00 Fahmi Syaifullah fahmisyaifullah20@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Assalamualaikum.Dear BeExceller
mau tanya fungsi "and" kenapa ngaco yaa jika tidak diletakkan di field row yg tdk sama pada rujukan fungsinya (data yg dijadiin rumus itu satu row sama rumusnya baru bernilai valid) tapi kalau dilain row (data ada di row 13 dan rumus ditulis di row 17 )hasil output bernilai FALSE padahal jelas2 itu bernilai TRUE. Apa memang seperti itu ya?..Mohon bantuannya..
Terima kasihWassalamu&#39;alaikumfahmi
Dikirim dari Yahoo Mail di Android

#yiv3816443514 #yiv3816443514 -- #yiv3816443514ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3816443514 #yiv3816443514ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3816443514 #yiv3816443514ygrp-mkp #yiv3816443514hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3816443514 #yiv3816443514ygrp-mkp #yiv3816443514ads {margin-bottom:10px;}#yiv3816443514 #yiv3816443514ygrp-mkp .yiv3816443514ad {padding:0 0;}#yiv3816443514 #yiv3816443514ygrp-mkp .yiv3816443514ad p {margin:0;}#yiv3816443514 #yiv3816443514ygrp-mkp .yiv3816443514ad a {color:#0000ff;text-decoration:none;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ygrp-lc {font-family:Arial;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ygrp-lc #yiv3816443514hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ygrp-lc .yiv3816443514ad {margin-bottom:10px;padding:0 0;}#yiv3816443514 #yiv3816443514actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3816443514 #yiv3816443514activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3816443514 #yiv3816443514activity span {font-weight:700;}#yiv3816443514 #yiv3816443514activity span:first-child {text-transform:uppercase;}#yiv3816443514 #yiv3816443514activity span a {color:#5085b6;text-decoration:none;}#yiv3816443514 #yiv3816443514activity span span {color:#ff7900;}#yiv3816443514 #yiv3816443514activity span .yiv3816443514underline {text-decoration:underline;}#yiv3816443514 .yiv3816443514attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3816443514 .yiv3816443514attach div a {text-decoration:none;}#yiv3816443514 .yiv3816443514attach img {border:none;padding-right:5px;}#yiv3816443514 .yiv3816443514attach label {display:block;margin-bottom:5px;}#yiv3816443514 .yiv3816443514attach label a {text-decoration:none;}#yiv3816443514 blockquote {margin:0 0 0 4px;}#yiv3816443514 .yiv3816443514bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3816443514 .yiv3816443514bold a {text-decoration:none;}#yiv3816443514 dd.yiv3816443514last p a {font-family:Verdana;font-weight:700;}#yiv3816443514 dd.yiv3816443514last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3816443514 dd.yiv3816443514last p span.yiv3816443514yshortcuts {margin-right:0;}#yiv3816443514 div.yiv3816443514attach-table div div a {text-decoration:none;}#yiv3816443514 div.yiv3816443514attach-table {width:400px;}#yiv3816443514 div.yiv3816443514file-title a, #yiv3816443514 div.yiv3816443514file-title a:active, #yiv3816443514 div.yiv3816443514file-title a:hover, #yiv3816443514 div.yiv3816443514file-title a:visited {text-decoration:none;}#yiv3816443514 div.yiv3816443514photo-title a, #yiv3816443514 div.yiv3816443514photo-title a:active, #yiv3816443514 div.yiv3816443514photo-title a:hover, #yiv3816443514 div.yiv3816443514photo-title a:visited {text-decoration:none;}#yiv3816443514 div#yiv3816443514ygrp-mlmsg #yiv3816443514ygrp-msg p a span.yiv3816443514yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3816443514 .yiv3816443514green {color:#628c2a;}#yiv3816443514 .yiv3816443514MsoNormal {margin:0 0 0 0;}#yiv3816443514 o {font-size:0;}#yiv3816443514 #yiv3816443514photos div {float:left;width:72px;}#yiv3816443514 #yiv3816443514photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3816443514 #yiv3816443514photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3816443514 #yiv3816443514reco-category {font-size:77%;}#yiv3816443514 #yiv3816443514reco-desc {font-size:77%;}#yiv3816443514 .yiv3816443514replbq {margin:4px;}#yiv3816443514 #yiv3816443514ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3816443514 #yiv3816443514ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3816443514 #yiv3816443514ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3816443514 #yiv3816443514ygrp-mlmsg select, #yiv3816443514 input, #yiv3816443514 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3816443514 #yiv3816443514ygrp-mlmsg pre, #yiv3816443514 code {font:115% monospace;}#yiv3816443514 #yiv3816443514ygrp-mlmsg * {line-height:1.22em;}#yiv3816443514 #yiv3816443514ygrp-mlmsg #yiv3816443514logo {padding-bottom:10px;}#yiv3816443514 #yiv3816443514ygrp-msg p a {font-family:Verdana;}#yiv3816443514 #yiv3816443514ygrp-msg p#yiv3816443514attach-count span {color:#1E66AE;font-weight:700;}#yiv3816443514 #yiv3816443514ygrp-reco #yiv3816443514reco-head {color:#ff7900;font-weight:700;}#yiv3816443514 #yiv3816443514ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ov li a {font-size:130%;text-decoration:none;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3816443514 #yiv3816443514ygrp-sponsor #yiv3816443514ov ul {margin:0;padding:0 0 0 8px;}#yiv3816443514 #yiv3816443514ygrp-text {font-family:Georgia;}#yiv3816443514 #yiv3816443514ygrp-text p {margin:0 0 1em 0;}#yiv3816443514 #yiv3816443514ygrp-text tt {font-size:120%;}#yiv3816443514 #yiv3816443514ygrp-vital ul li:last-child {border-right:none !important;}#yiv3816443514

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

Re: menampilkan uraian berdasarkan pilihan bulan [1 Attachment]

Tue Feb 21, 2017 9:09 am (PST) . Posted by:

"farud oke"

Terimakasih mr.kid sudah sesuai dg apa yg saya harapkan..

Pada tanggal 21 Feb 2017 7.13 AM, "'Mr. Kid' mr.nmkid@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

>
>
> Wa'alaikumussalam wr wb
>
> Hai Farud,
>
> Ada baiknya sumber data ditata ulang agar memenuhi kaidah tabel database,
> sehingga lebih mudah diolah dengan formula yang sederhana dan ringan untuk
> dikalkulasi.
>
> File terlampir.
>
> Wassalamu'alaikum wr wb
> Kid

>
>
>
>
>
>
>
> 2017-02-19 11:26 GMT+07:00 farud oke farud.oke@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>>
>>
>> Assalamualaikum...
>> mohon bantuan para master excel dengan permasalahan saya,file terlampir...
>> atas bantuannya saya sampaikan terimakasih
>>
>>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

3

Bls: [belajar-excel] Meng-update nama barang [1 Attachment]

Tue Feb 21, 2017 2:40 pm (PST) . Posted by:

"ghozi alkatiri" ghozialkatiri

solusi dengan formula
lihat attachment di sheet solusi

wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Sel, 21/2/17, asam gatal asamgatal@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] Meng-update nama barang [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 21 Februari, 2017, 12:04 PM


 









Kepada para master dan segenap
anggota milis. Mohon dibantu.

Bagaimana meng-update total barang pada sheet
Total,
sehingga nama barang yang sama
dikelompokkan menjadi 1 nama saja.
Kasus ini
memang bisa diselesaikan dengan pivot tabel,
tetapi saya ingin pakai rumus atau tombol
perintah. Silakan lihat lampiran.

Atas bantuannya saya ucapkan terima
kasih.











#yiv4640929496 #yiv4640929496 --
#yiv4640929496ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv4640929496 #yiv4640929496ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4640929496 #yiv4640929496ygrp-mkp #yiv4640929496hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4640929496 #yiv4640929496ygrp-mkp #yiv4640929496ads {
margin-bottom:10px;}

#yiv4640929496 #yiv4640929496ygrp-mkp .yiv4640929496ad {
padding:0 0;}

#yiv4640929496 #yiv4640929496ygrp-mkp .yiv4640929496ad p {
margin:0;}

#yiv4640929496 #yiv4640929496ygrp-mkp .yiv4640929496ad a {
color:#0000ff;text-decoration:none;}
#yiv4640929496 #yiv4640929496ygrp-sponsor
#yiv4640929496ygrp-lc {
font-family:Arial;}

#yiv4640929496 #yiv4640929496ygrp-sponsor
#yiv4640929496ygrp-lc #yiv4640929496hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4640929496 #yiv4640929496ygrp-sponsor
#yiv4640929496ygrp-lc .yiv4640929496ad {
margin-bottom:10px;padding:0 0;}

#yiv4640929496 #yiv4640929496actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv4640929496 #yiv4640929496activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv4640929496 #yiv4640929496activity span {
font-weight:700;}

#yiv4640929496 #yiv4640929496activity span:first-child {
text-transform:uppercase;}

#yiv4640929496 #yiv4640929496activity span a {
color:#5085b6;text-decoration:none;}

#yiv4640929496 #yiv4640929496activity span span {
color:#ff7900;}

#yiv4640929496 #yiv4640929496activity span
.yiv4640929496underline {
text-decoration:underline;}

#yiv4640929496 .yiv4640929496attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv4640929496 .yiv4640929496attach div a {
text-decoration:none;}

#yiv4640929496 .yiv4640929496attach img {
border:none;padding-right:5px;}

#yiv4640929496 .yiv4640929496attach label {
display:block;margin-bottom:5px;}

#yiv4640929496 .yiv4640929496attach label a {
text-decoration:none;}

#yiv4640929496 blockquote {
margin:0 0 0 4px;}

#yiv4640929496 .yiv4640929496bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4640929496 .yiv4640929496bold a {
text-decoration:none;}

#yiv4640929496 dd.yiv4640929496last p a {
font-family:Verdana;font-weight:700;}

#yiv4640929496 dd.yiv4640929496last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv4640929496 dd.yiv4640929496last p
span.yiv4640929496yshortcuts {
margin-right:0;}

#yiv4640929496 div.yiv4640929496attach-table div div a {
text-decoration:none;}

#yiv4640929496 div.yiv4640929496attach-table {
width:400px;}

#yiv4640929496 div.yiv4640929496file-title a, #yiv4640929496
div.yiv4640929496file-title a:active, #yiv4640929496
div.yiv4640929496file-title a:hover, #yiv4640929496
div.yiv4640929496file-title a:visited {
text-decoration:none;}

#yiv4640929496 div.yiv4640929496photo-title a,
#yiv4640929496 div.yiv4640929496photo-title a:active,
#yiv4640929496 div.yiv4640929496photo-title a:hover,
#yiv4640929496 div.yiv4640929496photo-title a:visited {
text-decoration:none;}

#yiv4640929496 div#yiv4640929496ygrp-mlmsg
#yiv4640929496ygrp-msg p a span.yiv4640929496yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4640929496 .yiv4640929496green {
color:#628c2a;}

#yiv4640929496 .yiv4640929496MsoNormal {
margin:0 0 0 0;}

#yiv4640929496 o {
font-size:0;}

#yiv4640929496 #yiv4640929496photos div {
float:left;width:72px;}

#yiv4640929496 #yiv4640929496photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv4640929496 #yiv4640929496photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv4640929496 #yiv4640929496reco-category {
font-size:77%;}

#yiv4640929496 #yiv4640929496reco-desc {
font-size:77%;}

#yiv4640929496 .yiv4640929496replbq {
margin:4px;}

#yiv4640929496 #yiv4640929496ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv4640929496 #yiv4640929496ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv4640929496 #yiv4640929496ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv4640929496 #yiv4640929496ygrp-mlmsg select,
#yiv4640929496 input, #yiv4640929496 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv4640929496 #yiv4640929496ygrp-mlmsg pre, #yiv4640929496
code {
font:115% monospace;}

#yiv4640929496 #yiv4640929496ygrp-mlmsg * {
line-height:1.22em;}

#yiv4640929496 #yiv4640929496ygrp-mlmsg #yiv4640929496logo {
padding-bottom:10px;}


#yiv4640929496 #yiv4640929496ygrp-msg p a {
font-family:Verdana;}

#yiv4640929496 #yiv4640929496ygrp-msg
p#yiv4640929496attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4640929496 #yiv4640929496ygrp-reco
#yiv4640929496reco-head {
color:#ff7900;font-weight:700;}

#yiv4640929496 #yiv4640929496ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4640929496 #yiv4640929496ygrp-sponsor #yiv4640929496ov
li a {
font-size:130%;text-decoration:none;}

#yiv4640929496 #yiv4640929496ygrp-sponsor #yiv4640929496ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4640929496 #yiv4640929496ygrp-sponsor #yiv4640929496ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4640929496 #yiv4640929496ygrp-text {
font-family:Georgia;}

#yiv4640929496 #yiv4640929496ygrp-text p {
margin:0 0 1em 0;}

#yiv4640929496 #yiv4640929496ygrp-text tt {
font-size:120%;}

#yiv4640929496 #yiv4640929496ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4640929496

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use