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 [email protected]
[belajar-excel]" <[email protected]> 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 [email protected] [belajar-excel]
<[email protected]> menulis:
Judul: Bls: [belajar-excel] Help Formula filter [1 Attachment]
Kepada: [email protected]
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 [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
#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
