Terima kasih para Master dan anggota milis ini atas solusi yg diberikan. Solusi yg diberikan sudah memenuhi harapan. Semoga Allah SWT membalasnya dengan kebaikan (keberkahan) yg banyak. Amin
On Wed, Feb 22, 2017 at 5:40 AM, ghozi alkatiri [email protected] [belajar-excel] <[email protected]> wrote: > > > solusi dengan formula > lihat attachment di sheet solusi > > wassalam > > Ghozi Alkatiri > -------------------------------------------- > Pada Sel, 21/2/17, asam gatal [email protected] [belajar-excel] < > [email protected]> menulis: > > Judul: [belajar-excel] Meng-update nama barang [1 Attachment] > Kepada: [email protected] > Tanggal: Selasa, 21 Februari, 2017, 12:04 PM > > > > > > > > > > > > > Kepada para master dan segenap > anggota milis. Mohon dibantu. > > Bagaimana meng-update total barang pada sheet > Total, > sehingga nama barang yang sama > dikelompokkan menjadi 1 nama saja. > Kasus ini > memang bisa diselesaikan dengan pivot tabel, > tetapi saya ingin pakai rumus atau tombol > perintah. Silakan lihat lampiran. > > Atas bantuannya saya ucapkan terima > kasih. > > > > > > > > > > > > #yiv4640929496 #yiv4640929496 -- > #yiv4640929496ygrp-mkp { > border:1px solid #d8d8d8;font-family:Arial;margin:10px > 0;padding:0 10px;} > > #yiv4640929496 #yiv4640929496ygrp-mkp hr { > border:1px solid #d8d8d8;} > > #yiv4640929496 #yiv4640929496ygrp-mkp #yiv4640929496hd { > color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px > 0;} > > #yiv4640929496 #yiv4640929496ygrp-mkp #yiv4640929496ads { > margin-bottom:10px;} > > #yiv4640929496 #yiv4640929496ygrp-mkp .yiv4640929496ad { > padding:0 0;} > > #yiv4640929496 #yiv4640929496ygrp-mkp .yiv4640929496ad p { > margin:0;} > > #yiv4640929496 #yiv4640929496ygrp-mkp .yiv4640929496ad a { > color:#0000ff;text-decoration:none;} > #yiv4640929496 #yiv4640929496ygrp-sponsor > #yiv4640929496ygrp-lc { > font-family:Arial;} > > #yiv4640929496 #yiv4640929496ygrp-sponsor > #yiv4640929496ygrp-lc #yiv4640929496hd { > margin:10px > 0px;font-weight:700;font-size:78%;line-height:122%;} > > #yiv4640929496 #yiv4640929496ygrp-sponsor > #yiv4640929496ygrp-lc .yiv4640929496ad { > margin-bottom:10px;padding:0 0;} > > #yiv4640929496 #yiv4640929496actions { > font-family:Verdana;font-size:11px;padding:10px 0;} > > #yiv4640929496 #yiv4640929496activity { > background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px; > padding:10px;} > > #yiv4640929496 #yiv4640929496activity span { > font-weight:700;} > > #yiv4640929496 #yiv4640929496activity span:first-child { > text-transform:uppercase;} > > #yiv4640929496 #yiv4640929496activity span a { > color:#5085b6;text-decoration:none;} > > #yiv4640929496 #yiv4640929496activity span span { > color:#ff7900;} > > #yiv4640929496 #yiv4640929496activity span > .yiv4640929496underline { > text-decoration:underline;} > > #yiv4640929496 .yiv4640929496attach { > clear:both;display:table;font-family:Arial;font-size:12px;padding:10px > 0;width:400px;} > > #yiv4640929496 .yiv4640929496attach div a { > text-decoration:none;} > > #yiv4640929496 .yiv4640929496attach img { > border:none;padding-right:5px;} > > #yiv4640929496 .yiv4640929496attach label { > display:block;margin-bottom:5px;} > > #yiv4640929496 .yiv4640929496attach label a { > text-decoration:none;} > > #yiv4640929496 blockquote { > margin:0 0 0 4px;} > > #yiv4640929496 .yiv4640929496bold { > font-family:Arial;font-size:13px;font-weight:700;} > > #yiv4640929496 .yiv4640929496bold a { > text-decoration:none;} > > #yiv4640929496 dd.yiv4640929496last p a { > font-family:Verdana;font-weight:700;} > > #yiv4640929496 dd.yiv4640929496last p span { > margin-right:10px;font-family:Verdana;font-weight:700;} > > #yiv4640929496 dd.yiv4640929496last p > span.yiv4640929496yshortcuts { > margin-right:0;} > > #yiv4640929496 div.yiv4640929496attach-table div div a { > text-decoration:none;} > > #yiv4640929496 div.yiv4640929496attach-table { > width:400px;} > > #yiv4640929496 div.yiv4640929496file-title a, #yiv4640929496 > div.yiv4640929496file-title a:active, #yiv4640929496 > div.yiv4640929496file-title a:hover, #yiv4640929496 > div.yiv4640929496file-title a:visited { > text-decoration:none;} > > #yiv4640929496 div.yiv4640929496photo-title a, > #yiv4640929496 div.yiv4640929496photo-title a:active, > #yiv4640929496 div.yiv4640929496photo-title a:hover, > #yiv4640929496 div.yiv4640929496photo-title a:visited { > text-decoration:none;} > > #yiv4640929496 div#yiv4640929496ygrp-mlmsg > #yiv4640929496ygrp-msg p a span.yiv4640929496yshortcuts { > font-family:Verdana;font-size:10px;font-weight:normal;} > > #yiv4640929496 .yiv4640929496green { > color:#628c2a;} > > #yiv4640929496 .yiv4640929496MsoNormal { > margin:0 0 0 0;} > > #yiv4640929496 o { > font-size:0;} > > #yiv4640929496 #yiv4640929496photos div { > float:left;width:72px;} > > #yiv4640929496 #yiv4640929496photos div div { > border:1px solid > #666666;height:62px;overflow:hidden;width:62px;} > > #yiv4640929496 #yiv4640929496photos div label { > color:#666666;font-size:10px;overflow:hidden;text-align: > center;white-space:nowrap;width:64px;} > > #yiv4640929496 #yiv4640929496reco-category { > font-size:77%;} > > #yiv4640929496 #yiv4640929496reco-desc { > font-size:77%;} > > #yiv4640929496 .yiv4640929496replbq { > margin:4px;} > > #yiv4640929496 #yiv4640929496ygrp-actbar div a:first-child { > margin-right:2px;padding-right:5px;} > > #yiv4640929496 #yiv4640929496ygrp-mlmsg { > font-size:13px;font-family:Arial, helvetica, clean, > sans-serif;} > > #yiv4640929496 #yiv4640929496ygrp-mlmsg table { > font-size:inherit;font:100%;} > > #yiv4640929496 #yiv4640929496ygrp-mlmsg select, > #yiv4640929496 input, #yiv4640929496 textarea { > font:99% Arial, Helvetica, clean, sans-serif;} > > #yiv4640929496 #yiv4640929496ygrp-mlmsg pre, #yiv4640929496 > code { > font:115% monospace;} > > #yiv4640929496 #yiv4640929496ygrp-mlmsg * { > line-height:1.22em;} > > #yiv4640929496 #yiv4640929496ygrp-mlmsg #yiv4640929496logo { > padding-bottom:10px;} > > > #yiv4640929496 #yiv4640929496ygrp-msg p a { > font-family:Verdana;} > > #yiv4640929496 #yiv4640929496ygrp-msg > p#yiv4640929496attach-count span { > color:#1E66AE;font-weight:700;} > > #yiv4640929496 #yiv4640929496ygrp-reco > #yiv4640929496reco-head { > color:#ff7900;font-weight:700;} > > #yiv4640929496 #yiv4640929496ygrp-reco { > margin-bottom:20px;padding:0px;} > > #yiv4640929496 #yiv4640929496ygrp-sponsor #yiv4640929496ov > li a { > font-size:130%;text-decoration:none;} > > #yiv4640929496 #yiv4640929496ygrp-sponsor #yiv4640929496ov > li { > font-size:77%;list-style-type:square;padding:6px 0;} > > #yiv4640929496 #yiv4640929496ygrp-sponsor #yiv4640929496ov > ul { > margin:0;padding:0 0 0 8px;} > > #yiv4640929496 #yiv4640929496ygrp-text { > font-family:Georgia;} > > #yiv4640929496 #yiv4640929496ygrp-text p { > margin:0 0 1em 0;} > > #yiv4640929496 #yiv4640929496ygrp-text tt { > font-size:120%;} > > #yiv4640929496 #yiv4640929496ygrp-vital ul li:last-child { > border-right:none !important; > } > #yiv4640929496 > >
