[belajar-excel] Digest Number 4243

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4243

1a

Re: Bls: Re: [belajar-excel] Rumus mencari pembagian SHU per anggota by "hendrik karnadi" hendrikkarnadi

2a

Bls: [belajar-excel] Hapus baris terpilih dengan 1 kriteria mengguna by "Toby kenzo" tobykenzo

Messages

1a

Re: Bls: Re: [belajar-excel] Rumus mencari pembagian SHU per anggota

Sat Jul 22, 2017 7:24 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Sama2 Ruswanto.Dalam penulisan/copy formula memang kita harus ber-hati2 krn formula bersifat "struktural", namun kadang2 kita lupa menaruh tanda "$" (F4) sebelum mengcopy.
Salam,HK

Sent from Yahoo Mail on Android

On Sat, Jul 22, 2017 at 22:11, rwanto78@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  
Selamat malam om HK

Terimakasih banyak om HK atas jawabannya..sesuai yg diharapkan.

Salam hormat,
Ruswanto
Powered by Telkomsel BlackBerry®From: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>Sender: belajar-excel@yahoogroups.comDate: Sat, 22 Jul 2017 14:33:10 +0000 (UTC)To: rwanto78@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com>ReplyTo: belajar-excel@yahoogroups.comSubject: Re: [belajar-excel] Rumus mencari pembagian SHU per anggota
 

Hai Ruswanto,
Coba ketik formula :=F6/SUM($F$6:$F$51)*55000000 pada sel H6 lalu copy ke bawah.

Salam,HK

On Saturday, July 22, 2017, 6:25:50 PM GMT+7, rwanto78@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 
Kepada yth
Rekan rekan dan master
Di group belajar excel

Assalamualaikum,
Saya mohon bantuannya kepada rekan rekan dan master, bagaimana rumusnya untuk menghitung pembagian shu sesuai jumlah bulan kepesertaan anggota, adapun penjelasannya ada di file yg sy lampirkan.
Atas bantuannya saya ucapkan banyak terimakasih.

Wassalam
Ruswanto
Powered by Telkomsel BlackBerry®
#yiv1927953897 #yiv1927953897 -- #yiv1927953897ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1927953897 #yiv1927953897ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1927953897 #yiv1927953897ygrp-mkp #yiv1927953897hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1927953897 #yiv1927953897ygrp-mkp #yiv1927953897ads {margin-bottom:10px;}#yiv1927953897 #yiv1927953897ygrp-mkp .yiv1927953897ad {padding:0 0;}#yiv1927953897 #yiv1927953897ygrp-mkp .yiv1927953897ad p {margin:0;}#yiv1927953897 #yiv1927953897ygrp-mkp .yiv1927953897ad a {color:#0000ff;text-decoration:none;}#yiv1927953897 #yiv1927953897ygrp-sponsor #yiv1927953897ygrp-lc {font-family:Arial;}#yiv1927953897 #yiv1927953897ygrp-sponsor #yiv1927953897ygrp-lc #yiv1927953897hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1927953897 #yiv1927953897ygrp-sponsor #yiv1927953897ygrp-lc .yiv1927953897ad {margin-bottom:10px;padding:0 0;}#yiv1927953897 #yiv1927953897actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1927953897 #yiv1927953897activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1927953897 #yiv1927953897activity span {font-weight:700;}#yiv1927953897 #yiv1927953897activity span:first-child {text-transform:uppercase;}#yiv1927953897 #yiv1927953897activity span a {color:#5085b6;text-decoration:none;}#yiv1927953897 #yiv1927953897activity span span {color:#ff7900;}#yiv1927953897 #yiv1927953897activity span .yiv1927953897underline {text-decoration:underline;}#yiv1927953897 .yiv1927953897attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1927953897 .yiv1927953897attach div a {text-decoration:none;}#yiv1927953897 .yiv1927953897attach img {border:none;padding-right:5px;}#yiv1927953897 .yiv1927953897attach label {display:block;margin-bottom:5px;}#yiv1927953897 .yiv1927953897attach label a {text-decoration:none;}#yiv1927953897 blockquote {margin:0 0 0 4px;}#yiv1927953897 .yiv1927953897bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1927953897 .yiv1927953897bold a {text-decoration:none;}#yiv1927953897 dd.yiv1927953897last p a {font-family:Verdana;font-weight:700;}#yiv1927953897 dd.yiv1927953897last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1927953897 dd.yiv1927953897last p span.yiv1927953897yshortcuts {margin-right:0;}#yiv1927953897 div.yiv1927953897attach-table div div a {text-decoration:none;}#yiv1927953897 div.yiv1927953897attach-table {width:400px;}#yiv1927953897 div.yiv1927953897file-title a, #yiv1927953897 div.yiv1927953897file-title a:active, #yiv1927953897 div.yiv1927953897file-title a:hover, #yiv1927953897 div.yiv1927953897file-title a:visited {text-decoration:none;}#yiv1927953897 div.yiv1927953897photo-title a, #yiv1927953897 div.yiv1927953897photo-title a:active, #yiv1927953897 div.yiv1927953897photo-title a:hover, #yiv1927953897 div.yiv1927953897photo-title a:visited {text-decoration:none;}#yiv1927953897 div#yiv1927953897ygrp-mlmsg #yiv1927953897ygrp-msg p a span.yiv1927953897yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1927953897 .yiv1927953897green {color:#628c2a;}#yiv1927953897 .yiv1927953897MsoNormal {margin:0 0 0 0;}#yiv1927953897 o {font-size:0;}#yiv1927953897 #yiv1927953897photos div {float:left;width:72px;}#yiv1927953897 #yiv1927953897photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1927953897 #yiv1927953897photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1927953897 #yiv1927953897reco-category {font-size:77%;}#yiv1927953897 #yiv1927953897reco-desc {font-size:77%;}#yiv1927953897 .yiv1927953897replbq {margin:4px;}#yiv1927953897 #yiv1927953897ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1927953897 #yiv1927953897ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1927953897 #yiv1927953897ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1927953897 #yiv1927953897ygrp-mlmsg select, #yiv1927953897 input, #yiv1927953897 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1927953897 #yiv1927953897ygrp-mlmsg pre, #yiv1927953897 code {font:115% monospace;}#yiv1927953897 #yiv1927953897ygrp-mlmsg * {line-height:1.22em;}#yiv1927953897 #yiv1927953897ygrp-mlmsg #yiv1927953897logo {padding-bottom:10px;}#yiv1927953897 #yiv1927953897ygrp-msg p a {font-family:Verdana;}#yiv1927953897 #yiv1927953897ygrp-msg p#yiv1927953897attach-count span {color:#1E66AE;font-weight:700;}#yiv1927953897 #yiv1927953897ygrp-reco #yiv1927953897reco-head {color:#ff7900;font-weight:700;}#yiv1927953897 #yiv1927953897ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1927953897 #yiv1927953897ygrp-sponsor #yiv1927953897ov li a {font-size:130%;text-decoration:none;}#yiv1927953897 #yiv1927953897ygrp-sponsor #yiv1927953897ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1927953897 #yiv1927953897ygrp-sponsor #yiv1927953897ov ul {margin:0;padding:0 0 0 8px;}#yiv1927953897 #yiv1927953897ygrp-text {font-family:Georgia;}#yiv1927953897 #yiv1927953897ygrp-text p {margin:0 0 1em 0;}#yiv1927953897 #yiv1927953897ygrp-text tt {font-size:120%;}#yiv1927953897 #yiv1927953897ygrp-vital ul li:last-child {border-right:none !important;}#yiv1927953897

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

2a

Bls: [belajar-excel] Hapus baris terpilih dengan 1 kriteria mengguna

Sat Jul 22, 2017 10:06 pm (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Danny,
Mungkin file ini bisa membantu.
TerimaKasih

Pada Sabtu, 22 Juli 2017 0:16, "Danny Prasetyo aydprasetyo@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Kode vba yang saya edit kok malah error yaa, dan proses nya berbelit2, karna saya harus mengkonversi value dari combobox dulu ke dalam cell, dan dari cell dimasukkan ke dalam textbox. 
Tolong dibantu yaa para master, agar tidak error dan proses nya tidak berbelit hehehe...
Ini saya kirimkan file nya.Terima kasih sebelumnya...  #yiv7958006126 #yiv7958006126 -- #yiv7958006126ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7958006126 #yiv7958006126ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7958006126 #yiv7958006126ygrp-mkp #yiv7958006126hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7958006126 #yiv7958006126ygrp-mkp #yiv7958006126ads {margin-bottom:10px;}#yiv7958006126 #yiv7958006126ygrp-mkp .yiv7958006126ad {padding:0 0;}#yiv7958006126 #yiv7958006126ygrp-mkp .yiv7958006126ad p {margin:0;}#yiv7958006126 #yiv7958006126ygrp-mkp .yiv7958006126ad a {color:#0000ff;text-decoration:none;}#yiv7958006126 #yiv7958006126ygrp-sponsor #yiv7958006126ygrp-lc {font-family:Arial;}#yiv7958006126 #yiv7958006126ygrp-sponsor #yiv7958006126ygrp-lc #yiv7958006126hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7958006126 #yiv7958006126ygrp-sponsor #yiv7958006126ygrp-lc .yiv7958006126ad {margin-bottom:10px;padding:0 0;}#yiv7958006126 #yiv7958006126actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7958006126 #yiv7958006126activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7958006126 #yiv7958006126activity span {font-weight:700;}#yiv7958006126 #yiv7958006126activity span:first-child {text-transform:uppercase;}#yiv7958006126 #yiv7958006126activity span a {color:#5085b6;text-decoration:none;}#yiv7958006126 #yiv7958006126activity span span {color:#ff7900;}#yiv7958006126 #yiv7958006126activity span .yiv7958006126underline {text-decoration:underline;}#yiv7958006126 .yiv7958006126attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7958006126 .yiv7958006126attach div a {text-decoration:none;}#yiv7958006126 .yiv7958006126attach img {border:none;padding-right:5px;}#yiv7958006126 .yiv7958006126attach label {display:block;margin-bottom:5px;}#yiv7958006126 .yiv7958006126attach label a {text-decoration:none;}#yiv7958006126 blockquote {margin:0 0 0 4px;}#yiv7958006126 .yiv7958006126bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7958006126 .yiv7958006126bold a {text-decoration:none;}#yiv7958006126 dd.yiv7958006126last p a {font-family:Verdana;font-weight:700;}#yiv7958006126 dd.yiv7958006126last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7958006126 dd.yiv7958006126last p span.yiv7958006126yshortcuts {margin-right:0;}#yiv7958006126 div.yiv7958006126attach-table div div a {text-decoration:none;}#yiv7958006126 div.yiv7958006126attach-table {width:400px;}#yiv7958006126 div.yiv7958006126file-title a, #yiv7958006126 div.yiv7958006126file-title a:active, #yiv7958006126 div.yiv7958006126file-title a:hover, #yiv7958006126 div.yiv7958006126file-title a:visited {text-decoration:none;}#yiv7958006126 div.yiv7958006126photo-title a, #yiv7958006126 div.yiv7958006126photo-title a:active, #yiv7958006126 div.yiv7958006126photo-title a:hover, #yiv7958006126 div.yiv7958006126photo-title a:visited {text-decoration:none;}#yiv7958006126 div#yiv7958006126ygrp-mlmsg #yiv7958006126ygrp-msg p a span.yiv7958006126yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7958006126 .yiv7958006126green {color:#628c2a;}#yiv7958006126 .yiv7958006126MsoNormal {margin:0 0 0 0;}#yiv7958006126 o {font-size:0;}#yiv7958006126 #yiv7958006126photos div {float:left;width:72px;}#yiv7958006126 #yiv7958006126photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7958006126 #yiv7958006126photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7958006126 #yiv7958006126reco-category {font-size:77%;}#yiv7958006126 #yiv7958006126reco-desc {font-size:77%;}#yiv7958006126 .yiv7958006126replbq {margin:4px;}#yiv7958006126 #yiv7958006126ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7958006126 #yiv7958006126ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7958006126 #yiv7958006126ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7958006126 #yiv7958006126ygrp-mlmsg select, #yiv7958006126 input, #yiv7958006126 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7958006126 #yiv7958006126ygrp-mlmsg pre, #yiv7958006126 code {font:115% monospace;}#yiv7958006126 #yiv7958006126ygrp-mlmsg * {line-height:1.22em;}#yiv7958006126 #yiv7958006126ygrp-mlmsg #yiv7958006126logo {padding-bottom:10px;}#yiv7958006126 #yiv7958006126ygrp-msg p a {font-family:Verdana;}#yiv7958006126 #yiv7958006126ygrp-msg p#yiv7958006126attach-count span {color:#1E66AE;font-weight:700;}#yiv7958006126 #yiv7958006126ygrp-reco #yiv7958006126reco-head {color:#ff7900;font-weight:700;}#yiv7958006126 #yiv7958006126ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7958006126 #yiv7958006126ygrp-sponsor #yiv7958006126ov li a {font-size:130%;text-decoration:none;}#yiv7958006126 #yiv7958006126ygrp-sponsor #yiv7958006126ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7958006126 #yiv7958006126ygrp-sponsor #yiv7958006126ov ul {margin:0;padding:0 0 0 8px;}#yiv7958006126 #yiv7958006126ygrp-text {font-family:Georgia;}#yiv7958006126 #yiv7958006126ygrp-text p {margin:0 0 1em 0;}#yiv7958006126 #yiv7958006126ygrp-text tt {font-size:120%;}#yiv7958006126 #yiv7958006126ygrp-vital ul li:last-child {border-right:none !important;}#yiv7958006126

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

• Privacy • Unsubscribe • Terms of Use