Jumat, 29 Januari 2016

[belajar-excel] Digest Number 3737

10 Messages

Digest #3737
7
Nggak bisa close recordset by "Heru Safrudin" superheruu

Messages

Thu Jan 28, 2016 6:36 am (PST) . Posted by:

semenjana

Dear Mr. Kid

Terima kasih banyak Master Kid atas bantuannya yang teramat sangat.. sukses selalu :)

Thu Jan 28, 2016 6:28 pm (PST) . Posted by:

"Jack Carmelo"

Selamat pagi para master.



Saya punya data yang harus di ambil. Tapi karena datanya diambil berdasarkan data validasi list jdi saya bingung cara membuat formulanya. Mohon bantuannya.



Contoh kasus terlampir. Yang ditanyakan di sheet3 datanya harus sesuai dengan sheet2 cell D2. Sesuai dengan validasi data di cell A2.


Terima kasih atas bantuannya..


Salam
Jack Carmelo



Thu Jan 28, 2016 8:49 pm (PST) . Posted by:

"Toby kenzo" tobykenzo


Hai Jack,

Coba pake formula array IFERROR,INDEX,MATCH.
Di forum ini sudah sering di jelaskan penggunaan array fermula untuk kombinasi INDEX, MATCH.

TerimaKasih.

Pada Jum, 29/1/16, Jack Carmelo jackcarmelo7@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] Ambil data berdasarkan data validasi [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Jumat, 29 Januari, 2016, 9:00 AM


 









Selamat pagi para master.

Saya punya data
yang harus di ambil. Tapi
karena datanya diambil berdasarkan data validasi list jdi
saya bingung
cara membuat formulanya. Mohon bantuannya.

Contoh kasus terlampir. Yang ditanyakan di sheet3
datanya harus sesuai dengan  sheet2 cell D2. Sesuai dengan
validasi data di cell A2.

Terima kasih atas bantuannya..

Salam
Jack Carmelo











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

#yiv1688961367 #yiv1688961367ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367ads {
margin-bottom:10px;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad {
padding:0 0;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad p {
margin:0;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad a {
color:#0000ff;text-decoration:none;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc {
font-family:Arial;}

#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc #yiv1688961367hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc .yiv1688961367ad {
margin-bottom:10px;padding:0 0;}

#yiv1688961367 #yiv1688961367actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv1688961367 #yiv1688961367activity span {
font-weight:700;}

#yiv1688961367 #yiv1688961367activity span:first-child {
text-transform:uppercase;}

#yiv1688961367 #yiv1688961367activity span a {
color:#5085b6;text-decoration:none;}

#yiv1688961367 #yiv1688961367activity span span {
color:#ff7900;}

#yiv1688961367 #yiv1688961367activity span
.yiv1688961367underline {
text-decoration:underline;}

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

#yiv1688961367 .yiv1688961367attach div a {
text-decoration:none;}

#yiv1688961367 .yiv1688961367attach img {
border:none;padding-right:5px;}

#yiv1688961367 .yiv1688961367attach label {
display:block;margin-bottom:5px;}

#yiv1688961367 .yiv1688961367attach label a {
text-decoration:none;}

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

#yiv1688961367 .yiv1688961367bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1688961367 .yiv1688961367bold a {
text-decoration:none;}

#yiv1688961367 dd.yiv1688961367last p a {
font-family:Verdana;font-weight:700;}

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

#yiv1688961367 dd.yiv1688961367last p
span.yiv1688961367yshortcuts {
margin-right:0;}

#yiv1688961367 div.yiv1688961367attach-table div div a {
text-decoration:none;}

#yiv1688961367 div.yiv1688961367attach-table {
width:400px;}

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

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

#yiv1688961367 div#yiv1688961367ygrp-mlmsg
#yiv1688961367ygrp-msg p a span.yiv1688961367yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1688961367 .yiv1688961367green {
color:#628c2a;}

#yiv1688961367 .yiv1688961367MsoNormal {
margin:0 0 0 0;}

#yiv1688961367 o {
font-size:0;}

#yiv1688961367 #yiv1688961367photos div {
float:left;width:72px;}

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

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

#yiv1688961367 #yiv1688961367reco-category {
font-size:77%;}

#yiv1688961367 #yiv1688961367reco-desc {
font-size:77%;}

#yiv1688961367 .yiv1688961367replbq {
margin:4px;}

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

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

#yiv1688961367 #yiv1688961367ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv1688961367 #yiv1688961367ygrp-mlmsg pre, #yiv1688961367
code {
font:115% monospace;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg * {
line-height:1.22em;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg #yiv1688961367logo {
padding-bottom:10px;}


#yiv1688961367 #yiv1688961367ygrp-msg p a {
font-family:Verdana;}

#yiv1688961367 #yiv1688961367ygrp-msg
p#yiv1688961367attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1688961367 #yiv1688961367ygrp-reco
#yiv1688961367reco-head {
color:#ff7900;font-weight:700;}

#yiv1688961367 #yiv1688961367ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1688961367 #yiv1688961367ygrp-sponsor #yiv1688961367ov
li a {
font-size:130%;text-decoration:none;}

#yiv1688961367 #yiv1688961367ygrp-sponsor #yiv1688961367ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1688961367 #yiv1688961367ygrp-sponsor #yiv1688961367ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1688961367 #yiv1688961367ygrp-text {
font-family:Georgia;}

#yiv1688961367 #yiv1688961367ygrp-text p {
margin:0 0 1em 0;}

#yiv1688961367 #yiv1688961367ygrp-text tt {
font-size:120%;}

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

Thu Jan 28, 2016 10:03 pm (PST) . Posted by:

"Jack Carmelo"


Makasih bang toby atas bantuannya. Saya sudah coba kombinasikan tapi belum ketemu. Mohon bantuannya.
--
Salam
Jack Carmelo
Jumat, 29 Januari 2016, 01:49PM +0900 dari "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>:
Hai Jack,
Coba pake formula array  IFERROR,INDEX,MATCH.
Di forum ini sudah sering di jelaskan penggunaan array fermula untuk kombinasi INDEX, MATCH.
TerimaKasih.
Pada Jum, 29/1/16, Jack Carmelo  jackcarmelo7@gmail.com [belajar-excel] < belajar-excel@yahoogroups.com > menulis:
Judul: [belajar-excel] Ambil data berdasarkan data validasi [1 Attachment]
Kepada:  belajar-excel@yahoogroups.com
Tanggal: Jumat, 29 Januari, 2016, 9:00 AM
Selamat pagi para master.
Saya punya data
yang harus di ambil. Tapi
karena datanya diambil berdasarkan data validasi list jdi
saya bingung
cara membuat formulanya. Mohon bantuannya.
Contoh kasus terlampir. Yang ditanyakan di sheet3
datanya harus sesuai dengan  sheet2 cell D2. Sesuai dengan
validasi data di cell A2.
Terima kasih atas bantuannya..
Salam
Jack Carmelo
#yiv1688961367 #yiv1688961367 --
#yiv1688961367ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv1688961367 #yiv1688961367ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367ads {
margin-bottom:10px;}
#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad {
padding:0 0;}
#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad p {
margin:0;}
#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad a {
color:#0000ff;text-decoration:none;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc {
font-family:Arial;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc #yiv1688961367hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc .yiv1688961367ad {
margin-bottom:10px;padding:0 0;}
#yiv1688961367 #yiv1688961367actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv1688961367 #yiv1688961367activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv1688961367 #yiv1688961367activity span {
font-weight:700;}
#yiv1688961367 #yiv1688961367activity span:first-child {
text-transform:uppercase;}
#yiv1688961367 #yiv1688961367activity span a {
color:#5085b6;text-decoration:none;}
#yiv1688961367 #yiv1688961367activity span span {
color:#ff7900;}
#yiv1688961367 #yiv1688961367activity span
.yiv1688961367underline {
text-decoration:underline;}
#yiv1688961367 .yiv1688961367attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv1688961367 .yiv1688961367attach div a {
text-decoration:none;}
#yiv1688961367 .yiv1688961367attach img {
border:none;padding-right:5px;}
#yiv1688961367 .yiv1688961367attach label {
display:block;margin-bottom:5px;}
#yiv1688961367 .yiv1688961367attach label a {
text-decoration:none;}
#yiv1688961367 blockquote {
margin:0 0 0 4px;}
#yiv1688961367 .yiv1688961367bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv1688961367 .yiv1688961367bold a {
text-decoration:none;}
#yiv1688961367 dd.yiv1688961367last p a {
font-family:Verdana;font-weight:700;}
#yiv1688961367 dd.yiv1688961367last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv1688961367 dd.yiv1688961367last p
span.yiv1688961367yshortcuts {
margin-right:0;}
#yiv1688961367 div.yiv1688961367attach-table div div a {
text-decoration:none;}
#yiv1688961367 div.yiv1688961367attach-table {
width:400px;}
#yiv1688961367 div.yiv1688961367file-title a, #yiv1688961367
div.yiv1688961367file-title a:active, #yiv1688961367
div.yiv1688961367file-title a:hover, #yiv1688961367
div.yiv1688961367file-title a:visited {
text-decoration:none;}
#yiv1688961367 div.yiv1688961367photo-title a,
#yiv1688961367 div.yiv1688961367photo-title a:active,
#yiv1688961367 div.yiv1688961367photo-title a:hover,
#yiv1688961367 div.yiv1688961367photo-title a:visited {
text-decoration:none;}
#yiv1688961367 div#yiv1688961367ygrp-mlmsg
#yiv1688961367ygrp-msg p a span.yiv1688961367yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv1688961367 .yiv1688961367green {
color:#628c2a;}
#yiv1688961367 .yiv1688961367MsoNormal {
margin:0 0 0 0;}
#yiv1688961367 o {
font-size:0;}
#yiv1688961367 #yiv1688961367photos div {
float:left;width:72px;}
#yiv1688961367 #yiv1688961367photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv1688961367 #yiv1688961367photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv1688961367 #yiv1688961367reco-category {
font-size:77%;}
#yiv1688961367 #yiv1688961367reco-desc {
font-size:77%;}
#yiv1688961367 .yiv1688961367replbq {
margin:4px;}
#yiv1688961367 #yiv1688961367ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg select,
#yiv1688961367 input, #yiv1688961367 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg pre, #yiv1688961367
code {
font:115% monospace;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg * {
line-height:1.22em;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg #yiv1688961367logo {
padding-bottom:10px;}
#yiv1688961367 #yiv1688961367ygrp-msg p a {
font-family:Verdana;}
#yiv1688961367 #yiv1688961367ygrp-msg
p#yiv1688961367attach-count span {
color:#1E66AE;font-weight:700;}
#yiv1688961367 #yiv1688961367ygrp-reco
#yiv1688961367reco-head {
color:#ff7900;font-weight:700;}
#yiv1688961367 #yiv1688961367ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv1688961367 #yiv1688961367ygrp-sponsor #yiv1688961367ov
li a {
font-size:130%;text-decoration:none;}
#yiv1688961367 #yiv1688961367ygrp-sponsor #yiv1688961367ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv1688961367 #yiv1688961367ygrp-sponsor #yiv1688961367ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv1688961367 #yiv1688961367ygrp-text {
font-family:Georgia;}
#yiv1688961367 #yiv1688961367ygrp-text p {
margin:0 0 1em 0;}
#yiv1688961367 #yiv1688961367ygrp-text tt {
font-size:120%;}
#yiv1688961367 #yiv1688961367ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv1688961367

Thu Jan 28, 2016 10:41 pm (PST) . Posted by:

"Toby kenzo" tobykenzo


Hai Jack,

Coba di buat formula di sheet3 pada cell C2 :
=IFERROR(INDEX(Sheet2!$B$2:$B$9,MATCH(Sheet3!B2,Sheet2!$A$2:$A$9,0)),"")
jangan lupa di tekan bersamaan shiftCtrlEnter karena array formula.

TerimaKasih

Pada Jum, 29/1/16, Jack Carmelo jackcarmelo7@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re: Bls: [belajar-excel] Ambil data berdasarkan data validasi
Kepada: belajar-excel@yahoogroups.com
Tanggal: Jumat, 29 Januari, 2016, 12:48 PM


 










Makasih bang toby atas bantuannya. Saya
sudah coba kombinasikan tapi belum ketemu. Mohon
bantuannya.
--

Salam

Jack Carmelo

Jumat, 29 Januari 2016, 01:49PM +0900 dari
"Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>:
Hai Jack,

Coba pake formula array  IFERROR,INDEX,MATCH.

Di forum ini sudah sering di jelaskan penggunaan array
fermula untuk kombinasi INDEX, MATCH.

TerimaKasih.

Pada Jum, 29/1/16, Jack Carmelo  jackcarmelo7@gmail.com
[belajar-excel] < belajar-excel@yahoogroups.com >
menulis:

Judul: [belajar-excel] Ambil data berdasarkan data validasi
[1 Attachment]

Kepada:  belajar-excel@yahoogroups.com

Tanggal: Jumat, 29 Januari, 2016, 9:00 AM

Selamat pagi para master.

Saya punya data

yang harus di ambil. Tapi

karena datanya diambil berdasarkan data validasi list jdi

saya bingung

cara membuat formulanya. Mohon bantuannya.

Contoh kasus terlampir. Yang ditanyakan di sheet3

datanya harus sesuai dengan  sheet2 cell D2. Sesuai
dengan

validasi data di cell A2.

Terima kasih atas bantuannya..

Salam

Jack Carmelo

#yiv1688961367 #yiv1688961367 --

#yiv1688961367ygrp-mkp {

border:1px solid #d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}

#yiv1688961367 #yiv1688961367ygrp-mkp hr {

border:1px solid #d8d8d8;}

#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}

#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367ads {

margin-bottom:10px;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad {

padding:0 0;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad p
{

margin:0;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad a
{

color:#0000ff;text-decoration:none;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ygrp-lc {

font-family:Arial;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ygrp-lc #yiv1688961367hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ygrp-lc .yiv1688961367ad {

margin-bottom:10px;padding:0 0;}

#yiv1688961367 #yiv1688961367actions {

font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv1688961367 #yiv1688961367activity {

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

#yiv1688961367 #yiv1688961367activity span {

font-weight:700;}

#yiv1688961367 #yiv1688961367activity span:first-child {

text-transform:uppercase;}

#yiv1688961367 #yiv1688961367activity span a {

color:#5085b6;text-decoration:none;}

#yiv1688961367 #yiv1688961367activity span span {

color:#ff7900;}

#yiv1688961367 #yiv1688961367activity span

.yiv1688961367underline {

text-decoration:underline;}

#yiv1688961367 .yiv1688961367attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}

#yiv1688961367 .yiv1688961367attach div a {

text-decoration:none;}

#yiv1688961367 .yiv1688961367attach img {

border:none;padding-right:5px;}

#yiv1688961367 .yiv1688961367attach label {

display:block;margin-bottom:5px;}

#yiv1688961367 .yiv1688961367attach label a {

text-decoration:none;}

#yiv1688961367 blockquote {

margin:0 0 0 4px;}

#yiv1688961367 .yiv1688961367bold {

font-family:Arial;font-size:13px;font-weight:700;}

#yiv1688961367 .yiv1688961367bold a {

text-decoration:none;}

#yiv1688961367 dd.yiv1688961367last p a {

font-family:Verdana;font-weight:700;}

#yiv1688961367 dd.yiv1688961367last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv1688961367 dd.yiv1688961367last p

span.yiv1688961367yshortcuts {

margin-right:0;}

#yiv1688961367 div.yiv1688961367attach-table div div a {

text-decoration:none;}

#yiv1688961367 div.yiv1688961367attach-table {

width:400px;}

#yiv1688961367 div.yiv1688961367file-title a,
#yiv1688961367

div.yiv1688961367file-title a:active, #yiv1688961367

div.yiv1688961367file-title a:hover, #yiv1688961367

div.yiv1688961367file-title a:visited {

text-decoration:none;}

#yiv1688961367 div.yiv1688961367photo-title a,

#yiv1688961367 div.yiv1688961367photo-title a:active,

#yiv1688961367 div.yiv1688961367photo-title a:hover,

#yiv1688961367 div.yiv1688961367photo-title a:visited {

text-decoration:none;}

#yiv1688961367 div#yiv1688961367ygrp-mlmsg

#yiv1688961367ygrp-msg p a span.yiv1688961367yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1688961367 .yiv1688961367green {

color:#628c2a;}

#yiv1688961367 .yiv1688961367MsoNormal {

margin:0 0 0 0;}

#yiv1688961367 o {

font-size:0;}

#yiv1688961367 #yiv1688961367photos div {

float:left;width:72px;}

#yiv1688961367 #yiv1688961367photos div div {

border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}

#yiv1688961367 #yiv1688961367photos div label {

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

#yiv1688961367 #yiv1688961367reco-category {

font-size:77%;}

#yiv1688961367 #yiv1688961367reco-desc {

font-size:77%;}

#yiv1688961367 .yiv1688961367replbq {

margin:4px;}

#yiv1688961367 #yiv1688961367ygrp-actbar div a:first-child
{

margin-right:2px;padding-right:5px;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg table {

font-size:inherit;font:100%;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg select,

#yiv1688961367 input, #yiv1688961367 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg pre,
#yiv1688961367

code {

font:115% monospace;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg * {

line-height:1.22em;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg #yiv1688961367logo
{

padding-bottom:10px;}

#yiv1688961367 #yiv1688961367ygrp-msg p a {

font-family:Verdana;}

#yiv1688961367 #yiv1688961367ygrp-msg

p#yiv1688961367attach-count span {

color:#1E66AE;font-weight:700;}

#yiv1688961367 #yiv1688961367ygrp-reco

#yiv1688961367reco-head {

color:#ff7900;font-weight:700;}

#yiv1688961367 #yiv1688961367ygrp-reco {

margin-bottom:20px;padding:0px;}

#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ov

li a {

font-size:130%;text-decoration:none;}

#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ov

ul {

margin:0;padding:0 0 0 8px;}

#yiv1688961367 #yiv1688961367ygrp-text {

font-family:Georgia;}

#yiv1688961367 #yiv1688961367ygrp-text p {

margin:0 0 1em 0;}

#yiv1688961367 #yiv1688961367ygrp-text tt {

font-size:120%;}

#yiv1688961367 #yiv1688961367ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv1688961367













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

#yiv0509230174 #yiv0509230174ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0509230174 #yiv0509230174ygrp-mkp #yiv0509230174hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0509230174 #yiv0509230174ygrp-mkp #yiv0509230174ads {
margin-bottom:10px;}

#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad {
padding:0 0;}

#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad p {
margin:0;}

#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad a {
color:#0000ff;text-decoration:none;}
#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ygrp-lc {
font-family:Arial;}

#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ygrp-lc #yiv0509230174hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ygrp-lc .yiv0509230174ad {
margin-bottom:10px;padding:0 0;}

#yiv0509230174 #yiv0509230174actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv0509230174 #yiv0509230174activity span {
font-weight:700;}

#yiv0509230174 #yiv0509230174activity span:first-child {
text-transform:uppercase;}

#yiv0509230174 #yiv0509230174activity span a {
color:#5085b6;text-decoration:none;}

#yiv0509230174 #yiv0509230174activity span span {
color:#ff7900;}

#yiv0509230174 #yiv0509230174activity span
.yiv0509230174underline {
text-decoration:underline;}

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

#yiv0509230174 .yiv0509230174attach div a {
text-decoration:none;}

#yiv0509230174 .yiv0509230174attach img {
border:none;padding-right:5px;}

#yiv0509230174 .yiv0509230174attach label {
display:block;margin-bottom:5px;}

#yiv0509230174 .yiv0509230174attach label a {
text-decoration:none;}

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

#yiv0509230174 .yiv0509230174bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0509230174 .yiv0509230174bold a {
text-decoration:none;}

#yiv0509230174 dd.yiv0509230174last p a {
font-family:Verdana;font-weight:700;}

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

#yiv0509230174 dd.yiv0509230174last p
span.yiv0509230174yshortcuts {
margin-right:0;}

#yiv0509230174 div.yiv0509230174attach-table div div a {
text-decoration:none;}

#yiv0509230174 div.yiv0509230174attach-table {
width:400px;}

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

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

#yiv0509230174 div#yiv0509230174ygrp-mlmsg
#yiv0509230174ygrp-msg p a span.yiv0509230174yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0509230174 .yiv0509230174green {
color:#628c2a;}

#yiv0509230174 .yiv0509230174MsoNormal {
margin:0 0 0 0;}

#yiv0509230174 o {
font-size:0;}

#yiv0509230174 #yiv0509230174photos div {
float:left;width:72px;}

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

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

#yiv0509230174 #yiv0509230174reco-category {
font-size:77%;}

#yiv0509230174 #yiv0509230174reco-desc {
font-size:77%;}

#yiv0509230174 .yiv0509230174replbq {
margin:4px;}

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

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

#yiv0509230174 #yiv0509230174ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv0509230174 #yiv0509230174ygrp-mlmsg pre, #yiv0509230174
code {
font:115% monospace;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg * {
line-height:1.22em;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg #yiv0509230174logo {
padding-bottom:10px;}


#yiv0509230174 #yiv0509230174ygrp-msg p a {
font-family:Verdana;}

#yiv0509230174 #yiv0509230174ygrp-msg
p#yiv0509230174attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0509230174 #yiv0509230174ygrp-reco
#yiv0509230174reco-head {
color:#ff7900;font-weight:700;}

#yiv0509230174 #yiv0509230174ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0509230174 #yiv0509230174ygrp-sponsor #yiv0509230174ov
li a {
font-size:130%;text-decoration:none;}

#yiv0509230174 #yiv0509230174ygrp-sponsor #yiv0509230174ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0509230174 #yiv0509230174ygrp-sponsor #yiv0509230174ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0509230174 #yiv0509230174ygrp-text {
font-family:Georgia;}

#yiv0509230174 #yiv0509230174ygrp-text p {
margin:0 0 1em 0;}

#yiv0509230174 #yiv0509230174ygrp-text tt {
font-size:120%;}

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

Thu Jan 28, 2016 11:21 pm (PST) . Posted by:

"Jack Carmelo"


Makasih bang. Tapi hasil yang muncul malah hanya ketika data validasinya menampilkan nama yang bersangkutan. Sedangkan nama lainnya tidak ada hasil.
Mohon maaf merepotkan bang.
--
Salam
Jack Carmelo
Jumat, 29 Januari 2016, 03:41PM +0900 dari "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>:
Hai Jack,
Coba di buat formula di sheet3 pada cell C2 :
=IFERROR(INDEX(Sheet2!$B$2:$B$9,MATCH(Sheet3!B2,Sheet2!$A$2:$A$9,0)),"")
jangan lupa di tekan bersamaan shiftCtrlEnter karena array formula.
TerimaKasih
Pada Jum, 29/1/16, Jack Carmelo  jackcarmelo7@gmail.com [belajar-excel] < belajar-excel@yahoogroups.com > menulis:
Judul: Re: Bls: [belajar-excel] Ambil data berdasarkan data validasi
Kepada:  belajar-excel@yahoogroups.com
Tanggal: Jumat, 29 Januari, 2016, 12:48 PM
Makasih bang toby atas bantuannya. Saya
sudah coba kombinasikan tapi belum ketemu. Mohon
bantuannya.
--
Salam
Jack Carmelo
Jumat, 29 Januari 2016, 01:49PM +0900 dari
"Toby kenzo  tobykenzo@yahoo.co.id [belajar-excel]"
< belajar-excel@yahoogroups.com >:
Hai Jack,
Coba pake formula array  IFERROR,INDEX,MATCH.
Di forum ini sudah sering di jelaskan penggunaan array
fermula untuk kombinasi INDEX, MATCH.
TerimaKasih.
Pada Jum, 29/1/16, Jack Carmelo   jackcarmelo7@gmail.com
[belajar-excel] <  belajar-excel@yahoogroups.com >
menulis:
Judul: [belajar-excel] Ambil data berdasarkan data validasi
[1 Attachment]
Kepada:   belajar-excel@yahoogroups.com
Tanggal: Jumat, 29 Januari, 2016, 9:00 AM
Selamat pagi para master.
Saya punya data
yang harus di ambil. Tapi
karena datanya diambil berdasarkan data validasi list jdi
saya bingung
cara membuat formulanya. Mohon bantuannya.
Contoh kasus terlampir. Yang ditanyakan di sheet3
datanya harus sesuai dengan  sheet2 cell D2. Sesuai
dengan
validasi data di cell A2.
Terima kasih atas bantuannya..
Salam
Jack Carmelo
#yiv1688961367 #yiv1688961367 --
#yiv1688961367ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv1688961367 #yiv1688961367ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367ads {
margin-bottom:10px;}
#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad {
padding:0 0;}
#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad p
{
margin:0;}
#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad a
{
color:#0000ff;text-decoration:none;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc {
font-family:Arial;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc #yiv1688961367hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ygrp-lc .yiv1688961367ad {
margin-bottom:10px;padding:0 0;}
#yiv1688961367 #yiv1688961367actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv1688961367 #yiv1688961367activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv1688961367 #yiv1688961367activity span {
font-weight:700;}
#yiv1688961367 #yiv1688961367activity span:first-child {
text-transform:uppercase;}
#yiv1688961367 #yiv1688961367activity span a {
color:#5085b6;text-decoration:none;}
#yiv1688961367 #yiv1688961367activity span span {
color:#ff7900;}
#yiv1688961367 #yiv1688961367activity span
.yiv1688961367underline {
text-decoration:underline;}
#yiv1688961367 .yiv1688961367attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv1688961367 .yiv1688961367attach div a {
text-decoration:none;}
#yiv1688961367 .yiv1688961367attach img {
border:none;padding-right:5px;}
#yiv1688961367 .yiv1688961367attach label {
display:block;margin-bottom:5px;}
#yiv1688961367 .yiv1688961367attach label a {
text-decoration:none;}
#yiv1688961367 blockquote {
margin:0 0 0 4px;}
#yiv1688961367 .yiv1688961367bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv1688961367 .yiv1688961367bold a {
text-decoration:none;}
#yiv1688961367 dd.yiv1688961367last p a {
font-family:Verdana;font-weight:700;}
#yiv1688961367 dd.yiv1688961367last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv1688961367 dd.yiv1688961367last p
span.yiv1688961367yshortcuts {
margin-right:0;}
#yiv1688961367 div.yiv1688961367attach-table div div a {
text-decoration:none;}
#yiv1688961367 div.yiv1688961367attach-table {
width:400px;}
#yiv1688961367 div.yiv1688961367file-title a,
#yiv1688961367
div.yiv1688961367file-title a:active, #yiv1688961367
div.yiv1688961367file-title a:hover, #yiv1688961367
div.yiv1688961367file-title a:visited {
text-decoration:none;}
#yiv1688961367 div.yiv1688961367photo-title a,
#yiv1688961367 div.yiv1688961367photo-title a:active,
#yiv1688961367 div.yiv1688961367photo-title a:hover,
#yiv1688961367 div.yiv1688961367photo-title a:visited {
text-decoration:none;}
#yiv1688961367 div#yiv1688961367ygrp-mlmsg
#yiv1688961367ygrp-msg p a span.yiv1688961367yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv1688961367 .yiv1688961367green {
color:#628c2a;}
#yiv1688961367 .yiv1688961367MsoNormal {
margin:0 0 0 0;}
#yiv1688961367 o {
font-size:0;}
#yiv1688961367 #yiv1688961367photos div {
float:left;width:72px;}
#yiv1688961367 #yiv1688961367photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv1688961367 #yiv1688961367photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv1688961367 #yiv1688961367reco-category {
font-size:77%;}
#yiv1688961367 #yiv1688961367reco-desc {
font-size:77%;}
#yiv1688961367 .yiv1688961367replbq {
margin:4px;}
#yiv1688961367 #yiv1688961367ygrp-actbar div a:first-child
{
margin-right:2px;padding-right:5px;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg select,
#yiv1688961367 input, #yiv1688961367 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg pre,
#yiv1688961367
code {
font:115% monospace;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg * {
line-height:1.22em;}
#yiv1688961367 #yiv1688961367ygrp-mlmsg #yiv1688961367logo
{
padding-bottom:10px;}
#yiv1688961367 #yiv1688961367ygrp-msg p a {
font-family:Verdana;}
#yiv1688961367 #yiv1688961367ygrp-msg
p#yiv1688961367attach-count span {
color:#1E66AE;font-weight:700;}
#yiv1688961367 #yiv1688961367ygrp-reco
#yiv1688961367reco-head {
color:#ff7900;font-weight:700;}
#yiv1688961367 #yiv1688961367ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ov
li a {
font-size:130%;text-decoration:none;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv1688961367 #yiv1688961367ygrp-sponsor
#yiv1688961367ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv1688961367 #yiv1688961367ygrp-text {
font-family:Georgia;}
#yiv1688961367 #yiv1688961367ygrp-text p {
margin:0 0 1em 0;}
#yiv1688961367 #yiv1688961367ygrp-text tt {
font-size:120%;}
#yiv1688961367 #yiv1688961367ygrp-vital ul li:last-child
{
border-right:none !important;
}
#yiv1688961367
#yiv0509230174 #yiv0509230174 --
#yiv0509230174ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv0509230174 #yiv0509230174ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv0509230174 #yiv0509230174ygrp-mkp #yiv0509230174hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv0509230174 #yiv0509230174ygrp-mkp #yiv0509230174ads {
margin-bottom:10px;}
#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad {
padding:0 0;}
#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad p {
margin:0;}
#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad a {
color:#0000ff;text-decoration:none;}
#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ygrp-lc {
font-family:Arial;}
#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ygrp-lc #yiv0509230174hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ygrp-lc .yiv0509230174ad {
margin-bottom:10px;padding:0 0;}
#yiv0509230174 #yiv0509230174actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv0509230174 #yiv0509230174activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv0509230174 #yiv0509230174activity span {
font-weight:700;}
#yiv0509230174 #yiv0509230174activity span:first-child {
text-transform:uppercase;}
#yiv0509230174 #yiv0509230174activity span a {
color:#5085b6;text-decoration:none;}
#yiv0509230174 #yiv0509230174activity span span {
color:#ff7900;}
#yiv0509230174 #yiv0509230174activity span
.yiv0509230174underline {
text-decoration:underline;}
#yiv0509230174 .yiv0509230174attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv0509230174 .yiv0509230174attach div a {
text-decoration:none;}
#yiv0509230174 .yiv0509230174attach img {
border:none;padding-right:5px;}
#yiv0509230174 .yiv0509230174attach label {
display:block;margin-bottom:5px;}
#yiv0509230174 .yiv0509230174attach label a {
text-decoration:none;}
#yiv0509230174 blockquote {
margin:0 0 0 4px;}
#yiv0509230174 .yiv0509230174bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv0509230174 .yiv0509230174bold a {
text-decoration:none;}
#yiv0509230174 dd.yiv0509230174last p a {
font-family:Verdana;font-weight:700;}
#yiv0509230174 dd.yiv0509230174last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv0509230174 dd.yiv0509230174last p
span.yiv0509230174yshortcuts {
margin-right:0;}
#yiv0509230174 div.yiv0509230174attach-table div div a {
text-decoration:none;}
#yiv0509230174 div.yiv0509230174attach-table {
width:400px;}
#yiv0509230174 div.yiv0509230174file-title a, #yiv0509230174
div.yiv0509230174file-title a:active, #yiv0509230174
div.yiv0509230174file-title a:hover, #yiv0509230174
div.yiv0509230174file-title a:visited {
text-decoration:none;}
#yiv0509230174 div.yiv0509230174photo-title a,
#yiv0509230174 div.yiv0509230174photo-title a:active,
#yiv0509230174 div.yiv0509230174photo-title a:hover,
#yiv0509230174 div.yiv0509230174photo-title a:visited {
text-decoration:none;}
#yiv0509230174 div#yiv0509230174ygrp-mlmsg
#yiv0509230174ygrp-msg p a span.yiv0509230174yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv0509230174 .yiv0509230174green {
color:#628c2a;}
#yiv0509230174 .yiv0509230174MsoNormal {
margin:0 0 0 0;}
#yiv0509230174 o {
font-size:0;}
#yiv0509230174 #yiv0509230174photos div {
float:left;width:72px;}
#yiv0509230174 #yiv0509230174photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv0509230174 #yiv0509230174photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv0509230174 #yiv0509230174reco-category {
font-size:77%;}
#yiv0509230174 #yiv0509230174reco-desc {
font-size:77%;}
#yiv0509230174 .yiv0509230174replbq {
margin:4px;}
#yiv0509230174 #yiv0509230174ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv0509230174 #yiv0509230174ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv0509230174 #yiv0509230174ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv0509230174 #yiv0509230174ygrp-mlmsg select,
#yiv0509230174 input, #yiv0509230174 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv0509230174 #yiv0509230174ygrp-mlmsg pre, #yiv0509230174
code {
font:115% monospace;}
#yiv0509230174 #yiv0509230174ygrp-mlmsg * {
line-height:1.22em;}
#yiv0509230174 #yiv0509230174ygrp-mlmsg #yiv0509230174logo {
padding-bottom:10px;}
#yiv0509230174 #yiv0509230174ygrp-msg p a {
font-family:Verdana;}
#yiv0509230174 #yiv0509230174ygrp-msg
p#yiv0509230174attach-count span {
color:#1E66AE;font-weight:700;}
#yiv0509230174 #yiv0509230174ygrp-reco
#yiv0509230174reco-head {
color:#ff7900;font-weight:700;}
#yiv0509230174 #yiv0509230174ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv0509230174 #yiv0509230174ygrp-sponsor #yiv0509230174ov
li a {
font-size:130%;text-decoration:none;}
#yiv0509230174 #yiv0509230174ygrp-sponsor #yiv0509230174ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv0509230174 #yiv0509230174ygrp-sponsor #yiv0509230174ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv0509230174 #yiv0509230174ygrp-text {
font-family:Georgia;}
#yiv0509230174 #yiv0509230174ygrp-text p {
margin:0 0 1em 0;}
#yiv0509230174 #yiv0509230174ygrp-text tt {
font-size:120%;}
#yiv0509230174 #yiv0509230174ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0509230174

Thu Jan 28, 2016 11:21 pm (PST) . Posted by:

"Stephanus Nusanumba"

Saya Steven di NTT mau tanya bagaimana cara buat advanced Filter yang ada totalnya ? berikut code yang sudah saya buat :Private Sub CommandButton1_Click()
' ini kode untuk Advance Filternya
ThisWorkbook.Sheets("databasesiswa").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=ThisWorkbook.Sheets("detail").Range("b4:b5"), _
CopyToRange:=Range("a10:aa10"), Unique:=Unik
' ini kode untuk mencari jumlah data cocok

JmlDataCocok = Application.WorksheetFunction.Count(ThisWorkbook.Sheets("detail").Range("d11:d4000"))
' ini kode untuk menuliskan jumlah data cocok ke range C3
ThisWorkbook.Sheets("detail").Range("C3").Value = JmlDataCocok & " Transaksi ditemukan sesuai Kriteria Bro....., Profisiat e, tetap semangat ....!!!"

End Sub
Terima kasih atas Bantuannya.

Pada Minggu, 24 Januari 2016 15:43, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Oh iya, formula di pmbuat nomor barisnya, tanda '<' seharusnya '<='

2016-01-24 5:52 GMT+07:00 Mr. Kid <mr.nmkid@gmail.com>:

Hai Nur,

File terlampir

Regards,
Kid

2016-01-23 21:50 GMT+07:00 nursay saefulloh nursay_saefulloh@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

  Data base supir tiap bulan ingin saya Rekap, buat history per-Supir.Bagaimana caranya .....sudah otak-atik rumus ga ketemu,,,,,data terlampir


#yiv6613925396 #yiv6613925396 -- #yiv6613925396ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6613925396 #yiv6613925396ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6613925396 #yiv6613925396ygrp-mkp #yiv6613925396hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6613925396 #yiv6613925396ygrp-mkp #yiv6613925396ads {margin-bottom:10px;}#yiv6613925396 #yiv6613925396ygrp-mkp .yiv6613925396ad {padding:0 0;}#yiv6613925396 #yiv6613925396ygrp-mkp .yiv6613925396ad p {margin:0;}#yiv6613925396 #yiv6613925396ygrp-mkp .yiv6613925396ad a {color:#0000ff;text-decoration:none;}#yiv6613925396 #yiv6613925396ygrp-sponsor #yiv6613925396ygrp-lc {font-family:Arial;}#yiv6613925396 #yiv6613925396ygrp-sponsor #yiv6613925396ygrp-lc #yiv6613925396hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6613925396 #yiv6613925396ygrp-sponsor #yiv6613925396ygrp-lc .yiv6613925396ad {margin-bottom:10px;padding:0 0;}#yiv6613925396 #yiv6613925396actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6613925396 #yiv6613925396activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6613925396 #yiv6613925396activity span {font-weight:700;}#yiv6613925396 #yiv6613925396activity span:first-child {text-transform:uppercase;}#yiv6613925396 #yiv6613925396activity span a {color:#5085b6;text-decoration:none;}#yiv6613925396 #yiv6613925396activity span span {color:#ff7900;}#yiv6613925396 #yiv6613925396activity span .yiv6613925396underline {text-decoration:underline;}#yiv6613925396 .yiv6613925396attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6613925396 .yiv6613925396attach div a {text-decoration:none;}#yiv6613925396 .yiv6613925396attach img {border:none;padding-right:5px;}#yiv6613925396 .yiv6613925396attach label {display:block;margin-bottom:5px;}#yiv6613925396 .yiv6613925396attach label a {text-decoration:none;}#yiv6613925396 blockquote {margin:0 0 0 4px;}#yiv6613925396 .yiv6613925396bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6613925396 .yiv6613925396bold a {text-decoration:none;}#yiv6613925396 dd.yiv6613925396last p a {font-family:Verdana;font-weight:700;}#yiv6613925396 dd.yiv6613925396last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6613925396 dd.yiv6613925396last p span.yiv6613925396yshortcuts {margin-right:0;}#yiv6613925396 div.yiv6613925396attach-table div div a {text-decoration:none;}#yiv6613925396 div.yiv6613925396attach-table {width:400px;}#yiv6613925396 div.yiv6613925396file-title a, #yiv6613925396 div.yiv6613925396file-title a:active, #yiv6613925396 div.yiv6613925396file-title a:hover, #yiv6613925396 div.yiv6613925396file-title a:visited {text-decoration:none;}#yiv6613925396 div.yiv6613925396photo-title a, #yiv6613925396 div.yiv6613925396photo-title a:active, #yiv6613925396 div.yiv6613925396photo-title a:hover, #yiv6613925396 div.yiv6613925396photo-title a:visited {text-decoration:none;}#yiv6613925396 div#yiv6613925396ygrp-mlmsg #yiv6613925396ygrp-msg p a span.yiv6613925396yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6613925396 .yiv6613925396green {color:#628c2a;}#yiv6613925396 .yiv6613925396MsoNormal {margin:0 0 0 0;}#yiv6613925396 o {font-size:0;}#yiv6613925396 #yiv6613925396photos div {float:left;width:72px;}#yiv6613925396 #yiv6613925396photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6613925396 #yiv6613925396photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6613925396 #yiv6613925396reco-category {font-size:77%;}#yiv6613925396 #yiv6613925396reco-desc {font-size:77%;}#yiv6613925396 .yiv6613925396replbq {margin:4px;}#yiv6613925396 #yiv6613925396ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6613925396 #yiv6613925396ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6613925396 #yiv6613925396ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6613925396 #yiv6613925396ygrp-mlmsg select, #yiv6613925396 input, #yiv6613925396 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6613925396 #yiv6613925396ygrp-mlmsg pre, #yiv6613925396 code {font:115% monospace;}#yiv6613925396 #yiv6613925396ygrp-mlmsg * {line-height:1.22em;}#yiv6613925396 #yiv6613925396ygrp-mlmsg #yiv6613925396logo {padding-bottom:10px;}#yiv6613925396 #yiv6613925396ygrp-msg p a {font-family:Verdana;}#yiv6613925396 #yiv6613925396ygrp-msg p#yiv6613925396attach-count span {color:#1E66AE;font-weight:700;}#yiv6613925396 #yiv6613925396ygrp-reco #yiv6613925396reco-head {color:#ff7900;font-weight:700;}#yiv6613925396 #yiv6613925396ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6613925396 #yiv6613925396ygrp-sponsor #yiv6613925396ov li a {font-size:130%;text-decoration:none;}#yiv6613925396 #yiv6613925396ygrp-sponsor #yiv6613925396ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6613925396 #yiv6613925396ygrp-sponsor #yiv6613925396ov ul {margin:0;padding:0 0 0 8px;}#yiv6613925396 #yiv6613925396ygrp-text {font-family:Georgia;}#yiv6613925396 #yiv6613925396ygrp-text p {margin:0 0 1em 0;}#yiv6613925396 #yiv6613925396ygrp-text tt {font-size:120%;}#yiv6613925396 #yiv6613925396ygrp-vital ul li:last-child {border-right:none !important;}#yiv6613925396

Fri Jan 29, 2016 1:47 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Steven,Ini contoh file macro dari buku database yang saya modifikasi (pakai Total).
Semoga bisa jadi bahan rujukan.
Salam,HK

From: "Stephanus Nusanumba stef_ende@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 29 January 2016, 14:00
Subject: Bls: [belajar-excel] Filter atau Rekap Data Supir setiap Kota tujuan

  Saya Steven di NTT mau tanya bagaimana cara buat advanced Filter yang ada totalnya ? berikut code yang sudah saya buat :Private Sub CommandButton1_Click()
' ini kode untuk Advance Filternya
ThisWorkbook.Sheets("databasesiswa").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=ThisWorkbook.Sheets("detail").Range("b4:b5"), _
CopyToRange:=Range("a10:aa10"), Unique:=Unik
' ini kode untuk mencari jumlah data cocok
JmlDataCocok = Application.WorksheetFunction.Count(ThisWorkbook.Sheets("detail").Range("d11:d4000"))
' ini kode untuk menuliskan jumlah data cocok ke range C3
ThisWorkbook.Sheets("detail").Range("C3").Value = JmlDataCocok & " Transaksi ditemukan sesuai Kriteria Bro....., Profisiat e, tetap semangat ....!!!"

End Sub
Terima kasih atas Bantuannya.

Pada Minggu, 24 Januari 2016 15:43, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Oh iya, formula di pmbuat nomor barisnya, tanda '<' seharusnya '<='

2016-01-24 5:52 GMT+07:00 Mr. Kid <mr.nmkid@gmail.com>:

Hai Nur,

File terlampir

Regards,
Kid

2016-01-23 21:50 GMT+07:00 nursay saefulloh nursay_saefulloh@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

  Data base supir tiap bulan ingin saya Rekap, buat history per-Supir.Bagaimana caranya .....sudah otak-atik rumus ga ketemu,,,,,data terlampir


#yiv1020666945 #yiv1020666945 -- #yiv1020666945ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1020666945 #yiv1020666945ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1020666945 #yiv1020666945ygrp-mkp #yiv1020666945hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1020666945 #yiv1020666945ygrp-mkp #yiv1020666945ads {margin-bottom:10px;}#yiv1020666945 #yiv1020666945ygrp-mkp .yiv1020666945ad {padding:0 0;}#yiv1020666945 #yiv1020666945ygrp-mkp .yiv1020666945ad p {margin:0;}#yiv1020666945 #yiv1020666945ygrp-mkp .yiv1020666945ad a {color:#0000ff;text-decoration:none;}#yiv1020666945 #yiv1020666945ygrp-sponsor #yiv1020666945ygrp-lc {font-family:Arial;}#yiv1020666945 #yiv1020666945ygrp-sponsor #yiv1020666945ygrp-lc #yiv1020666945hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1020666945 #yiv1020666945ygrp-sponsor #yiv1020666945ygrp-lc .yiv1020666945ad {margin-bottom:10px;padding:0 0;}#yiv1020666945 #yiv1020666945actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1020666945 #yiv1020666945activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1020666945 #yiv1020666945activity span {font-weight:700;}#yiv1020666945 #yiv1020666945activity span:first-child {text-transform:uppercase;}#yiv1020666945 #yiv1020666945activity span a {color:#5085b6;text-decoration:none;}#yiv1020666945 #yiv1020666945activity span span {color:#ff7900;}#yiv1020666945 #yiv1020666945activity span .yiv1020666945underline {text-decoration:underline;}#yiv1020666945 .yiv1020666945attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1020666945 .yiv1020666945attach div a {text-decoration:none;}#yiv1020666945 .yiv1020666945attach img {border:none;padding-right:5px;}#yiv1020666945 .yiv1020666945attach label {display:block;margin-bottom:5px;}#yiv1020666945 .yiv1020666945attach label a {text-decoration:none;}#yiv1020666945 blockquote {margin:0 0 0 4px;}#yiv1020666945 .yiv1020666945bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1020666945 .yiv1020666945bold a {text-decoration:none;}#yiv1020666945 dd.yiv1020666945last p a {font-family:Verdana;font-weight:700;}#yiv1020666945 dd.yiv1020666945last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1020666945 dd.yiv1020666945last p span.yiv1020666945yshortcuts {margin-right:0;}#yiv1020666945 div.yiv1020666945attach-table div div a {text-decoration:none;}#yiv1020666945 div.yiv1020666945attach-table {width:400px;}#yiv1020666945 div.yiv1020666945file-title a, #yiv1020666945 div.yiv1020666945file-title a:active, #yiv1020666945 div.yiv1020666945file-title a:hover, #yiv1020666945 div.yiv1020666945file-title a:visited {text-decoration:none;}#yiv1020666945 div.yiv1020666945photo-title a, #yiv1020666945 div.yiv1020666945photo-title a:active, #yiv1020666945 div.yiv1020666945photo-title a:hover, #yiv1020666945 div.yiv1020666945photo-title a:visited {text-decoration:none;}#yiv1020666945 div#yiv1020666945ygrp-mlmsg #yiv1020666945ygrp-msg p a span.yiv1020666945yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1020666945 .yiv1020666945green {color:#628c2a;}#yiv1020666945 .yiv1020666945MsoNormal {margin:0 0 0 0;}#yiv1020666945 o {font-size:0;}#yiv1020666945 #yiv1020666945photos div {float:left;width:72px;}#yiv1020666945 #yiv1020666945photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1020666945 #yiv1020666945photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1020666945 #yiv1020666945reco-category {font-size:77%;}#yiv1020666945 #yiv1020666945reco-desc {font-size:77%;}#yiv1020666945 .yiv1020666945replbq {margin:4px;}#yiv1020666945 #yiv1020666945ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1020666945 #yiv1020666945ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1020666945 #yiv1020666945ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1020666945 #yiv1020666945ygrp-mlmsg select, #yiv1020666945 input, #yiv1020666945 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1020666945 #yiv1020666945ygrp-mlmsg pre, #yiv1020666945 code {font:115% monospace;}#yiv1020666945 #yiv1020666945ygrp-mlmsg * {line-height:1.22em;}#yiv1020666945 #yiv1020666945ygrp-mlmsg #yiv1020666945logo {padding-bottom:10px;}#yiv1020666945 #yiv1020666945ygrp-msg p a {font-family:Verdana;}#yiv1020666945 #yiv1020666945ygrp-msg p#yiv1020666945attach-count span {color:#1E66AE;font-weight:700;}#yiv1020666945 #yiv1020666945ygrp-reco #yiv1020666945reco-head {color:#ff7900;font-weight:700;}#yiv1020666945 #yiv1020666945ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1020666945 #yiv1020666945ygrp-sponsor #yiv1020666945ov li a {font-size:130%;text-decoration:none;}#yiv1020666945 #yiv1020666945ygrp-sponsor #yiv1020666945ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1020666945 #yiv1020666945ygrp-sponsor #yiv1020666945ov ul {margin:0;padding:0 0 0 8px;}#yiv1020666945 #yiv1020666945ygrp-text {font-family:Georgia;}#yiv1020666945 #yiv1020666945ygrp-text p {margin:0 0 1em 0;}#yiv1020666945 #yiv1020666945ygrp-text tt {font-size:120%;}#yiv1020666945 #yiv1020666945ygrp-vital ul li:last-child {border-right:none !important;}#yiv1020666945

Fri Jan 29, 2016 12:15 am (PST) . Posted by:

"Toby kenzo" tobykenzo


Hai Jack,

Coba di buat detail hasil yang anda inginkan di Sheet3, bisa di kirim lagi filenya, karena kalo cuma tanda tanya (?) aja, saya/ teman yang lain mungkin akan beda presepsi...

TerimaKasih,

Pada Jum, 29/1/16, Jack Carmelo jackcarmelo7@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re[2]: Bls: [belajar-excel] Ambil data berdasarkan data validasi
Kepada: belajar-excel@yahoogroups.com
Tanggal: Jumat, 29 Januari, 2016, 2:04 PM


 










Makasih bang. Tapi hasil yang muncul malah
hanya ketika data validasinya menampilkan nama yang
bersangkutan. Sedangkan nama lainnya tidak ada hasil.

Mohon maaf merepotkan bang.

--

Salam

Jack Carmelo

Jumat, 29 Januari 2016, 03:41PM +0900 dari
"Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>:
Hai Jack,

Coba di buat formula di sheet3 pada cell C2 :

=IFERROR(INDEX(Sheet2!$B$2:$B$9,MATCH(Sheet3!B2,Sheet2!$A$2:$A$9,0)),"")

jangan lupa di tekan bersamaan shiftCtrlEnter karena array
formula.

TerimaKasih

Pada Jum, 29/1/16, Jack Carmelo  jackcarmelo7@gmail.com
[belajar-excel] < belajar-excel@yahoogroups.com >
menulis:

Judul: Re: Bls: [belajar-excel] Ambil data berdasarkan data
validasi

Kepada:  belajar-excel@yahoogroups.com

Tanggal: Jumat, 29 Januari, 2016, 12:48 PM

Makasih bang toby atas bantuannya. Saya

sudah coba kombinasikan tapi belum ketemu. Mohon

bantuannya.

--

Salam

Jack Carmelo

Jumat, 29 Januari 2016, 01:49PM +0900 dari

"Toby kenzo  tobykenzo@yahoo.co.id
[belajar-excel]"

< belajar-excel@yahoogroups.com >:

Hai Jack,

Coba pake formula array  IFERROR,INDEX,MATCH.

Di forum ini sudah sering di jelaskan penggunaan array

fermula untuk kombinasi INDEX, MATCH.

TerimaKasih.

Pada Jum, 29/1/16, Jack Carmelo  
jackcarmelo7@gmail.com

[belajar-excel] <  belajar-excel@yahoogroups.com >

menulis:

Judul: [belajar-excel] Ambil data berdasarkan data
validasi

[1 Attachment]

Kepada:   belajar-excel@yahoogroups.com

Tanggal: Jumat, 29 Januari, 2016, 9:00 AM

Selamat pagi para master.

Saya punya data

yang harus di ambil. Tapi

karena datanya diambil berdasarkan data validasi list jdi

saya bingung

cara membuat formulanya. Mohon bantuannya.

Contoh kasus terlampir. Yang ditanyakan di sheet3

datanya harus sesuai dengan  sheet2 cell D2. Sesuai

dengan

validasi data di cell A2.

Terima kasih atas bantuannya..

Salam

Jack Carmelo

#yiv1688961367 #yiv1688961367 --

#yiv1688961367ygrp-mkp {

border:1px solid #d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}

#yiv1688961367 #yiv1688961367ygrp-mkp hr {

border:1px solid #d8d8d8;}

#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}

#yiv1688961367 #yiv1688961367ygrp-mkp #yiv1688961367ads {

margin-bottom:10px;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad {

padding:0 0;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad p

{

margin:0;}

#yiv1688961367 #yiv1688961367ygrp-mkp .yiv1688961367ad a

{

color:#0000ff;text-decoration:none;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ygrp-lc {

font-family:Arial;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ygrp-lc #yiv1688961367hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ygrp-lc .yiv1688961367ad {

margin-bottom:10px;padding:0 0;}

#yiv1688961367 #yiv1688961367actions {

font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv1688961367 #yiv1688961367activity {

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

#yiv1688961367 #yiv1688961367activity span {

font-weight:700;}

#yiv1688961367 #yiv1688961367activity span:first-child {

text-transform:uppercase;}

#yiv1688961367 #yiv1688961367activity span a {

color:#5085b6;text-decoration:none;}

#yiv1688961367 #yiv1688961367activity span span {

color:#ff7900;}

#yiv1688961367 #yiv1688961367activity span

.yiv1688961367underline {

text-decoration:underline;}

#yiv1688961367 .yiv1688961367attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}

#yiv1688961367 .yiv1688961367attach div a {

text-decoration:none;}

#yiv1688961367 .yiv1688961367attach img {

border:none;padding-right:5px;}

#yiv1688961367 .yiv1688961367attach label {

display:block;margin-bottom:5px;}

#yiv1688961367 .yiv1688961367attach label a {

text-decoration:none;}

#yiv1688961367 blockquote {

margin:0 0 0 4px;}

#yiv1688961367 .yiv1688961367bold {

font-family:Arial;font-size:13px;font-weight:700;}

#yiv1688961367 .yiv1688961367bold a {

text-decoration:none;}

#yiv1688961367 dd.yiv1688961367last p a {

font-family:Verdana;font-weight:700;}

#yiv1688961367 dd.yiv1688961367last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv1688961367 dd.yiv1688961367last p

span.yiv1688961367yshortcuts {

margin-right:0;}

#yiv1688961367 div.yiv1688961367attach-table div div a {

text-decoration:none;}

#yiv1688961367 div.yiv1688961367attach-table {

width:400px;}

#yiv1688961367 div.yiv1688961367file-title a,

#yiv1688961367

div.yiv1688961367file-title a:active, #yiv1688961367

div.yiv1688961367file-title a:hover, #yiv1688961367

div.yiv1688961367file-title a:visited {

text-decoration:none;}

#yiv1688961367 div.yiv1688961367photo-title a,

#yiv1688961367 div.yiv1688961367photo-title a:active,

#yiv1688961367 div.yiv1688961367photo-title a:hover,

#yiv1688961367 div.yiv1688961367photo-title a:visited {

text-decoration:none;}

#yiv1688961367 div#yiv1688961367ygrp-mlmsg

#yiv1688961367ygrp-msg p a span.yiv1688961367yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1688961367 .yiv1688961367green {

color:#628c2a;}

#yiv1688961367 .yiv1688961367MsoNormal {

margin:0 0 0 0;}

#yiv1688961367 o {

font-size:0;}

#yiv1688961367 #yiv1688961367photos div {

float:left;width:72px;}

#yiv1688961367 #yiv1688961367photos div div {

border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}

#yiv1688961367 #yiv1688961367photos div label {

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

#yiv1688961367 #yiv1688961367reco-category {

font-size:77%;}

#yiv1688961367 #yiv1688961367reco-desc {

font-size:77%;}

#yiv1688961367 .yiv1688961367replbq {

margin:4px;}

#yiv1688961367 #yiv1688961367ygrp-actbar div
a:first-child

{

margin-right:2px;padding-right:5px;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg table {

font-size:inherit;font:100%;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg select,

#yiv1688961367 input, #yiv1688961367 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg pre,

#yiv1688961367

code {

font:115% monospace;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg * {

line-height:1.22em;}

#yiv1688961367 #yiv1688961367ygrp-mlmsg
#yiv1688961367logo

{

padding-bottom:10px;}

#yiv1688961367 #yiv1688961367ygrp-msg p a {

font-family:Verdana;}

#yiv1688961367 #yiv1688961367ygrp-msg

p#yiv1688961367attach-count span {

color:#1E66AE;font-weight:700;}

#yiv1688961367 #yiv1688961367ygrp-reco

#yiv1688961367reco-head {

color:#ff7900;font-weight:700;}

#yiv1688961367 #yiv1688961367ygrp-reco {

margin-bottom:20px;padding:0px;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ov

li a {

font-size:130%;text-decoration:none;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1688961367 #yiv1688961367ygrp-sponsor

#yiv1688961367ov

ul {

margin:0;padding:0 0 0 8px;}

#yiv1688961367 #yiv1688961367ygrp-text {

font-family:Georgia;}

#yiv1688961367 #yiv1688961367ygrp-text p {

margin:0 0 1em 0;}

#yiv1688961367 #yiv1688961367ygrp-text tt {

font-size:120%;}

#yiv1688961367 #yiv1688961367ygrp-vital ul li:last-child

{

border-right:none !important;

}

#yiv1688961367

#yiv0509230174 #yiv0509230174 --

#yiv0509230174ygrp-mkp {

border:1px solid #d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}

#yiv0509230174 #yiv0509230174ygrp-mkp hr {

border:1px solid #d8d8d8;}

#yiv0509230174 #yiv0509230174ygrp-mkp #yiv0509230174hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}

#yiv0509230174 #yiv0509230174ygrp-mkp #yiv0509230174ads {

margin-bottom:10px;}

#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad {

padding:0 0;}

#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad p
{

margin:0;}

#yiv0509230174 #yiv0509230174ygrp-mkp .yiv0509230174ad a
{

color:#0000ff;text-decoration:none;}

#yiv0509230174 #yiv0509230174ygrp-sponsor

#yiv0509230174ygrp-lc {

font-family:Arial;}

#yiv0509230174 #yiv0509230174ygrp-sponsor

#yiv0509230174ygrp-lc #yiv0509230174hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0509230174 #yiv0509230174ygrp-sponsor

#yiv0509230174ygrp-lc .yiv0509230174ad {

margin-bottom:10px;padding:0 0;}

#yiv0509230174 #yiv0509230174actions {

font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0509230174 #yiv0509230174activity {

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

#yiv0509230174 #yiv0509230174activity span {

font-weight:700;}

#yiv0509230174 #yiv0509230174activity span:first-child {

text-transform:uppercase;}

#yiv0509230174 #yiv0509230174activity span a {

color:#5085b6;text-decoration:none;}

#yiv0509230174 #yiv0509230174activity span span {

color:#ff7900;}

#yiv0509230174 #yiv0509230174activity span

.yiv0509230174underline {

text-decoration:underline;}

#yiv0509230174 .yiv0509230174attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}

#yiv0509230174 .yiv0509230174attach div a {

text-decoration:none;}

#yiv0509230174 .yiv0509230174attach img {

border:none;padding-right:5px;}

#yiv0509230174 .yiv0509230174attach label {

display:block;margin-bottom:5px;}

#yiv0509230174 .yiv0509230174attach label a {

text-decoration:none;}

#yiv0509230174 blockquote {

margin:0 0 0 4px;}

#yiv0509230174 .yiv0509230174bold {

font-family:Arial;font-size:13px;font-weight:700;}

#yiv0509230174 .yiv0509230174bold a {

text-decoration:none;}

#yiv0509230174 dd.yiv0509230174last p a {

font-family:Verdana;font-weight:700;}

#yiv0509230174 dd.yiv0509230174last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0509230174 dd.yiv0509230174last p

span.yiv0509230174yshortcuts {

margin-right:0;}

#yiv0509230174 div.yiv0509230174attach-table div div a {

text-decoration:none;}

#yiv0509230174 div.yiv0509230174attach-table {

width:400px;}

#yiv0509230174 div.yiv0509230174file-title a,
#yiv0509230174

div.yiv0509230174file-title a:active, #yiv0509230174

div.yiv0509230174file-title a:hover, #yiv0509230174

div.yiv0509230174file-title a:visited {

text-decoration:none;}

#yiv0509230174 div.yiv0509230174photo-title a,

#yiv0509230174 div.yiv0509230174photo-title a:active,

#yiv0509230174 div.yiv0509230174photo-title a:hover,

#yiv0509230174 div.yiv0509230174photo-title a:visited {

text-decoration:none;}

#yiv0509230174 div#yiv0509230174ygrp-mlmsg

#yiv0509230174ygrp-msg p a span.yiv0509230174yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0509230174 .yiv0509230174green {

color:#628c2a;}

#yiv0509230174 .yiv0509230174MsoNormal {

margin:0 0 0 0;}

#yiv0509230174 o {

font-size:0;}

#yiv0509230174 #yiv0509230174photos div {

float:left;width:72px;}

#yiv0509230174 #yiv0509230174photos div div {

border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}

#yiv0509230174 #yiv0509230174photos div label {

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

#yiv0509230174 #yiv0509230174reco-category {

font-size:77%;}

#yiv0509230174 #yiv0509230174reco-desc {

font-size:77%;}

#yiv0509230174 .yiv0509230174replbq {

margin:4px;}

#yiv0509230174 #yiv0509230174ygrp-actbar div a:first-child
{

margin-right:2px;padding-right:5px;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg table {

font-size:inherit;font:100%;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg select,

#yiv0509230174 input, #yiv0509230174 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg pre,
#yiv0509230174

code {

font:115% monospace;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg * {

line-height:1.22em;}

#yiv0509230174 #yiv0509230174ygrp-mlmsg #yiv0509230174logo
{

padding-bottom:10px;}

#yiv0509230174 #yiv0509230174ygrp-msg p a {

font-family:Verdana;}

#yiv0509230174 #yiv0509230174ygrp-msg

p#yiv0509230174attach-count span {

color:#1E66AE;font-weight:700;}

#yiv0509230174 #yiv0509230174ygrp-reco

#yiv0509230174reco-head {

color:#ff7900;font-weight:700;}

#yiv0509230174 #yiv0509230174ygrp-reco {

margin-bottom:20px;padding:0px;}

#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ov

li a {

font-size:130%;text-decoration:none;}

#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0509230174 #yiv0509230174ygrp-sponsor
#yiv0509230174ov

ul {

margin:0;padding:0 0 0 8px;}

#yiv0509230174 #yiv0509230174ygrp-text {

font-family:Georgia;}

#yiv0509230174 #yiv0509230174ygrp-text p {

margin:0 0 1em 0;}

#yiv0509230174 #yiv0509230174ygrp-text tt {

font-size:120%;}

#yiv0509230174 #yiv0509230174ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv0509230174













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

#yiv6718814657 #yiv6718814657ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv6718814657 #yiv6718814657ygrp-mkp #yiv6718814657hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv6718814657 #yiv6718814657ygrp-mkp #yiv6718814657ads {
margin-bottom:10px;}

#yiv6718814657 #yiv6718814657ygrp-mkp .yiv6718814657ad {
padding:0 0;}

#yiv6718814657 #yiv6718814657ygrp-mkp .yiv6718814657ad p {
margin:0;}

#yiv6718814657 #yiv6718814657ygrp-mkp .yiv6718814657ad a {
color:#0000ff;text-decoration:none;}
#yiv6718814657 #yiv6718814657ygrp-sponsor
#yiv6718814657ygrp-lc {
font-family:Arial;}

#yiv6718814657 #yiv6718814657ygrp-sponsor
#yiv6718814657ygrp-lc #yiv6718814657hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv6718814657 #yiv6718814657ygrp-sponsor
#yiv6718814657ygrp-lc .yiv6718814657ad {
margin-bottom:10px;padding:0 0;}

#yiv6718814657 #yiv6718814657actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv6718814657 #yiv6718814657activity span {
font-weight:700;}

#yiv6718814657 #yiv6718814657activity span:first-child {
text-transform:uppercase;}

#yiv6718814657 #yiv6718814657activity span a {
color:#5085b6;text-decoration:none;}

#yiv6718814657 #yiv6718814657activity span span {
color:#ff7900;}

#yiv6718814657 #yiv6718814657activity span
.yiv6718814657underline {
text-decoration:underline;}

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

#yiv6718814657 .yiv6718814657attach div a {
text-decoration:none;}

#yiv6718814657 .yiv6718814657attach img {
border:none;padding-right:5px;}

#yiv6718814657 .yiv6718814657attach label {
display:block;margin-bottom:5px;}

#yiv6718814657 .yiv6718814657attach label a {
text-decoration:none;}

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

#yiv6718814657 .yiv6718814657bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv6718814657 .yiv6718814657bold a {
text-decoration:none;}

#yiv6718814657 dd.yiv6718814657last p a {
font-family:Verdana;font-weight:700;}

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

#yiv6718814657 dd.yiv6718814657last p
span.yiv6718814657yshortcuts {
margin-right:0;}

#yiv6718814657 div.yiv6718814657attach-table div div a {
text-decoration:none;}

#yiv6718814657 div.yiv6718814657attach-table {
width:400px;}

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

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

#yiv6718814657 div#yiv6718814657ygrp-mlmsg
#yiv6718814657ygrp-msg p a span.yiv6718814657yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv6718814657 .yiv6718814657green {
color:#628c2a;}

#yiv6718814657 .yiv6718814657MsoNormal {
margin:0 0 0 0;}

#yiv6718814657 o {
font-size:0;}

#yiv6718814657 #yiv6718814657photos div {
float:left;width:72px;}

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

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

#yiv6718814657 #yiv6718814657reco-category {
font-size:77%;}

#yiv6718814657 #yiv6718814657reco-desc {
font-size:77%;}

#yiv6718814657 .yiv6718814657replbq {
margin:4px;}

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

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

#yiv6718814657 #yiv6718814657ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv6718814657 #yiv6718814657ygrp-mlmsg pre, #yiv6718814657
code {
font:115% monospace;}

#yiv6718814657 #yiv6718814657ygrp-mlmsg * {
line-height:1.22em;}

#yiv6718814657 #yiv6718814657ygrp-mlmsg #yiv6718814657logo {
padding-bottom:10px;}


#yiv6718814657 #yiv6718814657ygrp-msg p a {
font-family:Verdana;}

#yiv6718814657 #yiv6718814657ygrp-msg
p#yiv6718814657attach-count span {
color:#1E66AE;font-weight:700;}

#yiv6718814657 #yiv6718814657ygrp-reco
#yiv6718814657reco-head {
color:#ff7900;font-weight:700;}

#yiv6718814657 #yiv6718814657ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv6718814657 #yiv6718814657ygrp-sponsor #yiv6718814657ov
li a {
font-size:130%;text-decoration:none;}

#yiv6718814657 #yiv6718814657ygrp-sponsor #yiv6718814657ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv6718814657 #yiv6718814657ygrp-sponsor #yiv6718814657ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv6718814657 #yiv6718814657ygrp-text {
font-family:Georgia;}

#yiv6718814657 #yiv6718814657ygrp-text p {
margin:0 0 1em 0;}

#yiv6718814657 #yiv6718814657ygrp-text tt {
font-size:120%;}

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

Fri Jan 29, 2016 12:30 am (PST) . Posted by:

"Heru Safrudin" superheruu

Yth. Para Master

Kenapa ketika saya ketik perintah macro rs.close muncul error sbb;
"Operation is not allowed in this context''
Apa yg menyebabkan demikian ?

Mohon pembelajarannya
Terima kasih

Heru Safrudin
============================================================
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