[belajar-excel] Digest Number 4612

Milis Belajar Microsoft Excel Group

7 Messages

Digest #4612

1a

Re: menghilangkan data pd Grafik [1 Attachment] by idz.iman

2a

Re: Connection String untuk Excel 2013 [1 Attachment] by "hendrik karnadi" hendrikkarnadi

3a

Ranking by "Dede Sulaeman"

3b

Bls: [belajar-excel] Ranking [1 Attachment] by "odong nando"

3c

Re: Ranking [1 Attachment] by "Dede Sulaeman"

4a

Menghitung Jumlah No. KK by "Rian Sutarsa" riansutarsa

4b

Fw: [belajar-excel] Menghitung Jumlah No. KK by "hendrik karnadi" hendrikkarnadi

Messages

1a

Re: menghilangkan data pd Grafik [1 Attachment]

Sun Sep 30, 2018 11:08 pm (PDT) . Posted by:

idz.iman

Dear Pak Agus,

terima kasih banyak atas solusinya, sangat membantu


salam
Iman

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

2a

Re: Connection String untuk Excel 2013 [1 Attachment]

Mon Oct 1, 2018 1:47 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hahaha...ternyata VBE Sheet nya ga perlu diubah sama sekali.Yang harus diubah cuma extension nama2 file (dari extension .xls ke .xlsx) yang ada pada Sheet 1 File Consolidate, agar extension nama2 file tersebut sesuai dengan extension nama2 file sumber.
Salam,HK

On Monday, 1 October 2018, 12:11:40 PM GMT+7, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear Be Excel,Saya mempunyai file macros dalam folder Consolidated File - Excel 97_2003 (extract files terlampir) untuk menggabungkan beberapa files Excel 97_2003, dengan Connection String sbb :
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _            "Data Source=" & ThisWorkbook.FullName & ";" & _            "Extended Properties=""Excel 12.0 Xml;HDR=YES"";"
Jika file2 sumber (Budget.xls,Cash.xls, dstnya) ingin saya ubah ke versi Excel yang lebih tinggi, mis. Excel 2013 (.xlsx), apakah perlu dilakukan perubahan terhadap Connection String tsb dan atau Object Librarynya ?

Terima kasih.
Salam,HK

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

3a

Ranking

Mon Oct 1, 2018 1:49 am (PDT) . Posted by:

"Dede Sulaeman"

Dear Be-Exceler,

Mohon arahannya formula untuk kolom RANK.

Yang dirangking berdasar RBM.

File terlampir.

Salam,

DD

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

3b

Bls: [belajar-excel] Ranking [1 Attachment]

Mon Oct 1, 2018 3:25 am (PDT) . Posted by:

"odong nando"

 br,

odong nando

Dari: "'Dede Sulaeman' pmaho_ss9@pinusmerahabadi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 1 Oktober 2018 15:51
Judul: [belajar-excel] Ranking [1 Attachment]

  Dear Be-Exceler,  Mohon arahannya formula untuk kolom RANK..Yang dirangking berdasar RBM.File terlampir.  Salam,DD       #yiv3566652730 #yiv3566652730 -- #yiv3566652730ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3566652730 #yiv3566652730ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3566652730 #yiv3566652730ygrp-mkp #yiv3566652730hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3566652730 #yiv3566652730ygrp-mkp #yiv3566652730ads {margin-bottom:10px;}#yiv3566652730 #yiv3566652730ygrp-mkp .yiv3566652730ad {padding:0 0;}#yiv3566652730 #yiv3566652730ygrp-mkp .yiv3566652730ad p {margin:0;}#yiv3566652730 #yiv3566652730ygrp-mkp .yiv3566652730ad a {color:#0000ff;text-decoration:none;}#yiv3566652730 #yiv3566652730ygrp-sponsor #yiv3566652730ygrp-lc {font-family:Arial;}#yiv3566652730 #yiv3566652730ygrp-sponsor #yiv3566652730ygrp-lc #yiv3566652730hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3566652730 #yiv3566652730ygrp-sponsor #yiv3566652730ygrp-lc .yiv3566652730ad {margin-bottom:10px;padding:0 0;}#yiv3566652730 #yiv3566652730actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3566652730 #yiv3566652730activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3566652730 #yiv3566652730activity span {font-weight:700;}#yiv3566652730 #yiv3566652730activity span:first-child {text-transform:uppercase;}#yiv3566652730 #yiv3566652730activity span a {color:#5085b6;text-decoration:none;}#yiv3566652730 #yiv3566652730activity span span {color:#ff7900;}#yiv3566652730 #yiv3566652730activity span .yiv3566652730underline {text-decoration:underline;}#yiv3566652730 .yiv3566652730attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3566652730 .yiv3566652730attach div a {text-decoration:none;}#yiv3566652730 .yiv3566652730attach img {border:none;padding-right:5px;}#yiv3566652730 .yiv3566652730attach label {display:block;margin-bottom:5px;}#yiv3566652730 .yiv3566652730attach label a {text-decoration:none;}#yiv3566652730 blockquote {margin:0 0 0 4px;}#yiv3566652730 .yiv3566652730bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3566652730 .yiv3566652730bold a {text-decoration:none;}#yiv3566652730 dd.yiv3566652730last p a {font-family:Verdana;font-weight:700;}#yiv3566652730 dd.yiv3566652730last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3566652730 dd.yiv3566652730last p span.yiv3566652730yshortcuts {margin-right:0;}#yiv3566652730 div.yiv3566652730attach-table div div a {text-decoration:none;}#yiv3566652730 div.yiv3566652730attach-table {width:400px;}#yiv3566652730 div.yiv3566652730file-title a, #yiv3566652730 div.yiv3566652730file-title a:active, #yiv3566652730 div.yiv3566652730file-title a:hover, #yiv3566652730 div.yiv3566652730file-title a:visited {text-decoration:none;}#yiv3566652730 div.yiv3566652730photo-title a, #yiv3566652730 div.yiv3566652730photo-title a:active, #yiv3566652730 div.yiv3566652730photo-title a:hover, #yiv3566652730 div.yiv3566652730photo-title a:visited {text-decoration:none;}#yiv3566652730 div#yiv3566652730ygrp-mlmsg #yiv3566652730ygrp-msg p a span.yiv3566652730yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3566652730 .yiv3566652730green {color:#628c2a;}#yiv3566652730 .yiv3566652730MsoNormal {margin:0 0 0 0;}#yiv3566652730 o {font-size:0;}#yiv3566652730 #yiv3566652730photos div {float:left;width:72px;}#yiv3566652730 #yiv3566652730photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3566652730 #yiv3566652730photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3566652730 #yiv3566652730reco-category {font-size:77%;}#yiv3566652730 #yiv3566652730reco-desc {font-size:77%;}#yiv3566652730 .yiv3566652730replbq {margin:4px;}#yiv3566652730 #yiv3566652730ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3566652730 #yiv3566652730ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3566652730 #yiv3566652730ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3566652730 #yiv3566652730ygrp-mlmsg select, #yiv3566652730 input, #yiv3566652730 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3566652730 #yiv3566652730ygrp-mlmsg pre, #yiv3566652730 code {font:115% monospace;}#yiv3566652730 #yiv3566652730ygrp-mlmsg * {line-height:1.22em;}#yiv3566652730 #yiv3566652730ygrp-mlmsg #yiv3566652730logo {padding-bottom:10px;}#yiv3566652730 #yiv3566652730ygrp-msg p a {font-family:Verdana;}#yiv3566652730 #yiv3566652730ygrp-msg p#yiv3566652730attach-count span {color:#1E66AE;font-weight:700;}#yiv3566652730 #yiv3566652730ygrp-reco #yiv3566652730reco-head {color:#ff7900;font-weight:700;}#yiv3566652730 #yiv3566652730ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3566652730 #yiv3566652730ygrp-sponsor #yiv3566652730ov li a {font-size:130%;text-decoration:none;}#yiv3566652730 #yiv3566652730ygrp-sponsor #yiv3566652730ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3566652730 #yiv3566652730ygrp-sponsor #yiv3566652730ov ul {margin:0;padding:0 0 0 8px;}#yiv3566652730 #yiv3566652730ygrp-text {font-family:Georgia;}#yiv3566652730 #yiv3566652730ygrp-text p {margin:0 0 1em 0;}#yiv3566652730 #yiv3566652730ygrp-text tt {font-size:120%;}#yiv3566652730 #yiv3566652730ygrp-vital ul li:last-child {border-right:none !important;}#yiv3566652730

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

3c

Re: Ranking [1 Attachment]

Mon Oct 1, 2018 3:33 am (PDT) . Posted by:

"Dede Sulaeman"

Dear Mr Odong,

Terima kasih atas responnya, sangat membantu.

Case Closed.

Salam,

DD

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 1, 2018 5:26 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Ranking [1 Attachment]

br,

odong nando

_____

Dari: "'Dede Sulaeman' pmaho_ss9@pinusmerahabadi.co.id [belajar-excel]" <belajar-excel@yahoogroups.co m <mailto:belajar-excel@yahoogroups.co%20m> >
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 1 Oktober 2018 15:51
Judul: [belajar-excel] Ranking [1 Attachment]

Dear Be-Exceler,

Mohon arahannya formula untuk kolom RANK..

Yang dirangking berdasar RBM.

File terlampir.

Salam,

DD

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

4a

Menghitung Jumlah No. KK

Mon Oct 1, 2018 6:08 pm (PDT) . Posted by:

"Rian Sutarsa" riansutarsa

Assalamualaikum BeExceller..Mohon pencerahannya, saya hendak menghitung jumlah KK dengan kriteria salahsatu No. KK di deretan cell. Ketika saya hitung manual jumlah Countif yg saya gunakan tidak sesuai dengan kenyataannya
TerimakasihWassalamualaikum

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

4b

Fw: [belajar-excel] Menghitung Jumlah No. KK

Mon Oct 1, 2018 8:10 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Rian,Bisa dilampirkan dummy filenya beserta fungsi Countif yang sdh dibuat ?
Salam,HK

----- Forwarded message ----- From: Rian Sutarsa riansutarsa@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>Sent: Tuesday, 2 October 2018, 8:10:42 AM GMT+7Subject: [belajar-excel] Menghitung Jumlah No. KK
 
Assalamualaikum BeExceller..
Mohon pencerahannya, saya hendak menghitung jumlah KK dengan kriteria salahsatu No. KK di deretan cell. Ketika saya hitung manual jumlah Countif yg saya gunakan tidak sesuai dengan kenyataannya
TerimakasihWassalamualaikum

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 1

• Privacy • Unsubscribe • Terms of Use