Rabu, 16 Desember 2015

[belajar-excel] Digest Number 3685

5 Messages

Digest #3685

Messages

Tue Dec 15, 2015 3:10 am (PST) . Posted by:

"odong nando"

yoo andreas,
bisa pelajari di coretan mr. kid di sini.
dan untuk kasus anda bisa diliat solusi yang pake banyak kolom bantu, klo ga mau pake kolom bantu itu bisa di masukin keformula yang ada di "total kode jaminan". br,

odong nando


Pada Selasa, 15 Desember 2015 11:39, "Andreas And andreas.and.q4@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Para Master Be-Exceller,Mohon bantuan dari para master untuk kasus excel berikut. Mencari nilai yang mana hasilnya lebih dari 1 record.Mohon bantuannya.Salam,
Andreas #yiv0283087061 #yiv0283087061 -- #yiv0283087061ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0283087061 #yiv0283087061ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0283087061 #yiv0283087061ygrp-mkp #yiv0283087061hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0283087061 #yiv0283087061ygrp-mkp #yiv0283087061ads {margin-bottom:10px;}#yiv0283087061 #yiv0283087061ygrp-mkp .yiv0283087061ad {padding:0 0;}#yiv0283087061 #yiv0283087061ygrp-mkp .yiv0283087061ad p {margin:0;}#yiv0283087061 #yiv0283087061ygrp-mkp .yiv0283087061ad a {color:#0000ff;text-decoration:none;}#yiv0283087061 #yiv0283087061ygrp-sponsor #yiv0283087061ygrp-lc {font-family:Arial;}#yiv0283087061 #yiv0283087061ygrp-sponsor #yiv0283087061ygrp-lc #yiv0283087061hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0283087061 #yiv0283087061ygrp-sponsor #yiv0283087061ygrp-lc .yiv0283087061ad {margin-bottom:10px;padding:0 0;}#yiv0283087061 #yiv0283087061actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0283087061 #yiv0283087061activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0283087061 #yiv0283087061activity span {font-weight:700;}#yiv0283087061 #yiv0283087061activity span:first-child {text-transform:uppercase;}#yiv0283087061 #yiv0283087061activity span a {color:#5085b6;text-decoration:none;}#yiv0283087061 #yiv0283087061activity span span {color:#ff7900;}#yiv0283087061 #yiv0283087061activity span .yiv0283087061underline {text-decoration:underline;}#yiv0283087061 .yiv0283087061attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0283087061 .yiv0283087061attach div a {text-decoration:none;}#yiv0283087061 .yiv0283087061attach img {border:none;padding-right:5px;}#yiv0283087061 .yiv0283087061attach label {display:block;margin-bottom:5px;}#yiv0283087061 .yiv0283087061attach label a {text-decoration:none;}#yiv0283087061 blockquote {margin:0 0 0 4px;}#yiv0283087061 .yiv0283087061bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0283087061 .yiv0283087061bold a {text-decoration:none;}#yiv0283087061 dd.yiv0283087061last p a {font-family:Verdana;font-weight:700;}#yiv0283087061 dd.yiv0283087061last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0283087061 dd.yiv0283087061last p span.yiv0283087061yshortcuts {margin-right:0;}#yiv0283087061 div.yiv0283087061attach-table div div a {text-decoration:none;}#yiv0283087061 div.yiv0283087061attach-table {width:400px;}#yiv0283087061 div.yiv0283087061file-title a, #yiv0283087061 div.yiv0283087061file-title a:active, #yiv0283087061 div.yiv0283087061file-title a:hover, #yiv0283087061 div.yiv0283087061file-title a:visited {text-decoration:none;}#yiv0283087061 div.yiv0283087061photo-title a, #yiv0283087061 div.yiv0283087061photo-title a:active, #yiv0283087061 div.yiv0283087061photo-title a:hover, #yiv0283087061 div.yiv0283087061photo-title a:visited {text-decoration:none;}#yiv0283087061 div#yiv0283087061ygrp-mlmsg #yiv0283087061ygrp-msg p a span.yiv0283087061yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0283087061 .yiv0283087061green {color:#628c2a;}#yiv0283087061 .yiv0283087061MsoNormal {margin:0 0 0 0;}#yiv0283087061 o {font-size:0;}#yiv0283087061 #yiv0283087061photos div {float:left;width:72px;}#yiv0283087061 #yiv0283087061photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0283087061 #yiv0283087061photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0283087061 #yiv0283087061reco-category {font-size:77%;}#yiv0283087061 #yiv0283087061reco-desc {font-size:77%;}#yiv0283087061 .yiv0283087061replbq {margin:4px;}#yiv0283087061 #yiv0283087061ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0283087061 #yiv0283087061ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0283087061 #yiv0283087061ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0283087061 #yiv0283087061ygrp-mlmsg select, #yiv0283087061 input, #yiv0283087061 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0283087061 #yiv0283087061ygrp-mlmsg pre, #yiv0283087061 code {font:115% monospace;}#yiv0283087061 #yiv0283087061ygrp-mlmsg * {line-height:1.22em;}#yiv0283087061 #yiv0283087061ygrp-mlmsg #yiv0283087061logo {padding-bottom:10px;}#yiv0283087061 #yiv0283087061ygrp-msg p a {font-family:Verdana;}#yiv0283087061 #yiv0283087061ygrp-msg p#yiv0283087061attach-count span {color:#1E66AE;font-weight:700;}#yiv0283087061 #yiv0283087061ygrp-reco #yiv0283087061reco-head {color:#ff7900;font-weight:700;}#yiv0283087061 #yiv0283087061ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0283087061 #yiv0283087061ygrp-sponsor #yiv0283087061ov li a {font-size:130%;text-decoration:none;}#yiv0283087061 #yiv0283087061ygrp-sponsor #yiv0283087061ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0283087061 #yiv0283087061ygrp-sponsor #yiv0283087061ov ul {margin:0;padding:0 0 0 8px;}#yiv0283087061 #yiv0283087061ygrp-text {font-family:Georgia;}#yiv0283087061 #yiv0283087061ygrp-text p {margin:0 0 1em 0;}#yiv0283087061 #yiv0283087061ygrp-text tt {font-size:120%;}#yiv0283087061 #yiv0283087061ygrp-vital ul li:last-child {border-right:none !important;}#yiv0283087061

Tue Dec 15, 2015 6:14 pm (PST) . Posted by:

"Lazuardi Biru" lazuardi_biru84

coba udf warisan ctv
difile nya lengkap dengan cara penggunaanya
ctv_UDF_RANGKAI

salam
lb

Pada Selasa, 15 Desember 2015 11:39, "Andreas And andreas.and.q4@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Para Master Be-Exceller,Mohon bantuan dari para master untuk kasus excel berikut. Mencari nilai yang mana hasilnya lebih dari 1 record.Mohon bantuannya.Salam,
Andreas #yiv7338973146 #yiv7338973146 -- #yiv7338973146ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7338973146 #yiv7338973146ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7338973146 #yiv7338973146ygrp-mkp #yiv7338973146hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7338973146 #yiv7338973146ygrp-mkp #yiv7338973146ads {margin-bottom:10px;}#yiv7338973146 #yiv7338973146ygrp-mkp .yiv7338973146ad {padding:0 0;}#yiv7338973146 #yiv7338973146ygrp-mkp .yiv7338973146ad p {margin:0;}#yiv7338973146 #yiv7338973146ygrp-mkp .yiv7338973146ad a {color:#0000ff;text-decoration:none;}#yiv7338973146 #yiv7338973146ygrp-sponsor #yiv7338973146ygrp-lc {font-family:Arial;}#yiv7338973146 #yiv7338973146ygrp-sponsor #yiv7338973146ygrp-lc #yiv7338973146hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7338973146 #yiv7338973146ygrp-sponsor #yiv7338973146ygrp-lc .yiv7338973146ad {margin-bottom:10px;padding:0 0;}#yiv7338973146 #yiv7338973146actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7338973146 #yiv7338973146activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7338973146 #yiv7338973146activity span {font-weight:700;}#yiv7338973146 #yiv7338973146activity span:first-child {text-transform:uppercase;}#yiv7338973146 #yiv7338973146activity span a {color:#5085b6;text-decoration:none;}#yiv7338973146 #yiv7338973146activity span span {color:#ff7900;}#yiv7338973146 #yiv7338973146activity span .yiv7338973146underline {text-decoration:underline;}#yiv7338973146 .yiv7338973146attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7338973146 .yiv7338973146attach div a {text-decoration:none;}#yiv7338973146 .yiv7338973146attach img {border:none;padding-right:5px;}#yiv7338973146 .yiv7338973146attach label {display:block;margin-bottom:5px;}#yiv7338973146 .yiv7338973146attach label a {text-decoration:none;}#yiv7338973146 blockquote {margin:0 0 0 4px;}#yiv7338973146 .yiv7338973146bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7338973146 .yiv7338973146bold a {text-decoration:none;}#yiv7338973146 dd.yiv7338973146last p a {font-family:Verdana;font-weight:700;}#yiv7338973146 dd.yiv7338973146last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7338973146 dd.yiv7338973146last p span.yiv7338973146yshortcuts {margin-right:0;}#yiv7338973146 div.yiv7338973146attach-table div div a {text-decoration:none;}#yiv7338973146 div.yiv7338973146attach-table {width:400px;}#yiv7338973146 div.yiv7338973146file-title a, #yiv7338973146 div.yiv7338973146file-title a:active, #yiv7338973146 div.yiv7338973146file-title a:hover, #yiv7338973146 div.yiv7338973146file-title a:visited {text-decoration:none;}#yiv7338973146 div.yiv7338973146photo-title a, #yiv7338973146 div.yiv7338973146photo-title a:active, #yiv7338973146 div.yiv7338973146photo-title a:hover, #yiv7338973146 div.yiv7338973146photo-title a:visited {text-decoration:none;}#yiv7338973146 div#yiv7338973146ygrp-mlmsg #yiv7338973146ygrp-msg p a span.yiv7338973146yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7338973146 .yiv7338973146green {color:#628c2a;}#yiv7338973146 .yiv7338973146MsoNormal {margin:0 0 0 0;}#yiv7338973146 o {font-size:0;}#yiv7338973146 #yiv7338973146photos div {float:left;width:72px;}#yiv7338973146 #yiv7338973146photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7338973146 #yiv7338973146photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7338973146 #yiv7338973146reco-category {font-size:77%;}#yiv7338973146 #yiv7338973146reco-desc {font-size:77%;}#yiv7338973146 .yiv7338973146replbq {margin:4px;}#yiv7338973146 #yiv7338973146ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7338973146 #yiv7338973146ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7338973146 #yiv7338973146ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7338973146 #yiv7338973146ygrp-mlmsg select, #yiv7338973146 input, #yiv7338973146 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7338973146 #yiv7338973146ygrp-mlmsg pre, #yiv7338973146 code {font:115% monospace;}#yiv7338973146 #yiv7338973146ygrp-mlmsg * {line-height:1.22em;}#yiv7338973146 #yiv7338973146ygrp-mlmsg #yiv7338973146logo {padding-bottom:10px;}#yiv7338973146 #yiv7338973146ygrp-msg p a {font-family:Verdana;}#yiv7338973146 #yiv7338973146ygrp-msg p#yiv7338973146attach-count span {color:#1E66AE;font-weight:700;}#yiv7338973146 #yiv7338973146ygrp-reco #yiv7338973146reco-head {color:#ff7900;font-weight:700;}#yiv7338973146 #yiv7338973146ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7338973146 #yiv7338973146ygrp-sponsor #yiv7338973146ov li a {font-size:130%;text-decoration:none;}#yiv7338973146 #yiv7338973146ygrp-sponsor #yiv7338973146ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7338973146 #yiv7338973146ygrp-sponsor #yiv7338973146ov ul {margin:0;padding:0 0 0 8px;}#yiv7338973146 #yiv7338973146ygrp-text {font-family:Georgia;}#yiv7338973146 #yiv7338973146ygrp-text p {margin:0 0 1em 0;}#yiv7338973146 #yiv7338973146ygrp-text tt {font-size:120%;}#yiv7338973146 #yiv7338973146ygrp-vital ul li:last-child {border-right:none !important;}#yiv7338973146

Tue Dec 15, 2015 6:31 pm (PST) . Posted by:

ryan_sacth

To: Andreas


Saya telah melihat file yang dilampirkan dan saya coba membantu dengan menggunakan "Pivot Tabel".
Fitur Pivot tabel sangat bermanfaat untuk men-short file data yang sama/ sejenis tergantung penampilan data yang di inginkan saja.


Terima Kasih.
Semoga membantu.
Salam.
Ryan.

Tue Dec 15, 2015 7:25 pm (PST) . Posted by:

"Heru Safrudin" superheruu

Yth. Be-exceller

Wassalamu'alaikum wr. Wb

Bagaimana cara script untuk mengeksplorasi Aplikasi MS-Acces, database dan
komponen VBA-nya mengguakan vba di excel. Soalnya file mdb saya terinfeksi
virus macro yg bernama MSysLunaticAccess. Saya belum tahu dampak yg
ditumbukan oleh virus macro tersebut, tapi yg jelas ketika file
database.mdb dibuka script berjalan dan menginfeksi semua file yg
berekstensi mdb setelah memodifikasi registry.

Jika script ditulis dari vba excel menurut saya lebih mudah karena script
tidak berjalan di vba excel.
Barangkali be-exceller berminat melumpuhkan virus macro dengan memodifikasi
virus macro yang saya maksud silakan lihat di lampiran
'Script_MSysLunaticAccess.bas

Mohon bantuannya

Terima kasih
Wassalam wr. Wb

Heru safrudin

Tue Dec 15, 2015 9:33 pm (PST) . Posted by:

"Widodo Budi"



Wa'alaikumsalam warahmatullah,
Banyak banget kegunaannya.

Fungsi array dalam excel bisa untuk :
1. Analisis Gauss-Jordan Elimination
2. Semi automatic sortir data
3. Kalkulus (pemecahan ODE, integral, iterasi, dll)
4. Numerical method for engineering
5. Enkripsi data
6. Banyak lagi terutama untuk aplikasi matrix

Wassalam,
Wid

> On Dec 14, 2015, at 21:02, "Heru Adi hr_adhi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>

> Assalamu'alaikum.
> Selamat sore rekan-rekan milis excel .
> Saya mau bertanya apakah fungsi dan kegunaan dari array dua dimensi / multidimensi ?
> Mohon diberi contoh studi kasus yang menggunakan konsep array dua dimensi / multidimensi ini.
> Sebelumnya saya ucapkan terimakasih kepada rekan-rekan atas jawabannya. Saya sangat ingin tahu contoh penerapan dari array dua dimensi / multidimensi ini.
>
> Rgds,
>
> Heru Adi S
> Dikirim dari Yahoo Mail pada Android
>
>
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar