8 Messages

Digest #4090

Bls: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment by "ghozi alkatiri" ghozialkatiri

Bls: [belajar-excel] menjumlahkan usia [1 Attachment] by "ghozi alkatiri" ghozialkatiri

Countif yang Kriterianya Sebagian dari Isi Sel by "Imam Sinurat" sin.ur4t

Re: Countif yang Kriterianya Sebagian dari Isi Sel by "hendrik karnadi" hendrikkarnadi

Bls: [belajar-excel] Countif yang Kriterianya Sebagian dari Isi Sel by "ghozi alkatiri" ghozialkatiri

Menyembunyikan kolom berdasarkan angka tertentu by "farud oke"

Bls: [belajar-excel] Hasil Kalkulasinya Pada User Form Beda by "Harry" hariansyahptk

Re: memilih nilai pada sheet tertentu [1 Attachment] by "Muhammad Arizal"

Messages

1 Bls: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment

Sat Feb 11, 2017 11:32 pm (PST) . Posted by:

"ghozi alkatiri" ghozialkatiri

tulis di B2
=INDIRECT($I$2&"!B"&ROW(1:1))
copy ke bawah

wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Sab, 11/2/17, Cety Carmelo Julita cetycarmelo@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Sabtu, 11 Februari, 2017, 12:05 PM

Selamat siang para
suhu, saya punya masalah formula excel seperti pada
lampiran. Mohon bantuannya. Makasih

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

#yiv9320867305 #yiv9320867305ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305ads {
margin-bottom:10px;}

#yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad {
padding:0 0;}

#yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad p {
margin:0;}

#yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad a {
color:#0000ff;text-decoration:none;}
#yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ygrp-lc {
font-family:Arial;}

#yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ygrp-lc #yiv9320867305hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ygrp-lc .yiv9320867305ad {
margin-bottom:10px;padding:0 0;}

#yiv9320867305 #yiv9320867305actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv9320867305 #yiv9320867305activity span {
font-weight:700;}

#yiv9320867305 #yiv9320867305activity span:first-child {
text-transform:uppercase;}

#yiv9320867305 #yiv9320867305activity span a {
color:#5085b6;text-decoration:none;}

#yiv9320867305 #yiv9320867305activity span span {
color:#ff7900;}

#yiv9320867305 #yiv9320867305activity span
.yiv9320867305underline {
text-decoration:underline;}

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

#yiv9320867305 .yiv9320867305attach div a {
text-decoration:none;}

#yiv9320867305 .yiv9320867305attach img {
border:none;padding-right:5px;}

#yiv9320867305 .yiv9320867305attach label {
display:block;margin-bottom:5px;}

#yiv9320867305 .yiv9320867305attach label a {
text-decoration:none;}

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

#yiv9320867305 .yiv9320867305bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9320867305 .yiv9320867305bold a {
text-decoration:none;}

#yiv9320867305 dd.yiv9320867305last p a {
font-family:Verdana;font-weight:700;}

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

#yiv9320867305 dd.yiv9320867305last p
span.yiv9320867305yshortcuts {
margin-right:0;}

#yiv9320867305 div.yiv9320867305attach-table div div a {
text-decoration:none;}

#yiv9320867305 div.yiv9320867305attach-table {
width:400px;}

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

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

#yiv9320867305 div#yiv9320867305ygrp-mlmsg
#yiv9320867305ygrp-msg p a span.yiv9320867305yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9320867305 .yiv9320867305green {
color:#628c2a;}

#yiv9320867305 .yiv9320867305MsoNormal {
margin:0 0 0 0;}

#yiv9320867305 o {
font-size:0;}

#yiv9320867305 #yiv9320867305photos div {
float:left;width:72px;}

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

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

#yiv9320867305 #yiv9320867305reco-category {
font-size:77%;}

#yiv9320867305 #yiv9320867305reco-desc {
font-size:77%;}

#yiv9320867305 .yiv9320867305replbq {
margin:4px;}

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

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

#yiv9320867305 #yiv9320867305ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv9320867305 #yiv9320867305ygrp-mlmsg pre, #yiv9320867305
code {
font:115% monospace;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg * {
line-height:1.22em;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg #yiv9320867305logo {
padding-bottom:10px;}

#yiv9320867305 #yiv9320867305ygrp-msg p a {
font-family:Verdana;}

#yiv9320867305 #yiv9320867305ygrp-msg
p#yiv9320867305attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9320867305 #yiv9320867305ygrp-reco
#yiv9320867305reco-head {
color:#ff7900;font-weight:700;}

#yiv9320867305 #yiv9320867305ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
li a {
font-size:130%;text-decoration:none;}

#yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9320867305 #yiv9320867305ygrp-text {
font-family:Georgia;}

#yiv9320867305 #yiv9320867305ygrp-text p {
margin:0 0 1em 0;}

#yiv9320867305 #yiv9320867305ygrp-text tt {
font-size:120%;}

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

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

2 Bls: [belajar-excel] menjumlahkan usia [1 Attachment]

Sun Feb 12, 2017 1:16 am (PST) . Posted by:

"ghozi alkatiri" ghozialkatiri

formula pada D6
=TRUNC((SUM(D4:D5)*12+SUM(E4:E5))/12)
formula pada E6
=TRUNC((SUM(D4:D5)*12+SUM(E4:E5));12)

wassalam

Ghozi Alkatiri

--------------------------------------------
Pada Sab, 11/2/17, d_darman@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] menjumlahkan usia [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Sabtu, 11 Februari, 2017, 1:35 PM

para
suhu mohon dibantu cara menjumlahkan usia, contoh
terlampir

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

#yiv0195742075 #yiv0195742075ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0195742075 #yiv0195742075ygrp-mkp #yiv0195742075hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0195742075 #yiv0195742075ygrp-mkp #yiv0195742075ads {
margin-bottom:10px;}

#yiv0195742075 #yiv0195742075ygrp-mkp .yiv0195742075ad {
padding:0 0;}

#yiv0195742075 #yiv0195742075ygrp-mkp .yiv0195742075ad p {
margin:0;}

#yiv0195742075 #yiv0195742075ygrp-mkp .yiv0195742075ad a {
color:#0000ff;text-decoration:none;}
#yiv0195742075 #yiv0195742075ygrp-sponsor
#yiv0195742075ygrp-lc {
font-family:Arial;}

#yiv0195742075 #yiv0195742075ygrp-sponsor
#yiv0195742075ygrp-lc #yiv0195742075hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0195742075 #yiv0195742075ygrp-sponsor
#yiv0195742075ygrp-lc .yiv0195742075ad {
margin-bottom:10px;padding:0 0;}

#yiv0195742075 #yiv0195742075actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv0195742075 #yiv0195742075activity span {
font-weight:700;}

#yiv0195742075 #yiv0195742075activity span:first-child {
text-transform:uppercase;}

#yiv0195742075 #yiv0195742075activity span a {
color:#5085b6;text-decoration:none;}

#yiv0195742075 #yiv0195742075activity span span {
color:#ff7900;}

#yiv0195742075 #yiv0195742075activity span
.yiv0195742075underline {
text-decoration:underline;}

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

#yiv0195742075 .yiv0195742075attach div a {
text-decoration:none;}

#yiv0195742075 .yiv0195742075attach img {
border:none;padding-right:5px;}

#yiv0195742075 .yiv0195742075attach label {
display:block;margin-bottom:5px;}

#yiv0195742075 .yiv0195742075attach label a {
text-decoration:none;}

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

#yiv0195742075 .yiv0195742075bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0195742075 .yiv0195742075bold a {
text-decoration:none;}

#yiv0195742075 dd.yiv0195742075last p a {
font-family:Verdana;font-weight:700;}

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

#yiv0195742075 dd.yiv0195742075last p
span.yiv0195742075yshortcuts {
margin-right:0;}

#yiv0195742075 div.yiv0195742075attach-table div div a {
text-decoration:none;}

#yiv0195742075 div.yiv0195742075attach-table {
width:400px;}

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

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

#yiv0195742075 div#yiv0195742075ygrp-mlmsg
#yiv0195742075ygrp-msg p a span.yiv0195742075yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0195742075 .yiv0195742075green {
color:#628c2a;}

#yiv0195742075 .yiv0195742075MsoNormal {
margin:0 0 0 0;}

#yiv0195742075 o {
font-size:0;}

#yiv0195742075 #yiv0195742075photos div {
float:left;width:72px;}

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

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

#yiv0195742075 #yiv0195742075reco-category {
font-size:77%;}

#yiv0195742075 #yiv0195742075reco-desc {
font-size:77%;}

#yiv0195742075 .yiv0195742075replbq {
margin:4px;}

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

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

#yiv0195742075 #yiv0195742075ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv0195742075 #yiv0195742075ygrp-mlmsg pre, #yiv0195742075
code {
font:115% monospace;}

#yiv0195742075 #yiv0195742075ygrp-mlmsg * {
line-height:1.22em;}

#yiv0195742075 #yiv0195742075ygrp-mlmsg #yiv0195742075logo {
padding-bottom:10px;}

#yiv0195742075 #yiv0195742075ygrp-msg p a {
font-family:Verdana;}

#yiv0195742075 #yiv0195742075ygrp-msg
p#yiv0195742075attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0195742075 #yiv0195742075ygrp-reco
#yiv0195742075reco-head {
color:#ff7900;font-weight:700;}

#yiv0195742075 #yiv0195742075ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0195742075 #yiv0195742075ygrp-sponsor #yiv0195742075ov
li a {
font-size:130%;text-decoration:none;}

#yiv0195742075 #yiv0195742075ygrp-sponsor #yiv0195742075ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0195742075 #yiv0195742075ygrp-sponsor #yiv0195742075ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0195742075 #yiv0195742075ygrp-text {
font-family:Georgia;}

#yiv0195742075 #yiv0195742075ygrp-text p {
margin:0 0 1em 0;}

#yiv0195742075 #yiv0195742075ygrp-text tt {
font-size:120%;}

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

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

3a

Countif yang Kriterianya Sebagian dari Isi Sel

Sun Feb 12, 2017 12:22 pm (PST) . Posted by:

"Imam Sinurat" sin.ur4t

| Yth. Para Admin dan rekan2… mohon bantuan formula dan/atau sintax vbe-nya. | |
| | | | | | | | | |
| 307 | 964 | 340 | | | | | | |
| 450 | 271 | 563 | | | | | | |
| 768 | 163 | 458 | | | | | | |
| 672 | 456 | 250 | | | | | | |
| 651 | 950 | 364 | | | | | | |
| | | | | | | | | |
| Pertanyaan : | | | | | | | |
| Dari range data tersebut, berapa banyakkah sel
yang "dua digit terakhirnya" bernilai 50?? |
| | | | | | | | | |
| Terima kasih | | | | | | | |
| Sinurat | | | | | | | | |

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

3b

Re: Countif yang Kriterianya Sebagian dari Isi Sel

Sun Feb 12, 2017 3:24 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Sinurat,Sdh coba pakai Countif?Criterianya "*50".
Salam,HK

Sent from Yahoo Mail on Android

On Mon, Feb 13, 2017 at 3:16, Imam Sinurat sin.ur4t@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:

| Yth. Para Admin dan rekan2… mohon bantuan formula dan/atau sintax vbe-nya. | |
| | | | | | | | | |
| 307 | 964 | 340 | | | | | | |
| 450 | 271 | 563 | | | | | | |
| 768 | 163 | 458 | | | | | | |
| 672 | 456 | 250 | | | | | | |
| 651 | 950 | 364 | | | | | | |
| | | | | | | | | |
| Pertanyaan : | | | | | | | |
| Dari range data tersebut, berapa banyakkah sel
yang "dua digit terakhirnya" bernilai 50?? |
| | | | | | | | | |
| Terima kasih | | | | | | | |
| Sinurat | | | | | | | | |

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

4 Bls: [belajar-excel] Countif yang Kriterianya Sebagian dari Isi Sel

Sun Feb 12, 2017 3:33 pm (PST) . Posted by:

"ghozi alkatiri" ghozialkatiri

misalkan datanya di range A1:C5 maka formulanya

=COUNT(IF(--RIGHT(A1:C5;2)=50;1))

gunakan formula array dengan tekan Enter sambil menahan Ctrl shift
wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Sen, 13/2/17, Imam Sinurat sin.ur4t@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] Countif yang Kriterianya Sebagian dari Isi Sel
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Senin, 13 Februari, 2017, 3:16 AM

Yth. Para Admin dan rekan2… mohon bantuan
formula dan/atau
sintax vbe-nya.307964340450271563768163458672456250651950364Pertanyaan
:Dari
range
data tersebut, berapa banyakkah sel
yang
"dua digit terakhirnya"
bernilai 50??Terima
kasihSinurat

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

#yiv3124596912 #yiv3124596912ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3124596912 #yiv3124596912ygrp-mkp #yiv3124596912hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3124596912 #yiv3124596912ygrp-mkp #yiv3124596912ads {
margin-bottom:10px;}

#yiv3124596912 #yiv3124596912ygrp-mkp .yiv3124596912ad {
padding:0 0;}

#yiv3124596912 #yiv3124596912ygrp-mkp .yiv3124596912ad p {
margin:0;}

#yiv3124596912 #yiv3124596912ygrp-mkp .yiv3124596912ad a {
color:#0000ff;text-decoration:none;}
#yiv3124596912 #yiv3124596912ygrp-sponsor
#yiv3124596912ygrp-lc {
font-family:Arial;}

#yiv3124596912 #yiv3124596912ygrp-sponsor
#yiv3124596912ygrp-lc #yiv3124596912hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3124596912 #yiv3124596912ygrp-sponsor
#yiv3124596912ygrp-lc .yiv3124596912ad {
margin-bottom:10px;padding:0 0;}

#yiv3124596912 #yiv3124596912actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv3124596912 #yiv3124596912activity span {
font-weight:700;}

#yiv3124596912 #yiv3124596912activity span:first-child {
text-transform:uppercase;}

#yiv3124596912 #yiv3124596912activity span a {
color:#5085b6;text-decoration:none;}

#yiv3124596912 #yiv3124596912activity span span {
color:#ff7900;}

#yiv3124596912 #yiv3124596912activity span
.yiv3124596912underline {
text-decoration:underline;}

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

#yiv3124596912 .yiv3124596912attach div a {
text-decoration:none;}

#yiv3124596912 .yiv3124596912attach img {
border:none;padding-right:5px;}

#yiv3124596912 .yiv3124596912attach label {
display:block;margin-bottom:5px;}

#yiv3124596912 .yiv3124596912attach label a {
text-decoration:none;}

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

#yiv3124596912 .yiv3124596912bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3124596912 .yiv3124596912bold a {
text-decoration:none;}

#yiv3124596912 dd.yiv3124596912last p a {
font-family:Verdana;font-weight:700;}

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

#yiv3124596912 dd.yiv3124596912last p
span.yiv3124596912yshortcuts {
margin-right:0;}

#yiv3124596912 div.yiv3124596912attach-table div div a {
text-decoration:none;}

#yiv3124596912 div.yiv3124596912attach-table {
width:400px;}

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

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

#yiv3124596912 div#yiv3124596912ygrp-mlmsg
#yiv3124596912ygrp-msg p a span.yiv3124596912yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3124596912 .yiv3124596912green {
color:#628c2a;}

#yiv3124596912 .yiv3124596912MsoNormal {
margin:0 0 0 0;}

#yiv3124596912 o {
font-size:0;}

#yiv3124596912 #yiv3124596912photos div {
float:left;width:72px;}

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

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

#yiv3124596912 #yiv3124596912reco-category {
font-size:77%;}

#yiv3124596912 #yiv3124596912reco-desc {
font-size:77%;}

#yiv3124596912 .yiv3124596912replbq {
margin:4px;}

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

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

#yiv3124596912 #yiv3124596912ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv3124596912 #yiv3124596912ygrp-mlmsg pre, #yiv3124596912
code {
font:115% monospace;}

#yiv3124596912 #yiv3124596912ygrp-mlmsg * {
line-height:1.22em;}

#yiv3124596912 #yiv3124596912ygrp-mlmsg #yiv3124596912logo {
padding-bottom:10px;}

#yiv3124596912 #yiv3124596912ygrp-msg p a {
font-family:Verdana;}

#yiv3124596912 #yiv3124596912ygrp-msg
p#yiv3124596912attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3124596912 #yiv3124596912ygrp-reco
#yiv3124596912reco-head {
color:#ff7900;font-weight:700;}

#yiv3124596912 #yiv3124596912ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3124596912 #yiv3124596912ygrp-sponsor #yiv3124596912ov
li a {
font-size:130%;text-decoration:none;}

#yiv3124596912 #yiv3124596912ygrp-sponsor #yiv3124596912ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3124596912 #yiv3124596912ygrp-sponsor #yiv3124596912ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3124596912 #yiv3124596912ygrp-text {
font-family:Georgia;}

#yiv3124596912 #yiv3124596912ygrp-text p {
margin:0 0 1em 0;}

#yiv3124596912 #yiv3124596912ygrp-text tt {
font-size:120%;}

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

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

5 Menyembunyikan kolom berdasarkan angka tertentu

Sun Feb 12, 2017 6:10 pm (PST) . Posted by:

"farud oke"

Assalamualaikum master excel...
Mohon bantuannya...
Bagaimana caranya menyembunyikan kolom berdasarkan kriteria/angka
tertentu,untuk lebih jelasnya bisa dilihat di filenya
Atas bantuannya saya sampaikan terimakasih

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

6a

Bls: [belajar-excel] Hasil Kalkulasinya Pada User Form Beda

Sun Feb 12, 2017 6:11 pm (PST) . Posted by:

"Harry" hariansyahptk

Dear Be Exceller,
Assalamu'alaikum...
Mohon di bantu pencerahannya akan pertanyaan sy ya.Terima kasih.

Wassalam...

Pada Jumat, 10 Februari 2017 6:24, "Harry hariansyahptk@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear Mr. Kid,
Terima kasih atas pencerahannya.Mengenai Regional Setting sudah sy kondisikan dengan format English (United States), namun hasil kalkulasinya masih salah (sebagai mana lampiran sebelumnya).
Tetapi jika dikondisikan dengan format Indonesian (Indonesia), justru makin error.Sebagai info tambahan, pada PC dimaksud juga ada program yang registered yang format tanggalnya adalah : dd/MM/yyyy.
Jika format tanggalnya sy ganti dengan MM/dd/yyyy, maka program yang registered tersebut yang menjadi error.
Mohon pencerahannya.
Terima kasih & Wassalamu'alaikum Wr. Wb.

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

wa'alaikumussalam wr wb

Hai Harry,

Jika Anda menggunakan VBA, JANGAN pernah mengabaikan regional setting komputer user yang akan menggunakannya. Setiap script yang berhubungan dengan format number maupun date HARUS memperhatikan hal ini.

Wassalamu'alaikum wr wb
Kid

2017-02-06 11:47 GMT+07:00 Harry hariansyahptk@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

Dear Be-Exceller,
Assalamu'alaikum Wr. Wb.
Sy mengoperasikan Workbook yang telah sy buat di Windows 7 64 bit. Namun jika Workbook tersebut sy gunakan pada Windows 32 bit, hasil Kalkulasi pada User Form-nya beda.
Apakah kesalahannya pada Windownya atau ada sesuatu yang belum sy mengerti.Terlampir User Form yang hasilnya beda.
Mohon informasi dan pencerahan dari sahabat-sahabat Be-Exceller sekalian.
Terima kasih & Wassalam...

#yiv6587899287 #yiv6587899287 -- #yiv6587899287ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6587899287 #yiv6587899287ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6587899287 #yiv6587899287ygrp-mkp #yiv6587899287hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6587899287 #yiv6587899287ygrp-mkp #yiv6587899287ads {margin-bottom:10px;}#yiv6587899287 #yiv6587899287ygrp-mkp .yiv6587899287ad {padding:0 0;}#yiv6587899287 #yiv6587899287ygrp-mkp .yiv6587899287ad p {margin:0;}#yiv6587899287 #yiv6587899287ygrp-mkp .yiv6587899287ad a {color:#0000ff;text-decoration:none;}#yiv6587899287 #yiv6587899287ygrp-sponsor #yiv6587899287ygrp-lc {font-family:Arial;}#yiv6587899287 #yiv6587899287ygrp-sponsor #yiv6587899287ygrp-lc #yiv6587899287hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6587899287 #yiv6587899287ygrp-sponsor #yiv6587899287ygrp-lc .yiv6587899287ad {margin-bottom:10px;padding:0 0;}#yiv6587899287 #yiv6587899287actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6587899287 #yiv6587899287activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6587899287 #yiv6587899287activity span {font-weight:700;}#yiv6587899287 #yiv6587899287activity span:first-child {text-transform:uppercase;}#yiv6587899287 #yiv6587899287activity span a {color:#5085b6;text-decoration:none;}#yiv6587899287 #yiv6587899287activity span span {color:#ff7900;}#yiv6587899287 #yiv6587899287activity span .yiv6587899287underline {text-decoration:underline;}#yiv6587899287 .yiv6587899287attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6587899287 .yiv6587899287attach div a {text-decoration:none;}#yiv6587899287 .yiv6587899287attach img {border:none;padding-right:5px;}#yiv6587899287 .yiv6587899287attach label {display:block;margin-bottom:5px;}#yiv6587899287 .yiv6587899287attach label a {text-decoration:none;}#yiv6587899287 blockquote {margin:0 0 0 4px;}#yiv6587899287 .yiv6587899287bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6587899287 .yiv6587899287bold a {text-decoration:none;}#yiv6587899287 dd.yiv6587899287last p a {font-family:Verdana;font-weight:700;}#yiv6587899287 dd.yiv6587899287last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6587899287 dd.yiv6587899287last p span.yiv6587899287yshortcuts {margin-right:0;}#yiv6587899287 div.yiv6587899287attach-table div div a {text-decoration:none;}#yiv6587899287 div.yiv6587899287attach-table {width:400px;}#yiv6587899287 div.yiv6587899287file-title a, #yiv6587899287 div.yiv6587899287file-title a:active, #yiv6587899287 div.yiv6587899287file-title a:hover, #yiv6587899287 div.yiv6587899287file-title a:visited {text-decoration:none;}#yiv6587899287 div.yiv6587899287photo-title a, #yiv6587899287 div.yiv6587899287photo-title a:active, #yiv6587899287 div.yiv6587899287photo-title a:hover, #yiv6587899287 div.yiv6587899287photo-title a:visited {text-decoration:none;}#yiv6587899287 div#yiv6587899287ygrp-mlmsg #yiv6587899287ygrp-msg p a span.yiv6587899287yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6587899287 .yiv6587899287green {color:#628c2a;}#yiv6587899287 .yiv6587899287MsoNormal {margin:0 0 0 0;}#yiv6587899287 o {font-size:0;}#yiv6587899287 #yiv6587899287photos div {float:left;width:72px;}#yiv6587899287 #yiv6587899287photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6587899287 #yiv6587899287photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6587899287 #yiv6587899287reco-category {font-size:77%;}#yiv6587899287 #yiv6587899287reco-desc {font-size:77%;}#yiv6587899287 .yiv6587899287replbq {margin:4px;}#yiv6587899287 #yiv6587899287ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6587899287 #yiv6587899287ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6587899287 #yiv6587899287ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6587899287 #yiv6587899287ygrp-mlmsg select, #yiv6587899287 input, #yiv6587899287 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6587899287 #yiv6587899287ygrp-mlmsg pre, #yiv6587899287 code {font:115% monospace;}#yiv6587899287 #yiv6587899287ygrp-mlmsg * {line-height:1.22em;}#yiv6587899287 #yiv6587899287ygrp-mlmsg #yiv6587899287logo {padding-bottom:10px;}#yiv6587899287 #yiv6587899287ygrp-msg p a {font-family:Verdana;}#yiv6587899287 #yiv6587899287ygrp-msg p#yiv6587899287attach-count span {color:#1E66AE;font-weight:700;}#yiv6587899287 #yiv6587899287ygrp-reco #yiv6587899287reco-head {color:#ff7900;font-weight:700;}#yiv6587899287 #yiv6587899287ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6587899287 #yiv6587899287ygrp-sponsor #yiv6587899287ov li a {font-size:130%;text-decoration:none;}#yiv6587899287 #yiv6587899287ygrp-sponsor #yiv6587899287ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6587899287 #yiv6587899287ygrp-sponsor #yiv6587899287ov ul {margin:0;padding:0 0 0 8px;}#yiv6587899287 #yiv6587899287ygrp-text {font-family:Georgia;}#yiv6587899287 #yiv6587899287ygrp-text p {margin:0 0 1em 0;}#yiv6587899287 #yiv6587899287ygrp-text tt {font-size:120%;}#yiv6587899287 #yiv6587899287ygrp-vital ul li:last-child {border-right:none !important;}#yiv6587899287

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

7a

Re: memilih nilai pada sheet tertentu [1 Attachment]

Sun Feb 12, 2017 6:17 pm (PST) . Posted by:

"Muhammad Arizal"

mungkin pakai sumifs

2017-02-11 12:05 GMT+07:00 Cety Carmelo Julita cetycarmelo@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Selamat siang para suhu, saya punya masalah formula excel seperti pada
> lampiran. Mohon bantuannya. Makasih
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . 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

Minggu, 12 Februari 2017

8 Messages

Messages

1

Sat Feb 11, 2017 11:32 pm (PST) . Posted by:

2

Sun Feb 12, 2017 1:16 am (PST) . Posted by:

3a

Sun Feb 12, 2017 12:22 pm (PST) . Posted by:

3b

Sun Feb 12, 2017 3:24 pm (PST) . Posted by:

4

Sun Feb 12, 2017 3:33 pm (PST) . Posted by:

5

Sun Feb 12, 2017 6:10 pm (PST) . Posted by:

6a

Sun Feb 12, 2017 6:11 pm (PST) . Posted by:

7a

Sun Feb 12, 2017 6:17 pm (PST) . Posted by:

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me