Senin, 23 November 2015

[belajar-excel] Digest Number 3653

5 Messages

Digest #3653

Messages

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

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

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

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

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

fathianm

Mohon bantuan lagi , file terlampir
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar