[belajar-excel] Digest Number 3785

Milis Belajar Microsoft Excel Group

11 Messages

Digest #3785

1

Userform untuk multiuser by abcdefghijkl1983

2a

Bls: [belajar-excel] Help Formula filter [1 Attachment] by "Toby kenzo" tobykenzo

2b

Bls: [belajar-excel] Help Formula filter [1 Attachment] by "Ahmad Habibillah" abiel_1108

2c

Re: Help Formula filter [1 Attachment] by "Susilo -"

2d

Re: Bls: [belajar-excel] Help Formula filter by "Toby kenzo" tobykenzo

3

Bls: [belajar-excel] Userform untuk multiuser [1 Attachment] by "Toby kenzo" tobykenzo

4a

Re: Bls: [belajar-excel] KONVERSI OTOMATIS by mr.lukman81

5a

Re: Mengambil data (cell) dari berbagai sheet bila ditemukan kriteri by "riansutarsa" riansutarsa

5b

Re: Mengambil data (cell) dari berbagai sheet bila ditemukan kriteri by "Mr. Kid" nmkid.family@ymail.com

6

HITUNG MULTI KRITERIA by "imam cahyo yuwono"

7a

Bls: [belajar-excel] cara refresh otomatis file tautan Vlookup by "Cito Akbar" cito.akbar

Messages

1

Userform untuk multiuser

Thu Mar 3, 2016 5:40 am (PST) . Posted by:

abcdefghijkl1983

Saya awam tentang ms excel tapi saya ingin memasukan nilai siswa dengan menggunakan userform excel, dan input data nilai tersebut dilakukan oleh beberapa orang dengan pc yang berbeda (Workbook di sharing) pada waktu bersamaan, bagaimana kode macro ketika tombol Add diKlik, mohon bantuan dan pejelasannya.

Atas penjelasanannya saya ucapkan terimakasih banyak.

contoh file ada di lampiran

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

2a

Bls: [belajar-excel] Help Formula filter [1 Attachment]

Thu Mar 3, 2016 9:13 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Ahmad,

Data dengan tabel Horisontal memang kelihatan "Bagus", tap jika untuk pengelolahan data akan sulit jadinya, alangkah baiknya jika masih dalam pengelolahan data gunakan tabal vertical, jika sudah merupakan Result/Summary data bisa menggunakan tabal dalam bentuk Horisontal.

Berikut contoh dari case yang anda hadapi, di sini saya ubah menjadi tabel Vertical untuk memudahkan dalam pengelolahan datanya.

TerimaKasih.

Pada Kam, 3/3/16, Ahmad Habibillah abiel_1108@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] Help Formula filter [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Kamis, 3 Maret, 2016, 5:01 PM


 









terima
kasih atas responnya bro...
terlampir
file yang sudah di create ulang.
atas
bantuannya terima kasih Regard,Ahmad
H


Pada Kamis, 3 Maret
2016 14:44, "Toby kenzo tobykenzo@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



 















Hai Ahmad,



Mungkin file ynag anda kirimkan kebesaran sehingga tidak
Nampak untuk di pelajari, coba di kirim ulang lagi
filenya.



TerimaKasih.



Pada Kam, 3/3/16, Ahmad Habibillah abiel_1108@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>
menulis:



Judul: [belajar-excel] Help Formula filter

Kepada: belajar-excel@yahoogroups.com

Tanggal: Kamis, 3 Maret, 2016, 2:22 PM





 



















Dear

Para Master Excel,

mohon

bantuan formula excel, formula seperti sumifs atau
filter

atau vlookup, atau apapun itu yang dapat mengakomodir
dari

kebutuhan data terlampir.

atas

bantuaannya, terima kasih banyak regards,Ahmad H























#yiv8635498531 #yiv8635498531 --

#yiv8635498531ygrp-mkp {

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

0;padding:0 10px;}



#yiv8635498531 #yiv8635498531ygrp-mkp hr {

border:1px solid #d8d8d8;}



#yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531hd {

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

0;}



#yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531ads
{

margin-bottom:10px;}



#yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad {

padding:0 0;}



#yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad p
{

margin:0;}



#yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad a
{

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

#yiv8635498531 #yiv8635498531ygrp-sponsor

#yiv8635498531ygrp-lc {

font-family:Arial;}



#yiv8635498531 #yiv8635498531ygrp-sponsor


#yiv8635498531ygrp-lc #yiv8635498531hd {

margin:10px

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



#yiv8635498531 #yiv8635498531ygrp-sponsor

#yiv8635498531ygrp-lc .yiv8635498531ad {

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



#yiv8635498531 #yiv8635498531actions {

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



#yiv8635498531 #yiv8635498531activity {

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



#yiv8635498531 #yiv8635498531activity span {

font-weight:700;}



#yiv8635498531 #yiv8635498531activity span:first-child {

text-transform:uppercase;}



#yiv8635498531 #yiv8635498531activity span a {

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



#yiv8635498531 #yiv8635498531activity span span {

color:#ff7900;}



#yiv8635498531 #yiv8635498531activity span

.yiv8635498531underline {

text-decoration:underline;}



#yiv8635498531 .yiv8635498531attach {

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

0;width:400px;}



#yiv8635498531 .yiv8635498531attach div a {

text-decoration:none;}



#yiv8635498531 .yiv8635498531attach img {

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



#yiv8635498531 .yiv8635498531attach label {

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



#yiv8635498531 .yiv8635498531attach label a {

text-decoration:none;}



#yiv8635498531 blockquote {

margin:0 0 0 4px;}



#yiv8635498531 .yiv8635498531bold {

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



#yiv8635498531 .yiv8635498531bold a {

text-decoration:none;}



#yiv8635498531 dd.yiv8635498531last p a {


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



#yiv8635498531 dd.yiv8635498531last p span {

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



#yiv8635498531 dd.yiv8635498531last p

span.yiv8635498531yshortcuts {

margin-right:0;}



#yiv8635498531 div.yiv8635498531attach-table div div a {

text-decoration:none;}



#yiv8635498531 div.yiv8635498531attach-table {

width:400px;}



#yiv8635498531 div.yiv8635498531file-title a,
#yiv8635498531

div.yiv8635498531file-title a:active, #yiv8635498531


div.yiv8635498531file-title a:hover, #yiv8635498531

div.yiv8635498531file-title a:visited {

text-decoration:none;}



#yiv8635498531 div.yiv8635498531photo-title a,

#yiv8635498531 div.yiv8635498531photo-title a:active,

#yiv8635498531 div.yiv8635498531photo-title a:hover,

#yiv8635498531 div.yiv8635498531photo-title a:visited {

text-decoration:none;}



#yiv8635498531 div#yiv8635498531ygrp-mlmsg

#yiv8635498531ygrp-msg p a span.yiv8635498531yshortcuts
{

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



#yiv8635498531 .yiv8635498531green {

color:#628c2a;}



#yiv8635498531 .yiv8635498531MsoNormal {

margin:0 0 0 0;}



#yiv8635498531 o {

font-size:0;}



#yiv8635498531 #yiv8635498531photos div {

float:left;width:72px;}



#yiv8635498531 #yiv8635498531photos div div {

border:1px solid

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



#yiv8635498531 #yiv8635498531photos div label {

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



#yiv8635498531 #yiv8635498531reco-category {

font-size:77%;}



#yiv8635498531 #yiv8635498531reco-desc {

font-size:77%;}



#yiv8635498531 .yiv8635498531replbq {

margin:4px;}



#yiv8635498531 #yiv8635498531ygrp-actbar div a:first-child
{

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



#yiv8635498531 #yiv8635498531ygrp-mlmsg {

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

sans-serif;}



#yiv8635498531 #yiv8635498531ygrp-mlmsg table {

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



#yiv8635498531 #yiv8635498531ygrp-mlmsg select,

#yiv8635498531 input, #yiv8635498531 textarea {

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



#yiv8635498531 #yiv8635498531ygrp-mlmsg pre,
#yiv8635498531

code {

font:115% monospace;}




#yiv8635498531 #yiv8635498531ygrp-mlmsg * {

line-height:1.22em;}



#yiv8635498531 #yiv8635498531ygrp-mlmsg #yiv8635498531logo
{

padding-bottom:10px;}





#yiv8635498531 #yiv8635498531ygrp-msg p a {

font-family:Verdana;}



#yiv8635498531 #yiv8635498531ygrp-msg

p#yiv8635498531attach-count span {

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



#yiv8635498531 #yiv8635498531ygrp-reco

#yiv8635498531reco-head {

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



#yiv8635498531 #yiv8635498531ygrp-reco {

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



#yiv8635498531 #yiv8635498531ygrp-sponsor
#yiv8635498531ov

li a {

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



#yiv8635498531 #yiv8635498531ygrp-sponsor
#yiv8635498531ov

li {

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



#yiv8635498531 #yiv8635498531ygrp-sponsor
#yiv8635498531ov

ul {

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



#yiv8635498531 #yiv8635498531ygrp-text {

font-family:Georgia;}



#yiv8635498531 #yiv8635498531ygrp-text p {

margin:0 0 1em 0;}



#yiv8635498531 #yiv8635498531ygrp-text tt {

font-size:120%;}



#yiv8635498531 #yiv8635498531ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv8635498531



























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

#yiv3968333443 #yiv3968333443ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443ads {
margin-bottom:10px;}

#yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad {
padding:0 0;}

#yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad p {
margin:0;}

#yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad a {
color:#0000ff;text-decoration:none;}
#yiv3968333443 #yiv3968333443ygrp-sponsor
#yiv3968333443ygrp-lc {
font-family:Arial;}

#yiv3968333443 #yiv3968333443ygrp-sponsor
#yiv3968333443ygrp-lc #yiv3968333443hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3968333443 #yiv3968333443ygrp-sponsor
#yiv3968333443ygrp-lc .yiv3968333443ad {
margin-bottom:10px;padding:0 0;}

#yiv3968333443 #yiv3968333443actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv3968333443 #yiv3968333443activity span {
font-weight:700;}

#yiv3968333443 #yiv3968333443activity span:first-child {
text-transform:uppercase;}

#yiv3968333443 #yiv3968333443activity span a {
color:#5085b6;text-decoration:none;}

#yiv3968333443 #yiv3968333443activity span span {
color:#ff7900;}

#yiv3968333443 #yiv3968333443activity span
.yiv3968333443underline {
text-decoration:underline;}

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

#yiv3968333443 .yiv3968333443attach div a {
text-decoration:none;}

#yiv3968333443 .yiv3968333443attach img {
border:none;padding-right:5px;}

#yiv3968333443 .yiv3968333443attach label {
display:block;margin-bottom:5px;}

#yiv3968333443 .yiv3968333443attach label a {
text-decoration:none;}

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

#yiv3968333443 .yiv3968333443bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3968333443 .yiv3968333443bold a {
text-decoration:none;}

#yiv3968333443 dd.yiv3968333443last p a {
font-family:Verdana;font-weight:700;}

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

#yiv3968333443 dd.yiv3968333443last p
span.yiv3968333443yshortcuts {
margin-right:0;}

#yiv3968333443 div.yiv3968333443attach-table div div a {
text-decoration:none;}

#yiv3968333443 div.yiv3968333443attach-table {
width:400px;}

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

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

#yiv3968333443 div#yiv3968333443ygrp-mlmsg
#yiv3968333443ygrp-msg p a span.yiv3968333443yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3968333443 .yiv3968333443green {
color:#628c2a;}

#yiv3968333443 .yiv3968333443MsoNormal {
margin:0 0 0 0;}

#yiv3968333443 o {
font-size:0;}

#yiv3968333443 #yiv3968333443photos div {
float:left;width:72px;}

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

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

#yiv3968333443 #yiv3968333443reco-category {
font-size:77%;}

#yiv3968333443 #yiv3968333443reco-desc {
font-size:77%;}

#yiv3968333443 .yiv3968333443replbq {
margin:4px;}

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

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

#yiv3968333443 #yiv3968333443ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv3968333443 #yiv3968333443ygrp-mlmsg pre, #yiv3968333443
code {
font:115% monospace;}

#yiv3968333443 #yiv3968333443ygrp-mlmsg * {
line-height:1.22em;}

#yiv3968333443 #yiv3968333443ygrp-mlmsg #yiv3968333443logo {
padding-bottom:10px;}


#yiv3968333443 #yiv3968333443ygrp-msg p a {
font-family:Verdana;}

#yiv3968333443 #yiv3968333443ygrp-msg
p#yiv3968333443attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3968333443 #yiv3968333443ygrp-reco
#yiv3968333443reco-head {
color:#ff7900;font-weight:700;}

#yiv3968333443 #yiv3968333443ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
li a {
font-size:130%;text-decoration:none;}

#yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3968333443 #yiv3968333443ygrp-text {
font-family:Georgia;}

#yiv3968333443 #yiv3968333443ygrp-text p {
margin:0 0 1em 0;}

#yiv3968333443 #yiv3968333443ygrp-text tt {
font-size:120%;}

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

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

2b

Bls: [belajar-excel] Help Formula filter [1 Attachment]

Thu Mar 3, 2016 10:25 pm (PST) . Posted by:

"Ahmad Habibillah" abiel_1108

Pagi, Toby,
terima kasih banyak atas bantuan dan solusinya, tetapi dalam kasus ini tidak hanya 2 data (pendapatan) tetapi ada beberapa data,
mohon solusinya, terima kasih  Regards,Ahmad Habibillah

Pada Jumat, 4 Maret 2016 0:13, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Ahmad,

Data dengan tabel Horisontal memang kelihatan "Bagus", tap jika untuk pengelolahan data akan sulit jadinya, alangkah baiknya jika masih dalam pengelolahan data gunakan tabal vertical, jika sudah merupakan Result/Summary data bisa menggunakan tabal dalam bentuk Horisontal.

Berikut contoh dari case yang anda hadapi, di sini saya ubah menjadi tabel Vertical untuk memudahkan dalam pengelolahan datanya.

TerimaKasih.

Pada Kam, 3/3/16, Ahmad Habibillah abiel_1108@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] Help Formula filter [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Kamis, 3 Maret, 2016, 5:01 PM


 









terima
kasih atas responnya bro...
terlampir
file yang sudah di create ulang.
atas
bantuannya terima kasih Regard,Ahmad
H


Pada Kamis, 3 Maret
2016 14:44, "Toby kenzo tobykenzo@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



 















Hai Ahmad,



Mungkin file ynag anda kirimkan kebesaran sehingga tidak
Nampak untuk di pelajari, coba di kirim ulang lagi
filenya.



TerimaKasih.



Pada Kam, 3/3/16, Ahmad Habibillah abiel_1108@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>
menulis:



Judul: [belajar-excel] Help Formula filter

Kepada: belajar-excel@yahoogroups.com

Tanggal: Kamis, 3 Maret, 2016, 2:22 PM





 



















Dear

Para Master Excel,

mohon

bantuan formula excel, formula seperti sumifs atau
filter

atau vlookup, atau apapun itu yang dapat mengakomodir
dari

kebutuhan data terlampir.

atas

bantuaannya, terima kasih banyak regards,Ahmad H























#yiv8635498531 #yiv8635498531 --

#yiv8635498531ygrp-mkp {

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

0;padding:0 10px;}



#yiv8635498531 #yiv8635498531ygrp-mkp hr {

border:1px solid #d8d8d8;}



#yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531hd {

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

0;}



#yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531ads
{

margin-bottom:10px;}



#yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad {

padding:0 0;}



#yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad p
{

margin:0;}



#yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad a
{

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

#yiv8635498531 #yiv8635498531ygrp-sponsor

#yiv8635498531ygrp-lc {

font-family:Arial;}



#yiv8635498531 #yiv8635498531ygrp-sponsor


#yiv8635498531ygrp-lc #yiv8635498531hd {

margin:10px

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



#yiv8635498531 #yiv8635498531ygrp-sponsor

#yiv8635498531ygrp-lc .yiv8635498531ad {

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



#yiv8635498531 #yiv8635498531actions {

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



#yiv8635498531 #yiv8635498531activity {

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



#yiv8635498531 #yiv8635498531activity span {

font-weight:700;}



#yiv8635498531 #yiv8635498531activity span:first-child {

text-transform:uppercase;}



#yiv8635498531 #yiv8635498531activity span a {

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



#yiv8635498531 #yiv8635498531activity span span {

color:#ff7900;}



#yiv8635498531 #yiv8635498531activity span

.yiv8635498531underline {

text-decoration:underline;}



#yiv8635498531 .yiv8635498531attach {

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

0;width:400px;}



#yiv8635498531 .yiv8635498531attach div a {

text-decoration:none;}



#yiv8635498531 .yiv8635498531attach img {

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



#yiv8635498531 .yiv8635498531attach label {

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



#yiv8635498531 .yiv8635498531attach label a {

text-decoration:none;}

#yiv8635498531 blockquote {

margin:0 0 0 4px;}



#yiv8635498531 .yiv8635498531bold {

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



#yiv8635498531 .yiv8635498531bold a {

text-decoration:none;}

#yiv8635498531 dd.yiv8635498531last p a {


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



#yiv8635498531 dd.yiv8635498531last p span {

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



#yiv8635498531 dd.yiv8635498531last p

span.yiv8635498531yshortcuts {

margin-right:0;}



#yiv8635498531 div.yiv8635498531attach-table div div a {

text-decoration:none;}



#yiv8635498531 div.yiv8635498531attach-table {

width:400px;}



#yiv8635498531 div.yiv8635498531file-title a,
#yiv8635498531

div.yiv8635498531file-title a:active, #yiv8635498531


div.yiv8635498531file-title a:hover, #yiv8635498531

div.yiv8635498531file-title a:visited {

text-decoration:none;}



#yiv8635498531 div.yiv8635498531photo-title a,

#yiv8635498531 div.yiv8635498531photo-title a:active,

#yiv8635498531 div.yiv8635498531photo-title a:hover,

#yiv8635498531 div.yiv8635498531photo-title a:visited {

text-decoration:none;}



#yiv8635498531 div#yiv8635498531ygrp-mlmsg

#yiv8635498531ygrp-msg p a span.yiv8635498531yshortcuts
{

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



#yiv8635498531 .yiv8635498531green {

color:#628c2a;}

#yiv8635498531 .yiv8635498531MsoNormal {

margin:0 0 0 0;}



#yiv8635498531 o {

font-size:0;}



#yiv8635498531 #yiv8635498531photos div {

float:left;width:72px;}



#yiv8635498531 #yiv8635498531photos div div {

border:1px solid

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



#yiv8635498531 #yiv8635498531photos div label {

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



#yiv8635498531 #yiv8635498531reco-category {

font-size:77%;}



#yiv8635498531 #yiv8635498531reco-desc {

font-size:77%;}



#yiv8635498531 .yiv8635498531replbq {

margin:4px;}



#yiv8635498531 #yiv8635498531ygrp-actbar div a:first-child
{

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



#yiv8635498531 #yiv8635498531ygrp-mlmsg {

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

sans-serif;}



#yiv8635498531 #yiv8635498531ygrp-mlmsg table {

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



#yiv8635498531 #yiv8635498531ygrp-mlmsg select,

#yiv8635498531 input, #yiv8635498531 textarea {

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



#yiv8635498531 #yiv8635498531ygrp-mlmsg pre,
#yiv8635498531

code {

font:115% monospace;}




#yiv8635498531 #yiv8635498531ygrp-mlmsg * {

line-height:1.22em;}



#yiv8635498531 #yiv8635498531ygrp-mlmsg #yiv8635498531logo
{

padding-bottom:10px;}





#yiv8635498531 #yiv8635498531ygrp-msg p a {

font-family:Verdana;}



#yiv8635498531 #yiv8635498531ygrp-msg

p#yiv8635498531attach-count span {

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



#yiv8635498531 #yiv8635498531ygrp-reco

#yiv8635498531reco-head {

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




#yiv8635498531 #yiv8635498531ygrp-reco {

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



#yiv8635498531 #yiv8635498531ygrp-sponsor
#yiv8635498531ov

li a {

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



#yiv8635498531 #yiv8635498531ygrp-sponsor
#yiv8635498531ov

li {

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



#yiv8635498531 #yiv8635498531ygrp-sponsor
#yiv8635498531ov

ul {

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



#yiv8635498531 #yiv8635498531ygrp-text {

font-family:Georgia;}



#yiv8635498531 #yiv8635498531ygrp-text p {

margin:0 0 1em 0;}



#yiv8635498531 #yiv8635498531ygrp-text tt {

font-size:120%;}



#yiv8635498531 #yiv8635498531ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv8635498531



























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

#yiv3968333443 #yiv3968333443ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443ads {
margin-bottom:10px;}

#yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad {
padding:0 0;}

#yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad p {
margin:0;}

#yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad a {
color:#0000ff;text-decoration:none;}
#yiv3968333443 #yiv3968333443ygrp-sponsor
#yiv3968333443ygrp-lc {
font-family:Arial;}

#yiv3968333443 #yiv3968333443ygrp-sponsor
#yiv3968333443ygrp-lc #yiv3968333443hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3968333443 #yiv3968333443ygrp-sponsor
#yiv3968333443ygrp-lc .yiv3968333443ad {
margin-bottom:10px;padding:0 0;}


#yiv3968333443 #yiv3968333443actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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


#yiv3968333443 #yiv3968333443activity span {
font-weight:700;}

#yiv3968333443 #yiv3968333443activity span:first-child {
text-transform:uppercase;}

#yiv3968333443 #yiv3968333443activity span a {
color:#5085b6;text-decoration:none;}

#yiv3968333443 #yiv3968333443activity span span {
color:#ff7900;}

#yiv3968333443 #yiv3968333443activity span
.yiv3968333443underline {
text-decoration:underline;}

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

#yiv3968333443 .yiv3968333443attach div a {
text-decoration:none;}

#yiv3968333443 .yiv3968333443attach img {
border:none;padding-right:5px;}

#yiv3968333443 .yiv3968333443attach label {
display:block;margin-bottom:5px;}

#yiv3968333443 .yiv3968333443attach label a {
text-decoration:none;}

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


#yiv3968333443 .yiv3968333443bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3968333443 .yiv3968333443bold a {
text-decoration:none;}

#yiv3968333443 dd.yiv3968333443last p a {
font-family:Verdana;font-weight:700;}

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

#yiv3968333443 dd.yiv3968333443last p
span.yiv3968333443yshortcuts {
margin-right:0;}

#yiv3968333443 div.yiv3968333443attach-table div div a {
text-decoration:none;}

#yiv3968333443 div.yiv3968333443attach-table {
width:400px;}

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

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

#yiv3968333443 div#yiv3968333443ygrp-mlmsg
#yiv3968333443ygrp-msg p a span.yiv3968333443yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3968333443 .yiv3968333443green {
color:#628c2a;}

#yiv3968333443 .yiv3968333443MsoNormal {
margin:0 0 0 0;}

#yiv3968333443 o {
font-size:0;}

#yiv3968333443 #yiv3968333443photos div {
float:left;width:72px;}

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

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

#yiv3968333443 #yiv3968333443reco-category {
font-size:77%;}

#yiv3968333443 #yiv3968333443reco-desc {
font-size:77%;}

#yiv3968333443 .yiv3968333443replbq {
margin:4px;}

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

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

#yiv3968333443 #yiv3968333443ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv3968333443 #yiv3968333443ygrp-mlmsg pre, #yiv3968333443
code {
font:115% monospace;}

#yiv3968333443 #yiv3968333443ygrp-mlmsg * {
line-height:1.22em;}

#yiv3968333443 #yiv3968333443ygrp-mlmsg #yiv3968333443logo {
padding-bottom:10px;}


#yiv3968333443 #yiv3968333443ygrp-msg p a {
font-family:Verdana;}

#yiv3968333443 #yiv3968333443ygrp-msg
p#yiv3968333443attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3968333443 #yiv3968333443ygrp-reco
#yiv3968333443reco-head {
color:#ff7900;font-weight:700;}

#yiv3968333443 #yiv3968333443ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
li a {
font-size:130%;text-decoration:none;}

#yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3968333443 #yiv3968333443ygrp-text {
font-family:Georgia;}

#yiv3968333443 #yiv3968333443ygrp-text p {
margin:0 0 1em 0;}

#yiv3968333443 #yiv3968333443ygrp-text tt {
font-size:120%;}

#yiv3968333443 #yiv3968333443ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv3968333443 #yiv2462909076 #yiv2462909076 -- #yiv2462909076ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2462909076 #yiv2462909076ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2462909076 #yiv2462909076ygrp-mkp #yiv2462909076hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2462909076 #yiv2462909076ygrp-mkp #yiv2462909076ads {margin-bottom:10px;}#yiv2462909076 #yiv2462909076ygrp-mkp .yiv2462909076ad {padding:0 0;}#yiv2462909076 #yiv2462909076ygrp-mkp .yiv2462909076ad p {margin:0;}#yiv2462909076 #yiv2462909076ygrp-mkp .yiv2462909076ad a {color:#0000ff;text-decoration:none;}#yiv2462909076 #yiv2462909076ygrp-sponsor #yiv2462909076ygrp-lc {font-family:Arial;}#yiv2462909076 #yiv2462909076ygrp-sponsor #yiv2462909076ygrp-lc #yiv2462909076hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2462909076 #yiv2462909076ygrp-sponsor #yiv2462909076ygrp-lc .yiv2462909076ad {margin-bottom:10px;padding:0 0;}#yiv2462909076 #yiv2462909076actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2462909076 #yiv2462909076activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2462909076 #yiv2462909076activity span {font-weight:700;}#yiv2462909076 #yiv2462909076activity span:first-child {text-transform:uppercase;}#yiv2462909076 #yiv2462909076activity span a {color:#5085b6;text-decoration:none;}#yiv2462909076 #yiv2462909076activity span span {color:#ff7900;}#yiv2462909076 #yiv2462909076activity span .yiv2462909076underline {text-decoration:underline;}#yiv2462909076 .yiv2462909076attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2462909076 .yiv2462909076attach div a {text-decoration:none;}#yiv2462909076 .yiv2462909076attach img {border:none;padding-right:5px;}#yiv2462909076 .yiv2462909076attach label {display:block;margin-bottom:5px;}#yiv2462909076 .yiv2462909076attach label a {text-decoration:none;}#yiv2462909076 blockquote {margin:0 0 0 4px;}#yiv2462909076 .yiv2462909076bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2462909076 .yiv2462909076bold a {text-decoration:none;}#yiv2462909076 dd.yiv2462909076last p a {font-family:Verdana;font-weight:700;}#yiv2462909076 dd.yiv2462909076last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2462909076 dd.yiv2462909076last p span.yiv2462909076yshortcuts {margin-right:0;}#yiv2462909076 div.yiv2462909076attach-table div div a {text-decoration:none;}#yiv2462909076 div.yiv2462909076attach-table {width:400px;}#yiv2462909076 div.yiv2462909076file-title a, #yiv2462909076 div.yiv2462909076file-title a:active, #yiv2462909076 div.yiv2462909076file-title a:hover, #yiv2462909076 div.yiv2462909076file-title a:visited {text-decoration:none;}#yiv2462909076 div.yiv2462909076photo-title a, #yiv2462909076 div.yiv2462909076photo-title a:active, #yiv2462909076 div.yiv2462909076photo-title a:hover, #yiv2462909076 div.yiv2462909076photo-title a:visited {text-decoration:none;}#yiv2462909076 div#yiv2462909076ygrp-mlmsg #yiv2462909076ygrp-msg p a span.yiv2462909076yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2462909076 .yiv2462909076green {color:#628c2a;}#yiv2462909076 .yiv2462909076MsoNormal {margin:0 0 0 0;}#yiv2462909076 o {font-size:0;}#yiv2462909076 #yiv2462909076photos div {float:left;width:72px;}#yiv2462909076 #yiv2462909076photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2462909076 #yiv2462909076photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2462909076 #yiv2462909076reco-category {font-size:77%;}#yiv2462909076 #yiv2462909076reco-desc {font-size:77%;}#yiv2462909076 .yiv2462909076replbq {margin:4px;}#yiv2462909076 #yiv2462909076ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2462909076 #yiv2462909076ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2462909076 #yiv2462909076ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2462909076 #yiv2462909076ygrp-mlmsg select, #yiv2462909076 input, #yiv2462909076 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2462909076 #yiv2462909076ygrp-mlmsg pre, #yiv2462909076 code {font:115% monospace;}#yiv2462909076 #yiv2462909076ygrp-mlmsg * {line-height:1.22em;}#yiv2462909076 #yiv2462909076ygrp-mlmsg #yiv2462909076logo {padding-bottom:10px;}#yiv2462909076 #yiv2462909076ygrp-msg p a {font-family:Verdana;}#yiv2462909076 #yiv2462909076ygrp-msg p#yiv2462909076attach-count span {color:#1E66AE;font-weight:700;}#yiv2462909076 #yiv2462909076ygrp-reco #yiv2462909076reco-head {color:#ff7900;font-weight:700;}#yiv2462909076 #yiv2462909076ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2462909076 #yiv2462909076ygrp-sponsor #yiv2462909076ov li a {font-size:130%;text-decoration:none;}#yiv2462909076 #yiv2462909076ygrp-sponsor #yiv2462909076ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2462909076 #yiv2462909076ygrp-sponsor #yiv2462909076ov ul {margin:0;padding:0 0 0 8px;}#yiv2462909076 #yiv2462909076ygrp-text {font-family:Georgia;}#yiv2462909076 #yiv2462909076ygrp-text p {margin:0 0 1em 0;}#yiv2462909076 #yiv2462909076ygrp-text tt {font-size:120%;}#yiv2462909076 #yiv2462909076ygrp-vital ul li:last-child {border-right:none !important;}#yiv2462909076

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

2c

Re: Help Formula filter [1 Attachment]

Thu Mar 3, 2016 10:30 pm (PST) . Posted by:

"Susilo -"

Dear Ahmad

Untuk data yang horizontal seperti ini, saya mengubah bentuk datanya
terlebih dahulu.
Pada baris bulan, saya hilangkan merger dan setiap kolomnya saya isi sesuai
dengan bulannya masing-masing sehingga memudahkan perhitungan excelnya.

Silakan cek file berikut

Terima kasih
Susilo

2016-03-04 0:13 GMT+07:00 Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Hai Ahmad,
>
> Data dengan tabel Horisontal memang kelihatan "Bagus", tap jika untuk
> pengelolahan data akan sulit jadinya, alangkah baiknya jika masih dalam
> pengelolahan data gunakan tabal vertical, jika sudah merupakan
> Result/Summary data bisa menggunakan tabal dalam bentuk Horisontal.
>
> Berikut contoh dari case yang anda hadapi, di sini saya ubah menjadi tabel
> Vertical untuk memudahkan dalam pengelolahan datanya.
>
> TerimaKasih.
>
> Pada Kam, 3/3/16, Ahmad Habibillah abiel_1108@yahoo.com [belajar-excel] <
> belajar-excel@yahoogroups.com> menulis:

>
> Judul: Bls: [belajar-excel] Help Formula filter [1 Attachment]
> Kepada: belajar-excel@yahoogroups.com
> Tanggal: Kamis, 3 Maret, 2016, 5:01 PM
>

>
>
>
>
>
>
>
>
>
>
>
>
> terima
> kasih atas responnya bro...
> terlampir

> file yang sudah di create ulang.
> atas
> bantuannya terima kasih Regard,Ahmad
> H
>
>
> Pada Kamis, 3 Maret
> 2016 14:44, "Toby kenzo tobykenzo@yahoo.co.id
> [belajar-excel]" <belajar-excel@yahoogroups.com>
> menulis:
>
>

>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hai Ahmad,
>
>
>
> Mungkin file ynag anda kirimkan kebesaran sehingga tidak
> Nampak untuk di pelajari, coba di kirim ulang lagi
> filenya.
>
>
>
> TerimaKasih.
>
>
>
> Pada Kam, 3/3/16, Ahmad Habibillah abiel_1108@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com>
> menulis:
>
>
>
> Judul: [belajar-excel] Help Formula filter
>

> Kepada: belajar-excel@yahoogroups.com
>
> Tanggal: Kamis, 3 Maret, 2016, 2:22 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Dear
>
> Para Master Excel,
>
> mohon
>
> bantuan formula excel, formula seperti sumifs atau
> filter
>
> atau vlookup, atau apapun itu yang dapat mengakomodir
> dari
>
> kebutuhan data terlampir.
>
> atas
>
> bantuaannya, terima kasih banyak regards,Ahmad H
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> #yiv8635498531 #yiv8635498531 --
>
> #yiv8635498531ygrp-mkp {
>
> border:1px solid #d8d8d8;font-family:Arial;margin:10px
>
> 0;padding:0 10px;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mkp hr {
>
> border:1px solid #d8d8d8;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531hd {
>
> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
>
> 0;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531ads
> {
>
> margin-bottom:10px;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad {
>
> padding:0 0;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad p
> {
>
> margin:0;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad a
> {
>
> color:#0000ff;text-decoration:none;}
>
> #yiv8635498531 #yiv8635498531ygrp-sponsor
>
> #yiv8635498531ygrp-lc {
>
> font-family:Arial;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-sponsor
>
>
> #yiv8635498531ygrp-lc #yiv8635498531hd {
>
> margin:10px
>
> 0px;font-weight:700;font-size:78%;line-height:122%;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-sponsor
>
> #yiv8635498531ygrp-lc .yiv8635498531ad {
>
> margin-bottom:10px;padding:0 0;}
>
>
>
> #yiv8635498531 #yiv8635498531actions {
>
> font-family:Verdana;font-size:11px;padding:10px 0;}
>
>
>
> #yiv8635498531 #yiv8635498531activity {
>
>
> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
>
>
>
> #yiv8635498531 #yiv8635498531activity span {
>
> font-weight:700;}
>
>
>
> #yiv8635498531 #yiv8635498531activity span:first-child {
>
> text-transform:uppercase;}
>
>
>
> #yiv8635498531 #yiv8635498531activity span a {
>
> color:#5085b6;text-decoration:none;}
>

>
>
> #yiv8635498531 #yiv8635498531activity span span {
>
> color:#ff7900;}
>
>
>
> #yiv8635498531 #yiv8635498531activity span
>
> .yiv8635498531underline {
>
> text-decoration:underline;}
>
>
>
> #yiv8635498531 .yiv8635498531attach {
>
> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
>
> 0;width:400px;}
>
>
>
> #yiv8635498531 .yiv8635498531attach div a {
>
> text-decoration:none;}
>
>
>
> #yiv8635498531 .yiv8635498531attach img {
>
> border:none;padding-right:5px;}
>
>
>
> #yiv8635498531 .yiv8635498531attach label {
>
> display:block;margin-bottom:5px;}
>
>
>
> #yiv8635498531 .yiv8635498531attach label a {
>
> text-decoration:none;}
>
>
>
> #yiv8635498531 blockquote {
>
> margin:0 0 0 4px;}
>
>
>
> #yiv8635498531 .yiv8635498531bold {
>
> font-family:Arial;font-size:13px;font-weight:700;}
>
>
>
> #yiv8635498531 .yiv8635498531bold a {
>
> text-decoration:none;}
>
>
>
> #yiv8635498531 dd.yiv8635498531last p a {
>
>
> font-family:Verdana;font-weight:700;}
>
>
>
> #yiv8635498531 dd.yiv8635498531last p span {
>
> margin-right:10px;font-family:Verdana;font-weight:700;}
>
>
>
> #yiv8635498531 dd.yiv8635498531last p
>
> span.yiv8635498531yshortcuts {
>
> margin-right:0;}
>
>
>
> #yiv8635498531 div.yiv8635498531attach-table div div a {
>
> text-decoration:none;}
>
>
>
> #yiv8635498531 div.yiv8635498531attach-table {
>
> width:400px;}
>
>
>
> #yiv8635498531 div.yiv8635498531file-title a,

> #yiv8635498531
>
> div.yiv8635498531file-title a:active, #yiv8635498531
>
>
> div.yiv8635498531file-title a:hover, #yiv8635498531
>
> div.yiv8635498531file-title a:visited {
>
> text-decoration:none;}
>
>
>
> #yiv8635498531 div.yiv8635498531photo-title a,
>
> #yiv8635498531 div.yiv8635498531photo-title a:active,
>
> #yiv8635498531 div.yiv8635498531photo-title a:hover,
>

> #yiv8635498531 div.yiv8635498531photo-title a:visited {
>
> text-decoration:none;}
>
>
>
> #yiv8635498531 div#yiv8635498531ygrp-mlmsg
>
> #yiv8635498531ygrp-msg p a span.yiv8635498531yshortcuts
> {
>
> font-family:Verdana;font-size:10px;font-weight:normal;}
>
>
>
> #yiv8635498531 .yiv8635498531green {
>
> color:#628c2a;}
>
>
>
> #yiv8635498531 .yiv8635498531MsoNormal {
>
> margin:0 0 0 0;}
>
>
>
> #yiv8635498531 o {
>
> font-size:0;}
>
>
>
> #yiv8635498531 #yiv8635498531photos div {
>
> float:left;width:72px;}
>
>
>
> #yiv8635498531 #yiv8635498531photos div div {
>
> border:1px solid
>
> #666666;height:62px;overflow:hidden;width:62px;}
>
>
>
> #yiv8635498531 #yiv8635498531photos div label {
>
>
> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
>
>
>
> #yiv8635498531 #yiv8635498531reco-category {
>
> font-size:77%;}
>
>
>
> #yiv8635498531 #yiv8635498531reco-desc {
>
> font-size:77%;}
>
>
>
> #yiv8635498531 .yiv8635498531replbq {
>
> margin:4px;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-actbar div a:first-child
> {
>
> margin-right:2px;padding-right:5px;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mlmsg {
>
> font-size:13px;font-family:Arial, helvetica, clean,
>
> sans-serif;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mlmsg table {
>
> font-size:inherit;font:100%;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mlmsg select,
>
> #yiv8635498531 input, #yiv8635498531 textarea {
>
> font:99% Arial, Helvetica, clean, sans-serif;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mlmsg pre,
> #yiv8635498531
>
> code {
>

> font:115% monospace;}
>
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mlmsg * {
>
> line-height:1.22em;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-mlmsg #yiv8635498531logo
> {
>
> padding-bottom:10px;}
>
>
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-msg p a {
>
> font-family:Verdana;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-msg
>
> p#yiv8635498531attach-count span {
>
> color:#1E66AE;font-weight:700;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-reco

>
> #yiv8635498531reco-head {
>
> color:#ff7900;font-weight:700;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-reco {
>
> margin-bottom:20px;padding:0px;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-sponsor
> #yiv8635498531ov
>
> li a {
>
> font-size:130%;text-decoration:none;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-sponsor
> #yiv8635498531ov
>
> li {
>
> font-size:77%;list-style-type:square;padding:6px 0;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-sponsor
> #yiv8635498531ov
>
> ul {
>
> margin:0;padding:0 0 0 8px;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-text {
>
> font-family:Georgia;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-text p {
>
> margin:0 0 1em 0;}
>
>
>

> #yiv8635498531 #yiv8635498531ygrp-text tt {
>
> font-size:120%;}
>
>
>
> #yiv8635498531 #yiv8635498531ygrp-vital ul li:last-child
> {
>
> border-right:none !important;
>
> }
>
> #yiv8635498531
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

>
>
>
>
>
>
>
>
>
>
>
>
> #yiv3968333443 #yiv3968333443 --
> #yiv3968333443ygrp-mkp {
> border:1px solid #d8d8d8;font-family:Arial;margin:10px
> 0;padding:0 10px;}
>
> #yiv3968333443 #yiv3968333443ygrp-mkp hr {
> border:1px solid #d8d8d8;}
>
> #yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443hd {
> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}
>
> #yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443ads {
> margin-bottom:10px;}
>
> #yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad {
> padding:0 0;}
>
> #yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad p {
> margin:0;}
>
> #yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad a {
> color:#0000ff;text-decoration:none;}
> #yiv3968333443 #yiv3968333443ygrp-sponsor
> #yiv3968333443ygrp-lc {
> font-family:Arial;}
>
> #yiv3968333443 #yiv3968333443ygrp-sponsor
> #yiv3968333443ygrp-lc #yiv3968333443hd {
> margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}
>
> #yiv3968333443 #yiv3968333443ygrp-sponsor
> #yiv3968333443ygrp-lc .yiv3968333443ad {
> margin-bottom:10px;padding:0 0;}
>
> #yiv3968333443 #yiv3968333443actions {
> font-family:Verdana;font-size:11px;padding:10px 0;}
>
> #yiv3968333443 #yiv3968333443activity {
>
> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
>
> #yiv3968333443 #yiv3968333443activity span {
> font-weight:700;}
>
> #yiv3968333443 #yiv3968333443activity span:first-child {
> text-transform:uppercase;}
>
> #yiv3968333443 #yiv3968333443activity span a {
> color:#5085b6;text-decoration:none;}
>
> #yiv3968333443 #yiv3968333443activity span span {
> color:#ff7900;}
>

> #yiv3968333443 #yiv3968333443activity span
> .yiv3968333443underline {
> text-decoration:underline;}
>
> #yiv3968333443 .yiv3968333443attach {
> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}
>
> #yiv3968333443 .yiv3968333443attach div a {
> text-decoration:none;}
>
> #yiv3968333443 .yiv3968333443attach img {
> border:none;padding-right:5px;}
>
> #yiv3968333443 .yiv3968333443attach label {
> display:block;margin-bottom:5px;}
>
> #yiv3968333443 .yiv3968333443attach label a {
> text-decoration:none;}
>
> #yiv3968333443 blockquote {
> margin:0 0 0 4px;}
>
> #yiv3968333443 .yiv3968333443bold {
> font-family:Arial;font-size:13px;font-weight:700;}
>
> #yiv3968333443 .yiv3968333443bold a {
> text-decoration:none;}
>
> #yiv3968333443 dd.yiv3968333443last p a {
> font-family:Verdana;font-weight:700;}
>
> #yiv3968333443 dd.yiv3968333443last p span {
> margin-right:10px;font-family:Verdana;font-weight:700;}
>
> #yiv3968333443 dd.yiv3968333443last p
> span.yiv3968333443yshortcuts {
> margin-right:0;}
>

> #yiv3968333443 div.yiv3968333443attach-table div div a {
> text-decoration:none;}
>
> #yiv3968333443 div.yiv3968333443attach-table {
> width:400px;}
>
> #yiv3968333443 div.yiv3968333443file-title a, #yiv3968333443
> div.yiv3968333443file-title a:active, #yiv3968333443
> div.yiv3968333443file-title a:hover, #yiv3968333443
> div.yiv3968333443file-title a:visited {
> text-decoration:none;}
>
> #yiv3968333443 div.yiv3968333443photo-title a,
> #yiv3968333443 div.yiv3968333443photo-title a:active,
> #yiv3968333443 div.yiv3968333443photo-title a:hover,
> #yiv3968333443 div.yiv3968333443photo-title a:visited {
> text-decoration:none;}
>
> #yiv3968333443 div#yiv3968333443ygrp-mlmsg
> #yiv3968333443ygrp-msg p a span.yiv3968333443yshortcuts {
> font-family:Verdana;font-size:10px;font-weight:normal;}
>
> #yiv3968333443 .yiv3968333443green {
> color:#628c2a;}
>
> #yiv3968333443 .yiv3968333443MsoNormal {
> margin:0 0 0 0;}
>
> #yiv3968333443 o {
> font-size:0;}
>
> #yiv3968333443 #yiv3968333443photos div {
> float:left;width:72px;}
>
> #yiv3968333443 #yiv3968333443photos div div {
> border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}
>
> #yiv3968333443 #yiv3968333443photos div label {
>
> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
>
> #yiv3968333443 #yiv3968333443reco-category {
> font-size:77%;}
>
> #yiv3968333443 #yiv3968333443reco-desc {
> font-size:77%;}
>
> #yiv3968333443 .yiv3968333443replbq {
> margin:4px;}
>
> #yiv3968333443 #yiv3968333443ygrp-actbar div a:first-child {
> margin-right:2px;padding-right:5px;}
>
> #yiv3968333443 #yiv3968333443ygrp-mlmsg {
> font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}
>
> #yiv3968333443 #yiv3968333443ygrp-mlmsg table {
> font-size:inherit;font:100%;}
>
> #yiv3968333443 #yiv3968333443ygrp-mlmsg select,
> #yiv3968333443 input, #yiv3968333443 textarea {
> font:99% Arial, Helvetica, clean, sans-serif;}
>

> #yiv3968333443 #yiv3968333443ygrp-mlmsg pre, #yiv3968333443
> code {
> font:115% monospace;}
>
> #yiv3968333443 #yiv3968333443ygrp-mlmsg * {
> line-height:1.22em;}
>
> #yiv3968333443 #yiv3968333443ygrp-mlmsg #yiv3968333443logo {
> padding-bottom:10px;}
>
>
> #yiv3968333443 #yiv3968333443ygrp-msg p a {
> font-family:Verdana;}
>
> #yiv3968333443 #yiv3968333443ygrp-msg
> p#yiv3968333443attach-count span {
> color:#1E66AE;font-weight:700;}
>
> #yiv3968333443 #yiv3968333443ygrp-reco
> #yiv3968333443reco-head {
> color:#ff7900;font-weight:700;}
>
> #yiv3968333443 #yiv3968333443ygrp-reco {
> margin-bottom:20px;padding:0px;}
>
> #yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
> li a {
> font-size:130%;text-decoration:none;}
>
> #yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
> li {
> font-size:77%;list-style-type:square;padding:6px 0;}
>
> #yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
> ul {
> margin:0;padding:0 0 0 8px;}
>
> #yiv3968333443 #yiv3968333443ygrp-text {
> font-family:Georgia;}
>
> #yiv3968333443 #yiv3968333443ygrp-text p {
> margin:0 0 1em 0;}
>
> #yiv3968333443 #yiv3968333443ygrp-text tt {
> font-size:120%;}
>
> #yiv3968333443 #yiv3968333443ygrp-vital ul li:last-child {
> border-right:none !important;
> }
> #yiv3968333443
>
>
>

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

2d

Re: Bls: [belajar-excel] Help Formula filter

Thu Mar 3, 2016 11:23 pm (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Ahmad,

Berapapun datanya tidak masalah, yg penting bagaimana anda menyusun datanya sesuai dgn kaidah database..

TerimaKasih.

Sent from Yahoo Mail on Android

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

3

Bls: [belajar-excel] Userform untuk multiuser [1 Attachment]

Thu Mar 3, 2016 9:16 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Coba di buka2 lagi file2 sebelumnya di milis ini, ada banyak contoh seperti apa yang anda inginkan.

TerimaKasih.

Pada Kam, 3/3/16, abcdefghijkl1983@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] Userform untuk multiuser [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Kamis, 3 Maret, 2016, 7:38 PM


 









Saya awam tentang ms excel tapi saya ingin
memasukan nilai siswa dengan menggunakan userform excel, dan
input data nilai tersebut dilakukan oleh beberapa orang
dengan pc yang berbeda (Workbook di sharing) pada waktu
bersamaan, bagaimana kode macro ketika tombol Add diKlik,
mohon bantuan dan pejelasannya.

Atas penjelasanannya saya ucapkan terimakasih
banyak.

contoh file ada di
lampiran











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

#yiv1791740352 #yiv1791740352ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1791740352 #yiv1791740352ygrp-mkp #yiv1791740352hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1791740352 #yiv1791740352ygrp-mkp #yiv1791740352ads {
margin-bottom:10px;}

#yiv1791740352 #yiv1791740352ygrp-mkp .yiv1791740352ad {
padding:0 0;}

#yiv1791740352 #yiv1791740352ygrp-mkp .yiv1791740352ad p {
margin:0;}

#yiv1791740352 #yiv1791740352ygrp-mkp .yiv1791740352ad a {
color:#0000ff;text-decoration:none;}
#yiv1791740352 #yiv1791740352ygrp-sponsor
#yiv1791740352ygrp-lc {
font-family:Arial;}

#yiv1791740352 #yiv1791740352ygrp-sponsor
#yiv1791740352ygrp-lc #yiv1791740352hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1791740352 #yiv1791740352ygrp-sponsor
#yiv1791740352ygrp-lc .yiv1791740352ad {
margin-bottom:10px;padding:0 0;}

#yiv1791740352 #yiv1791740352actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv1791740352 #yiv1791740352activity span {
font-weight:700;}

#yiv1791740352 #yiv1791740352activity span:first-child {
text-transform:uppercase;}

#yiv1791740352 #yiv1791740352activity span a {
color:#5085b6;text-decoration:none;}

#yiv1791740352 #yiv1791740352activity span span {
color:#ff7900;}

#yiv1791740352 #yiv1791740352activity span
.yiv1791740352underline {
text-decoration:underline;}

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

#yiv1791740352 .yiv1791740352attach div a {
text-decoration:none;}

#yiv1791740352 .yiv1791740352attach img {
border:none;padding-right:5px;}

#yiv1791740352 .yiv1791740352attach label {
display:block;margin-bottom:5px;}

#yiv1791740352 .yiv1791740352attach label a {
text-decoration:none;}

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

#yiv1791740352 .yiv1791740352bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1791740352 .yiv1791740352bold a {
text-decoration:none;}

#yiv1791740352 dd.yiv1791740352last p a {
font-family:Verdana;font-weight:700;}

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

#yiv1791740352 dd.yiv1791740352last p
span.yiv1791740352yshortcuts {
margin-right:0;}

#yiv1791740352 div.yiv1791740352attach-table div div a {
text-decoration:none;}

#yiv1791740352 div.yiv1791740352attach-table {
width:400px;}

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

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

#yiv1791740352 div#yiv1791740352ygrp-mlmsg
#yiv1791740352ygrp-msg p a span.yiv1791740352yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1791740352 .yiv1791740352green {
color:#628c2a;}

#yiv1791740352 .yiv1791740352MsoNormal {
margin:0 0 0 0;}

#yiv1791740352 o {
font-size:0;}

#yiv1791740352 #yiv1791740352photos div {
float:left;width:72px;}

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

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

#yiv1791740352 #yiv1791740352reco-category {
font-size:77%;}

#yiv1791740352 #yiv1791740352reco-desc {
font-size:77%;}

#yiv1791740352 .yiv1791740352replbq {
margin:4px;}

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

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

#yiv1791740352 #yiv1791740352ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv1791740352 #yiv1791740352ygrp-mlmsg pre, #yiv1791740352
code {
font:115% monospace;}

#yiv1791740352 #yiv1791740352ygrp-mlmsg * {
line-height:1.22em;}

#yiv1791740352 #yiv1791740352ygrp-mlmsg #yiv1791740352logo {
padding-bottom:10px;}


#yiv1791740352 #yiv1791740352ygrp-msg p a {
font-family:Verdana;}

#yiv1791740352 #yiv1791740352ygrp-msg
p#yiv1791740352attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1791740352 #yiv1791740352ygrp-reco
#yiv1791740352reco-head {
color:#ff7900;font-weight:700;}

#yiv1791740352 #yiv1791740352ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1791740352 #yiv1791740352ygrp-sponsor #yiv1791740352ov
li a {
font-size:130%;text-decoration:none;}

#yiv1791740352 #yiv1791740352ygrp-sponsor #yiv1791740352ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1791740352 #yiv1791740352ygrp-sponsor #yiv1791740352ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1791740352 #yiv1791740352ygrp-text {
font-family:Georgia;}

#yiv1791740352 #yiv1791740352ygrp-text p {
margin:0 0 1em 0;}

#yiv1791740352 #yiv1791740352ygrp-text tt {
font-size:120%;}

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

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

4a

Re: Bls: [belajar-excel] KONVERSI OTOMATIS

Thu Mar 3, 2016 4:20 pm (PST) . Posted by:

mr.lukman81

Dear Mr. Susilo,





Terimakasih, formula sesuai.










Br,


Lukman

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

5a

Re: Mengambil data (cell) dari berbagai sheet bila ditemukan kriteri

Thu Mar 3, 2016 4:21 pm (PST) . Posted by:

"riansutarsa" riansutarsa

hallo Mr. Kid
saya coba di lookup yang sheet nya banyak hasilnya kok nol (0) ya?
kira kira kendalanya apa ya?

Sent from my Samsung Galaxy smartphone.

-------- Original message --------
From: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Date:01/03/2016 5:40 PM (GMT+07:00)
To: BeExcel <belajar-excel@yahoogroups.com>
Cc:
Subject: Re: [belajar-excel] Mengambil data (cell) dari berbagai sheet bila ditemukan kriteria yang sama dengan yang dicari

Hai Rian,Kira-kira susunan formulanya :=IFError( vLookUp( nilai_sheetfull , tabel_sheet1 , 2 , 0 ) , IFError( vLookUp( nilai_sheetfull , tabel_sheet2 , 2 , 0 ) , dst ) )dst diisi dengan formula IFError( vLookup() , seperti bentuk awal dengan menyesuaikan rujukan tabel array-nya.Jika ada N sheet data, maka akan ada N IFError( vLookUp() , )Regards,Kid2016-03-01 13:24 GMT+07:00 Rian Sutarsa riansutarsa@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: saya ingat ingat lupa mengenai kasus ini. bagi para Masters mohon pencerahannya.jadi kasusnya, saya mempunyai 1 sheet full data misal dengan data berisi: A1=A, A2=B, A3=C, A4=D, A5=E dst. di beberapa sheet yang lain data data tersebut ditemukan tak beraturan misal sheet 2: A1=C, A2=A, B1&B2=sheetdua,sheet 3: A1=D, A2=B, B1&B2=sheettiga, sheet 4: A1=E, B1=sheetempatdst.jadi yang ingin saya tanyakan bagaimana rumusnya bila di sheet 1 (data full) untuk mengisi kolom B dengan berisikan data di sheet-sheet yang ditemukan didalamnya seperti contoh diatas.

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

5b

Re: Mengambil data (cell) dari berbagai sheet bila ditemukan kriteri

Thu Mar 3, 2016 4:22 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Mungkin ada nilai yang 0 di sheet tujuan. Atau ada pola yang kurang pas
dalam menyusun formulanya.

2016-03-04 6:58 GMT+07:00 riansutarsa riansutarsa@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:

>
>
> hallo Mr. Kid
> saya coba di lookup yang sheet nya banyak hasilnya kok nol (0) ya?
> kira kira kendalanya apa ya?
>
>
>
> Sent from my Samsung Galaxy smartphone.
>
>
> -------- Original message --------
> From: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> Date:01/03/2016 5:40 PM (GMT+07:00)
> To: BeExcel <belajar-excel@yahoogroups.com>
> Cc:
> Subject: Re: [belajar-excel] Mengambil data (cell) dari berbagai sheet
> bila ditemukan kriteria yang sama dengan yang dicari
>
>
>
> Hai Rian,
>
> Kira-kira susunan formulanya :
> =*IFError( vLookUp( nilai_sheetfull , tabel_sheet1 , 2 , 0 ) , IFError(
> vLookUp( nilai_sheetfull , tabel_sheet2 , 2 , 0 ) ,* dst ) * )*
> dst diisi dengan formula IFError( vLookup() , seperti bentuk awal dengan
> menyesuaikan rujukan tabel array-nya.
> Jika ada N sheet data, maka akan ada N IFError( vLookUp() , )
>
> Regards,
> Kid
>
>
>
>
> 2016-03-01 13:24 GMT+07:00 Rian Sutarsa riansutarsa@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>>
>>
>> saya ingat ingat lupa mengenai kasus ini. bagi para Masters mohon
>> pencerahannya.
>>
>> jadi kasusnya, saya mempunyai 1 sheet full data misal dengan data berisi:
>> A1=A, A2=B, A3=C, A4=D, A5=E dst. di beberapa sheet yang lain data data
>> tersebut ditemukan tak beraturan misal
>> sheet 2: A1=C, A2=A, B1&B2=sheetdua,
>> sheet 3: A1=D, A2=B, B1&B2=sheettiga,
>> sheet 4: A1=E, B1=sheetempat
>> dst.
>>
>> jadi yang ingin saya tanyakan bagaimana rumusnya bila di sheet 1 (data
>> full) untuk mengisi kolom B dengan berisikan data di sheet-sheet yang
>> ditemukan didalamnya seperti contoh diatas.
>>
>>
>
>

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

6

HITUNG MULTI KRITERIA

Thu Mar 3, 2016 6:09 pm (PST) . Posted by:

"imam cahyo yuwono"

Dear Expert
mohon bantuan perhitungan multi kriteria seperti contoh terlampirformula yang saya coba gagal apa yang salahnyajika menggunakan macro bagaimana script nya inginnya otomatis

terima kasih

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

7a

Bls: [belajar-excel] cara refresh otomatis file tautan Vlookup

Thu Mar 3, 2016 11:20 pm (PST) . Posted by:

"Cito Akbar" cito.akbar

Dear Mr. Kid,
saya baru tau ada menu shortcut ini dan kemudian google, terima kasih mr.kid atas sarannya.
ada satu pertanyaan lagi Mr. Kid,
Jika ingin Close all data tersebut dengan cara Shift + klik menu File, kenapa tidak muncul ya Mr. Kid?
apakah perlu kondisi tertentu agar menu tersebut muncul.
terima kasih.
regardsakbar
Dari: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
Dikirim: Kamis, 3 Maret 2016 15:14
Judul: Re: [belajar-excel] cara refresh otomatis file tautan Vlookup

  Kalau nama file atau lokasi file yang dirujuk oleh sebuah formula link ke workbook lain telah berubah, maka Excel akan menanyakan dimana file tersebut walaupun nilai data di dalam file tidak ada yang diubah dan di-save.

Kalau nama file dan lokasinya tetap, data yang diubah sudah di-save, andaikan tidak terupdate otomatis, buka file tersebut bersama-sama dengan workbook berisi formula yang merujuk ke workbook lain. Lalu save as excel workspace kalau tidak mau repot membuka satu per satu file yang dirujuk oleh formula.

2016-03-02 13:26 GMT+07:00 Cito Akbar cito.akbar@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Dear Para Master Excel,
saya ada kendala dengan data saya yang lumayan sudah byk dan fileny sudah besar,

kenapa untuk data dengan formula tidak bisa langsung update jika data dari penulusuran sudah diganti, fungsi vlookup,

saya mesti pilih lagi secara manual untuk file penelusurannya tersebut.
apa yang harus saya lakukan agar data saya itu selalu update dengan data penelusuran tersebut jika data dipenelusaran tersebut diupdate/diganti.

Thanks in advance.
regardscito akbar


#yiv0067106707 #yiv0067106707 -- #yiv0067106707ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0067106707 #yiv0067106707ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0067106707 #yiv0067106707ygrp-mkp #yiv0067106707hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0067106707 #yiv0067106707ygrp-mkp #yiv0067106707ads {margin-bottom:10px;}#yiv0067106707 #yiv0067106707ygrp-mkp .yiv0067106707ad {padding:0 0;}#yiv0067106707 #yiv0067106707ygrp-mkp .yiv0067106707ad p {margin:0;}#yiv0067106707 #yiv0067106707ygrp-mkp .yiv0067106707ad a {color:#0000ff;text-decoration:none;}#yiv0067106707 #yiv0067106707ygrp-sponsor #yiv0067106707ygrp-lc {font-family:Arial;}#yiv0067106707 #yiv0067106707ygrp-sponsor #yiv0067106707ygrp-lc #yiv0067106707hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0067106707 #yiv0067106707ygrp-sponsor #yiv0067106707ygrp-lc .yiv0067106707ad {margin-bottom:10px;padding:0 0;}#yiv0067106707 #yiv0067106707actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0067106707 #yiv0067106707activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0067106707 #yiv0067106707activity span {font-weight:700;}#yiv0067106707 #yiv0067106707activity span:first-child {text-transform:uppercase;}#yiv0067106707 #yiv0067106707activity span a {color:#5085b6;text-decoration:none;}#yiv0067106707 #yiv0067106707activity span span {color:#ff7900;}#yiv0067106707 #yiv0067106707activity span .yiv0067106707underline {text-decoration:underline;}#yiv0067106707 .yiv0067106707attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0067106707 .yiv0067106707attach div a {text-decoration:none;}#yiv0067106707 .yiv0067106707attach img {border:none;padding-right:5px;}#yiv0067106707 .yiv0067106707attach label {display:block;margin-bottom:5px;}#yiv0067106707 .yiv0067106707attach label a {text-decoration:none;}#yiv0067106707 blockquote {margin:0 0 0 4px;}#yiv0067106707 .yiv0067106707bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0067106707 .yiv0067106707bold a {text-decoration:none;}#yiv0067106707 dd.yiv0067106707last p a {font-family:Verdana;font-weight:700;}#yiv0067106707 dd.yiv0067106707last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0067106707 dd.yiv0067106707last p span.yiv0067106707yshortcuts {margin-right:0;}#yiv0067106707 div.yiv0067106707attach-table div div a {text-decoration:none;}#yiv0067106707 div.yiv0067106707attach-table {width:400px;}#yiv0067106707 div.yiv0067106707file-title a, #yiv0067106707 div.yiv0067106707file-title a:active, #yiv0067106707 div.yiv0067106707file-title a:hover, #yiv0067106707 div.yiv0067106707file-title a:visited {text-decoration:none;}#yiv0067106707 div.yiv0067106707photo-title a, #yiv0067106707 div.yiv0067106707photo-title a:active, #yiv0067106707 div.yiv0067106707photo-title a:hover, #yiv0067106707 div.yiv0067106707photo-title a:visited {text-decoration:none;}#yiv0067106707 div#yiv0067106707ygrp-mlmsg #yiv0067106707ygrp-msg p a span.yiv0067106707yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0067106707 .yiv0067106707green {color:#628c2a;}#yiv0067106707 .yiv0067106707MsoNormal {margin:0 0 0 0;}#yiv0067106707 o {font-size:0;}#yiv0067106707 #yiv0067106707photos div {float:left;width:72px;}#yiv0067106707 #yiv0067106707photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0067106707 #yiv0067106707photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0067106707 #yiv0067106707reco-category {font-size:77%;}#yiv0067106707 #yiv0067106707reco-desc {font-size:77%;}#yiv0067106707 .yiv0067106707replbq {margin:4px;}#yiv0067106707 #yiv0067106707ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0067106707 #yiv0067106707ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0067106707 #yiv0067106707ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0067106707 #yiv0067106707ygrp-mlmsg select, #yiv0067106707 input, #yiv0067106707 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0067106707 #yiv0067106707ygrp-mlmsg pre, #yiv0067106707 code {font:115% monospace;}#yiv0067106707 #yiv0067106707ygrp-mlmsg * {line-height:1.22em;}#yiv0067106707 #yiv0067106707ygrp-mlmsg #yiv0067106707logo {padding-bottom:10px;}#yiv0067106707 #yiv0067106707ygrp-msg p a {font-family:Verdana;}#yiv0067106707 #yiv0067106707ygrp-msg p#yiv0067106707attach-count span {color:#1E66AE;font-weight:700;}#yiv0067106707 #yiv0067106707ygrp-reco #yiv0067106707reco-head {color:#ff7900;font-weight:700;}#yiv0067106707 #yiv0067106707ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0067106707 #yiv0067106707ygrp-sponsor #yiv0067106707ov li a {font-size:130%;text-decoration:none;}#yiv0067106707 #yiv0067106707ygrp-sponsor #yiv0067106707ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0067106707 #yiv0067106707ygrp-sponsor #yiv0067106707ov ul {margin:0;padding:0 0 0 8px;}#yiv0067106707 #yiv0067106707ygrp-text {font-family:Georgia;}#yiv0067106707 #yiv0067106707ygrp-text p {margin:0 0 1em 0;}#yiv0067106707 #yiv0067106707ygrp-text tt {font-size:120%;}#yiv0067106707 #yiv0067106707ygrp-vital ul li:last-child {border-right:none !important;}#yiv0067106707

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

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 10

• Privacy • Unsubscribe • Terms of Use