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 [email protected] [belajar-excel] < [email protected]>: > > > 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 > > >
Ask Formula (jawab).xlsx
Description: MS-Excel 2007 spreadsheet
