[belajar-excel] Digest Number 3653

Milis Belajar Microsoft Excel Group

5 Messages

Digest #3653

1

Penganti Vlookup agar data tidak berat by "Yudi Dwiyono"

2a

Menjumlahkan Penjualan dari total penjualan masing-masing daerah by "Denny Oktavianus" denny_y86

2b

Bls: [belajar-excel] Menjumlahkan Penjualan dari total penjualan mas by "odong nando"

2c

Bls: [belajar-excel] Menjumlahkan Penjualan dari total penjualan mas by "odong nando"

3

COPY PASTE VALUE OTOMATIS ANTAR SHEET by fathianm

Messages

1

Penganti Vlookup agar data tidak berat

Sun Nov 22, 2015 8:26 pm (PST) . Posted by:

"Yudi Dwiyono"

Dear all,

Apakah ada rumus penganti vlookup agar data tidak berat? karena row semakin
lama akan semakin banyak otomatis membuat berat file.
Thanks.

Regards,
Yudi

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2a

Menjumlahkan Penjualan dari total penjualan masing-masing daerah

Sun Nov 22, 2015 8:26 pm (PST) . Posted by:

"Denny Oktavianus" denny_y86

Selamat Pagi,
Mohon bantuannya untuk data ini.penjumlahan penjualan dari produk dengan tabel harga sesuai daerah masing,
saya ucapkan terima kasih atas bantuannya.
salam
Denny

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2b

Bls: [belajar-excel] Menjumlahkan Penjualan dari total penjualan mas

Mon Nov 23, 2015 1:49 am (PST) . Posted by:

"odong nando"

yoo deny,bisa pake sumproduck kok,coba masukan 
=SUMPRODUCT( ( $ A $ 2 : $ A $ 4 = H 2 ) * $ B $ 2 : $ E $ 4 ;( $ A $ 2 : $ A $ 4 = H 2 ) * $ I 2 : $ L 2 ) pada cell M2,
br,

odong nando


Pada Senin, 23 November 2015 11:27, "Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
Selamat Pagi,
Mohon bantuannya untuk data ini.penjumlahan penjualan dari produk dengan tabel harga sesuai daerah masing,
saya ucapkan terima kasih atas bantuannya.
salam
Denny

#yiv9862709351 #yiv9862709351 -- #yiv9862709351ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9862709351 #yiv9862709351ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9862709351 #yiv9862709351ygrp-mkp #yiv9862709351hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9862709351 #yiv9862709351ygrp-mkp #yiv9862709351ads {margin-bottom:10px;}#yiv9862709351 #yiv9862709351ygrp-mkp .yiv9862709351ad {padding:0 0;}#yiv9862709351 #yiv9862709351ygrp-mkp .yiv9862709351ad p {margin:0;}#yiv9862709351 #yiv9862709351ygrp-mkp .yiv9862709351ad a {color:#0000ff;text-decoration:none;}#yiv9862709351 #yiv9862709351ygrp-sponsor #yiv9862709351ygrp-lc {font-family:Arial;}#yiv9862709351 #yiv9862709351ygrp-sponsor #yiv9862709351ygrp-lc #yiv9862709351hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9862709351 #yiv9862709351ygrp-sponsor #yiv9862709351ygrp-lc .yiv9862709351ad {margin-bottom:10px;padding:0 0;}#yiv9862709351 #yiv9862709351actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9862709351 #yiv9862709351activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9862709351 #yiv9862709351activity span {font-weight:700;}#yiv9862709351 #yiv9862709351activity span:first-child {text-transform:uppercase;}#yiv9862709351 #yiv9862709351activity span a {color:#5085b6;text-decoration:none;}#yiv9862709351 #yiv9862709351activity span span {color:#ff7900;}#yiv9862709351 #yiv9862709351activity span .yiv9862709351underline {text-decoration:underline;}#yiv9862709351 .yiv9862709351attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9862709351 .yiv9862709351attach div a {text-decoration:none;}#yiv9862709351 .yiv9862709351attach img {border:none;padding-right:5px;}#yiv9862709351 .yiv9862709351attach label {display:block;margin-bottom:5px;}#yiv9862709351 .yiv9862709351attach label a {text-decoration:none;}#yiv9862709351 blockquote {margin:0 0 0 4px;}#yiv9862709351 .yiv9862709351bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9862709351 .yiv9862709351bold a {text-decoration:none;}#yiv9862709351 dd.yiv9862709351last p a {font-family:Verdana;font-weight:700;}#yiv9862709351 dd.yiv9862709351last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9862709351 dd.yiv9862709351last p span.yiv9862709351yshortcuts {margin-right:0;}#yiv9862709351 div.yiv9862709351attach-table div div a {text-decoration:none;}#yiv9862709351 div.yiv9862709351attach-table {width:400px;}#yiv9862709351 div.yiv9862709351file-title a, #yiv9862709351 div.yiv9862709351file-title a:active, #yiv9862709351 div.yiv9862709351file-title a:hover, #yiv9862709351 div.yiv9862709351file-title a:visited {text-decoration:none;}#yiv9862709351 div.yiv9862709351photo-title a, #yiv9862709351 div.yiv9862709351photo-title a:active, #yiv9862709351 div.yiv9862709351photo-title a:hover, #yiv9862709351 div.yiv9862709351photo-title a:visited {text-decoration:none;}#yiv9862709351 div#yiv9862709351ygrp-mlmsg #yiv9862709351ygrp-msg p a span.yiv9862709351yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9862709351 .yiv9862709351green {color:#628c2a;}#yiv9862709351 .yiv9862709351MsoNormal {margin:0 0 0 0;}#yiv9862709351 o {font-size:0;}#yiv9862709351 #yiv9862709351photos div {float:left;width:72px;}#yiv9862709351 #yiv9862709351photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9862709351 #yiv9862709351photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9862709351 #yiv9862709351reco-category {font-size:77%;}#yiv9862709351 #yiv9862709351reco-desc {font-size:77%;}#yiv9862709351 .yiv9862709351replbq {margin:4px;}#yiv9862709351 #yiv9862709351ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9862709351 #yiv9862709351ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9862709351 #yiv9862709351ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9862709351 #yiv9862709351ygrp-mlmsg select, #yiv9862709351 input, #yiv9862709351 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9862709351 #yiv9862709351ygrp-mlmsg pre, #yiv9862709351 code {font:115% monospace;}#yiv9862709351 #yiv9862709351ygrp-mlmsg * {line-height:1.22em;}#yiv9862709351 #yiv9862709351ygrp-mlmsg #yiv9862709351logo {padding-bottom:10px;}#yiv9862709351 #yiv9862709351ygrp-msg p a {font-family:Verdana;}#yiv9862709351 #yiv9862709351ygrp-msg p#yiv9862709351attach-count span {color:#1E66AE;font-weight:700;}#yiv9862709351 #yiv9862709351ygrp-reco #yiv9862709351reco-head {color:#ff7900;font-weight:700;}#yiv9862709351 #yiv9862709351ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9862709351 #yiv9862709351ygrp-sponsor #yiv9862709351ov li a {font-size:130%;text-decoration:none;}#yiv9862709351 #yiv9862709351ygrp-sponsor #yiv9862709351ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9862709351 #yiv9862709351ygrp-sponsor #yiv9862709351ov ul {margin:0;padding:0 0 0 8px;}#yiv9862709351 #yiv9862709351ygrp-text {font-family:Georgia;}#yiv9862709351 #yiv9862709351ygrp-text p {margin:0 0 1em 0;}#yiv9862709351 #yiv9862709351ygrp-text tt {font-size:120%;}#yiv9862709351 #yiv9862709351ygrp-vital ul li:last-child {border-right:none !important;}#yiv9862709351

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2c

Bls: [belajar-excel] Menjumlahkan Penjualan dari total penjualan mas

Mon Nov 23, 2015 1:50 am (PST) . Posted by:

"odong nando"

oiya, ganti karakter titik koma ";" dengan koma "," bila regional setting setempat english br,

odong nando


Pada Senin, 23 November 2015 16:48, odong nando <odongnando@yahoo.com> menulis:


yoo deny,bisa pake sumproduck kok,coba masukan 
=SUMPRODUCT( ( $ A $ 2 : $ A $ 4 = H 2 ) * $ B $ 2 : $ E $ 4 ;( $ A $ 2 : $ A $ 4 = H 2 ) * $ I 2 : $ L 2 ) pada cell M2,
br,

odong nando


Pada Senin, 23 November 2015 11:27, "Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
Selamat Pagi,
Mohon bantuannya untuk data ini.penjumlahan penjualan dari produk dengan tabel harga sesuai daerah masing,
saya ucapkan terima kasih atas bantuannya.
salam
Denny

#yiv3337333825 -- #yiv3337333825ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3337333825 #yiv3337333825ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3337333825 #yiv3337333825ygrp-mkp #yiv3337333825hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3337333825 #yiv3337333825ygrp-mkp #yiv3337333825ads {margin-bottom:10px;}#yiv3337333825 #yiv3337333825ygrp-mkp .yiv3337333825ad {padding:0 0;}#yiv3337333825 #yiv3337333825ygrp-mkp .yiv3337333825ad p {margin:0;}#yiv3337333825 #yiv3337333825ygrp-mkp .yiv3337333825ad a {color:#0000ff;text-decoration:none;}#yiv3337333825 #yiv3337333825ygrp-sponsor #yiv3337333825ygrp-lc {font-family:Arial;}#yiv3337333825 #yiv3337333825ygrp-sponsor #yiv3337333825ygrp-lc #yiv3337333825hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3337333825 #yiv3337333825ygrp-sponsor #yiv3337333825ygrp-lc .yiv3337333825ad {margin-bottom:10px;padding:0 0;}#yiv3337333825 #yiv3337333825actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3337333825 #yiv3337333825activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3337333825 #yiv3337333825activity span {font-weight:700;}#yiv3337333825 #yiv3337333825activity span:first-child {text-transform:uppercase;}#yiv3337333825 #yiv3337333825activity span a {color:#5085b6;text-decoration:none;}#yiv3337333825 #yiv3337333825activity span span {color:#ff7900;}#yiv3337333825 #yiv3337333825activity span .yiv3337333825underline {text-decoration:underline;}#yiv3337333825 .yiv3337333825attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3337333825 .yiv3337333825attach div a {text-decoration:none;}#yiv3337333825 .yiv3337333825attach img {border:none;padding-right:5px;}#yiv3337333825 .yiv3337333825attach label {display:block;margin-bottom:5px;}#yiv3337333825 .yiv3337333825attach label a {text-decoration:none;}#yiv3337333825 blockquote {margin:0 0 0 4px;}#yiv3337333825 .yiv3337333825bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3337333825 .yiv3337333825bold a {text-decoration:none;}#yiv3337333825 dd.yiv3337333825last p a {font-family:Verdana;font-weight:700;}#yiv3337333825 dd.yiv3337333825last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3337333825 dd.yiv3337333825last p span.yiv3337333825yshortcuts {margin-right:0;}#yiv3337333825 div.yiv3337333825attach-table div div a {text-decoration:none;}#yiv3337333825 div.yiv3337333825attach-table {width:400px;}#yiv3337333825 div.yiv3337333825file-title a, #yiv3337333825 div.yiv3337333825file-title a:active, #yiv3337333825 div.yiv3337333825file-title a:hover, #yiv3337333825 div.yiv3337333825file-title a:visited {text-decoration:none;}#yiv3337333825 div.yiv3337333825photo-title a, #yiv3337333825 div.yiv3337333825photo-title a:active, #yiv3337333825 div.yiv3337333825photo-title a:hover, #yiv3337333825 div.yiv3337333825photo-title a:visited {text-decoration:none;}#yiv3337333825 div#yiv3337333825ygrp-mlmsg #yiv3337333825ygrp-msg p a span.yiv3337333825yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3337333825 .yiv3337333825green {color:#628c2a;}#yiv3337333825 .yiv3337333825MsoNormal {margin:0 0 0 0;}#yiv3337333825 o {font-size:0;}#yiv3337333825 #yiv3337333825photos div {float:left;width:72px;}#yiv3337333825 #yiv3337333825photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3337333825 #yiv3337333825photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3337333825 #yiv3337333825reco-category {font-size:77%;}#yiv3337333825 #yiv3337333825reco-desc {font-size:77%;}#yiv3337333825 .yiv3337333825replbq {margin:4px;}#yiv3337333825 #yiv3337333825ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3337333825 #yiv3337333825ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3337333825 #yiv3337333825ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3337333825 #yiv3337333825ygrp-mlmsg select, #yiv3337333825 input, #yiv3337333825 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3337333825 #yiv3337333825ygrp-mlmsg pre, #yiv3337333825 code {font:115% monospace;}#yiv3337333825 #yiv3337333825ygrp-mlmsg * {line-height:1.22em;}#yiv3337333825 #yiv3337333825ygrp-mlmsg #yiv3337333825logo {padding-bottom:10px;}#yiv3337333825 #yiv3337333825ygrp-msg p a {font-family:Verdana;}#yiv3337333825 #yiv3337333825ygrp-msg p#yiv3337333825attach-count span {color:#1E66AE;font-weight:700;}#yiv3337333825 #yiv3337333825ygrp-reco #yiv3337333825reco-head {color:#ff7900;font-weight:700;}#yiv3337333825 #yiv3337333825ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3337333825 #yiv3337333825ygrp-sponsor #yiv3337333825ov li a {font-size:130%;text-decoration:none;}#yiv3337333825 #yiv3337333825ygrp-sponsor #yiv3337333825ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3337333825 #yiv3337333825ygrp-sponsor #yiv3337333825ov ul {margin:0;padding:0 0 0 8px;}#yiv3337333825 #yiv3337333825ygrp-text {font-family:Georgia;}#yiv3337333825 #yiv3337333825ygrp-text p {margin:0 0 1em 0;}#yiv3337333825 #yiv3337333825ygrp-text tt {font-size:120%;}#yiv3337333825 #yiv3337333825ygrp-vital ul li:last-child {border-right:none !important;}#yiv3337333825

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3

COPY PASTE VALUE OTOMATIS ANTAR SHEET

Sun Nov 22, 2015 9:13 pm (PST) . Posted by:

fathianm

Mohon bantuan lagi , file terlampir

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

============================================================
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
---------------------------------------------------------------------

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use