Kamis, 03 Maret 2016

[belajar-excel] Digest Number 3784

1 Message

Digest #3784
1a
Bls: [belajar-excel] Help Formula filter by "Ahmad Habibillah" abiel_1108

Message

Thu Mar 3, 2016 2:07 am (PST) . Posted by:

"Ahmad Habibillah" abiel_1108

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
#yiv9905377710 #yiv9905377710 -- #yiv9905377710ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9905377710 #yiv9905377710ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9905377710 #yiv9905377710ygrp-mkp #yiv9905377710hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9905377710 #yiv9905377710ygrp-mkp #yiv9905377710ads {margin-bottom:10px;}#yiv9905377710 #yiv9905377710ygrp-mkp .yiv9905377710ad {padding:0 0;}#yiv9905377710 #yiv9905377710ygrp-mkp .yiv9905377710ad p {margin:0;}#yiv9905377710 #yiv9905377710ygrp-mkp .yiv9905377710ad a {color:#0000ff;text-decoration:none;}#yiv9905377710 #yiv9905377710ygrp-sponsor #yiv9905377710ygrp-lc {font-family:Arial;}#yiv9905377710 #yiv9905377710ygrp-sponsor #yiv9905377710ygrp-lc #yiv9905377710hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9905377710 #yiv9905377710ygrp-sponsor #yiv9905377710ygrp-lc .yiv9905377710ad {margin-bottom:10px;padding:0 0;}#yiv9905377710 #yiv9905377710actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9905377710 #yiv9905377710activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9905377710 #yiv9905377710activity span {font-weight:700;}#yiv9905377710 #yiv9905377710activity span:first-child {text-transform:uppercase;}#yiv9905377710 #yiv9905377710activity span a {color:#5085b6;text-decoration:none;}#yiv9905377710 #yiv9905377710activity span span {color:#ff7900;}#yiv9905377710 #yiv9905377710activity span .yiv9905377710underline {text-decoration:underline;}#yiv9905377710 .yiv9905377710attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9905377710 .yiv9905377710attach div a {text-decoration:none;}#yiv9905377710 .yiv9905377710attach img {border:none;padding-right:5px;}#yiv9905377710 .yiv9905377710attach label {display:block;margin-bottom:5px;}#yiv9905377710 .yiv9905377710attach label a {text-decoration:none;}#yiv9905377710 blockquote {margin:0 0 0 4px;}#yiv9905377710 .yiv9905377710bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9905377710 .yiv9905377710bold a {text-decoration:none;}#yiv9905377710 dd.yiv9905377710last p a {font-family:Verdana;font-weight:700;}#yiv9905377710 dd.yiv9905377710last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9905377710 dd.yiv9905377710last p span.yiv9905377710yshortcuts {margin-right:0;}#yiv9905377710 div.yiv9905377710attach-table div div a {text-decoration:none;}#yiv9905377710 div.yiv9905377710attach-table {width:400px;}#yiv9905377710 div.yiv9905377710file-title a, #yiv9905377710 div.yiv9905377710file-title a:active, #yiv9905377710 div.yiv9905377710file-title a:hover, #yiv9905377710 div.yiv9905377710file-title a:visited {text-decoration:none;}#yiv9905377710 div.yiv9905377710photo-title a, #yiv9905377710 div.yiv9905377710photo-title a:active, #yiv9905377710 div.yiv9905377710photo-title a:hover, #yiv9905377710 div.yiv9905377710photo-title a:visited {text-decoration:none;}#yiv9905377710 div#yiv9905377710ygrp-mlmsg #yiv9905377710ygrp-msg p a span.yiv9905377710yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9905377710 .yiv9905377710green {color:#628c2a;}#yiv9905377710 .yiv9905377710MsoNormal {margin:0 0 0 0;}#yiv9905377710 o {font-size:0;}#yiv9905377710 #yiv9905377710photos div {float:left;width:72px;}#yiv9905377710 #yiv9905377710photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9905377710 #yiv9905377710photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9905377710 #yiv9905377710reco-category {font-size:77%;}#yiv9905377710 #yiv9905377710reco-desc {font-size:77%;}#yiv9905377710 .yiv9905377710replbq {margin:4px;}#yiv9905377710 #yiv9905377710ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9905377710 #yiv9905377710ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9905377710 #yiv9905377710ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9905377710 #yiv9905377710ygrp-mlmsg select, #yiv9905377710 input, #yiv9905377710 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9905377710 #yiv9905377710ygrp-mlmsg pre, #yiv9905377710 code {font:115% monospace;}#yiv9905377710 #yiv9905377710ygrp-mlmsg * {line-height:1.22em;}#yiv9905377710 #yiv9905377710ygrp-mlmsg #yiv9905377710logo {padding-bottom:10px;}#yiv9905377710 #yiv9905377710ygrp-msg p a {font-family:Verdana;}#yiv9905377710 #yiv9905377710ygrp-msg p#yiv9905377710attach-count span {color:#1E66AE;font-weight:700;}#yiv9905377710 #yiv9905377710ygrp-reco #yiv9905377710reco-head {color:#ff7900;font-weight:700;}#yiv9905377710 #yiv9905377710ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9905377710 #yiv9905377710ygrp-sponsor #yiv9905377710ov li a {font-size:130%;text-decoration:none;}#yiv9905377710 #yiv9905377710ygrp-sponsor #yiv9905377710ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9905377710 #yiv9905377710ygrp-sponsor #yiv9905377710ov ul {margin:0;padding:0 0 0 8px;}#yiv9905377710 #yiv9905377710ygrp-text {font-family:Georgia;}#yiv9905377710 #yiv9905377710ygrp-text p {margin:0 0 1em 0;}#yiv9905377710 #yiv9905377710ygrp-text tt {font-size:120%;}#yiv9905377710 #yiv9905377710ygrp-vital ul li:last-child {border-right:none !important;}#yiv9905377710

============================================================
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
---------------------------------------------------------------------
Diposting oleh EXCEL FEED LEARNING di 02.15

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)