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 [email protected]
[belajar-excel]" <[email protected]> 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 [email protected] [belajar-excel]
<[email protected]> menulis:
Judul: [belajar-excel] Help Formula filter
Kepada: [email protected]
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
Ask Formula 2.xlsx
Description: MS-Excel 2007 spreadsheet
