Jumat, 30 Oktober 2015

[belajar-excel] Digest Number 3618

15 Messages

Digest #3618
2
DATA URUT OTOMATIS by "HAIRUL ALAM"
3a
4
6a
Data Excel di Dropbox by "kiki tanjung" kieki_e
6b
Re: Data Excel di Dropbox by "Mr. Kid" nmkid.family@ymail.com
6c
Re: Data Excel di Dropbox by "hendrik karnadi" hendrikkarnadi

Messages

Thu Oct 29, 2015 2:20 am (PDT) . Posted by:

"HAIRUL ALAM"

Terimakasih Banyak Pak Odong
Maaf Kalau saya selalu tanya, Maklum saya juga pemula
TerimakasihSalam

Pada Kamis, 29 Oktober 2015 15:38, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  bisa memanfaatkan formula
=INDIRECT("F"&COLUMNS($J$2:J2)+2)

tinggal ganti F dengan kolom yang di inginkan dalam kasus ini kolom B dan E br,

odong nando


Pada Kamis, 29 Oktober 2015 15:04, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Yth. Para Master Excel
Assalamualaikum Wr. Wb.
Saya mengalami problem seperti data terlampir, Mohon Pencerahannya, agar dapat bekerja secara otomatis dengan formula dan semoga file excel dikalkulasi dengan ringan
Wassalamualaikum Wr. Wb.
TerimakasihHairul Alam

#yiv5592165847 #yiv5592165847 -- #yiv5592165847ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5592165847 #yiv5592165847ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5592165847 #yiv5592165847ygrp-mkp #yiv5592165847hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5592165847 #yiv5592165847ygrp-mkp #yiv5592165847ads {margin-bottom:10px;}#yiv5592165847 #yiv5592165847ygrp-mkp .yiv5592165847ad {padding:0 0;}#yiv5592165847 #yiv5592165847ygrp-mkp .yiv5592165847ad p {margin:0;}#yiv5592165847 #yiv5592165847ygrp-mkp .yiv5592165847ad a {color:#0000ff;text-decoration:none;}#yiv5592165847 #yiv5592165847ygrp-sponsor #yiv5592165847ygrp-lc {font-family:Arial;}#yiv5592165847 #yiv5592165847ygrp-sponsor #yiv5592165847ygrp-lc #yiv5592165847hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5592165847 #yiv5592165847ygrp-sponsor #yiv5592165847ygrp-lc .yiv5592165847ad {margin-bottom:10px;padding:0 0;}#yiv5592165847 #yiv5592165847actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5592165847 #yiv5592165847activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5592165847 #yiv5592165847activity span {font-weight:700;}#yiv5592165847 #yiv5592165847activity span:first-child {text-transform:uppercase;}#yiv5592165847 #yiv5592165847activity span a {color:#5085b6;text-decoration:none;}#yiv5592165847 #yiv5592165847activity span span {color:#ff7900;}#yiv5592165847 #yiv5592165847activity span .yiv5592165847underline {text-decoration:underline;}#yiv5592165847 .yiv5592165847attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5592165847 .yiv5592165847attach div a {text-decoration:none;}#yiv5592165847 .yiv5592165847attach img {border:none;padding-right:5px;}#yiv5592165847 .yiv5592165847attach label {display:block;margin-bottom:5px;}#yiv5592165847 .yiv5592165847attach label a {text-decoration:none;}#yiv5592165847 blockquote {margin:0 0 0 4px;}#yiv5592165847 .yiv5592165847bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5592165847 .yiv5592165847bold a {text-decoration:none;}#yiv5592165847 dd.yiv5592165847last p a {font-family:Verdana;font-weight:700;}#yiv5592165847 dd.yiv5592165847last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5592165847 dd.yiv5592165847last p span.yiv5592165847yshortcuts {margin-right:0;}#yiv5592165847 div.yiv5592165847attach-table div div a {text-decoration:none;}#yiv5592165847 div.yiv5592165847attach-table {width:400px;}#yiv5592165847 div.yiv5592165847file-title a, #yiv5592165847 div.yiv5592165847file-title a:active, #yiv5592165847 div.yiv5592165847file-title a:hover, #yiv5592165847 div.yiv5592165847file-title a:visited {text-decoration:none;}#yiv5592165847 div.yiv5592165847photo-title a, #yiv5592165847 div.yiv5592165847photo-title a:active, #yiv5592165847 div.yiv5592165847photo-title a:hover, #yiv5592165847 div.yiv5592165847photo-title a:visited {text-decoration:none;}#yiv5592165847 div#yiv5592165847ygrp-mlmsg #yiv5592165847ygrp-msg p a span.yiv5592165847yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5592165847 .yiv5592165847green {color:#628c2a;}#yiv5592165847 .yiv5592165847MsoNormal {margin:0 0 0 0;}#yiv5592165847 o {font-size:0;}#yiv5592165847 #yiv5592165847photos div {float:left;width:72px;}#yiv5592165847 #yiv5592165847photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5592165847 #yiv5592165847photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5592165847 #yiv5592165847reco-category {font-size:77%;}#yiv5592165847 #yiv5592165847reco-desc {font-size:77%;}#yiv5592165847 .yiv5592165847replbq {margin:4px;}#yiv5592165847 #yiv5592165847ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5592165847 #yiv5592165847ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5592165847 #yiv5592165847ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5592165847 #yiv5592165847ygrp-mlmsg select, #yiv5592165847 input, #yiv5592165847 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5592165847 #yiv5592165847ygrp-mlmsg pre, #yiv5592165847 code {font:115% monospace;}#yiv5592165847 #yiv5592165847ygrp-mlmsg * {line-height:1.22em;}#yiv5592165847 #yiv5592165847ygrp-mlmsg #yiv5592165847logo {padding-bottom:10px;}#yiv5592165847 #yiv5592165847ygrp-msg p a {font-family:Verdana;}#yiv5592165847 #yiv5592165847ygrp-msg p#yiv5592165847attach-count span {color:#1E66AE;font-weight:700;}#yiv5592165847 #yiv5592165847ygrp-reco #yiv5592165847reco-head {color:#ff7900;font-weight:700;}#yiv5592165847 #yiv5592165847ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5592165847 #yiv5592165847ygrp-sponsor #yiv5592165847ov li a {font-size:130%;text-decoration:none;}#yiv5592165847 #yiv5592165847ygrp-sponsor #yiv5592165847ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5592165847 #yiv5592165847ygrp-sponsor #yiv5592165847ov ul {margin:0;padding:0 0 0 8px;}#yiv5592165847 #yiv5592165847ygrp-text {font-family:Georgia;}#yiv5592165847 #yiv5592165847ygrp-text p {margin:0 0 1em 0;}#yiv5592165847 #yiv5592165847ygrp-text tt {font-size:120%;}#yiv5592165847 #yiv5592165847ygrp-vital ul li:last-child {border-right:none !important;}#yiv5592165847

Thu Oct 29, 2015 2:48 am (PDT) . Posted by:

"HAIRUL ALAM"

Maaf Pak Odong
Masalah saya sesuai lampiran berikut, yang pertama saya ralat, maaf Pak

Pada Kamis, 29 Oktober 2015 16:20, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Terimakasih Banyak Pak Odong
Maaf Kalau saya selalu tanya, Maklum saya juga pemula
TerimakasihSalam

Pada Kamis, 29 Oktober 2015 15:38, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  bisa memanfaatkan formula
=INDIRECT("F"&COLUMNS($J$2:J2)+2)

tinggal ganti F dengan kolom yang di inginkan dalam kasus ini kolom B dan E br,

odong nando


Pada Kamis, 29 Oktober 2015 15:04, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Yth. Para Master Excel
Assalamualaikum Wr. Wb.
Saya mengalami problem seperti data terlampir, Mohon Pencerahannya, agar dapat bekerja secara otomatis dengan formula dan semoga file excel dikalkulasi dengan ringan
Wassalamualaikum Wr. Wb.
TerimakasihHairul Alam

#yiv1722419502 #yiv1722419502 -- #yiv1722419502ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1722419502 #yiv1722419502ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1722419502 #yiv1722419502ygrp-mkp #yiv1722419502hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1722419502 #yiv1722419502ygrp-mkp #yiv1722419502ads {margin-bottom:10px;}#yiv1722419502 #yiv1722419502ygrp-mkp .yiv1722419502ad {padding:0 0;}#yiv1722419502 #yiv1722419502ygrp-mkp .yiv1722419502ad p {margin:0;}#yiv1722419502 #yiv1722419502ygrp-mkp .yiv1722419502ad a {color:#0000ff;text-decoration:none;}#yiv1722419502 #yiv1722419502ygrp-sponsor #yiv1722419502ygrp-lc {font-family:Arial;}#yiv1722419502 #yiv1722419502ygrp-sponsor #yiv1722419502ygrp-lc #yiv1722419502hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1722419502 #yiv1722419502ygrp-sponsor #yiv1722419502ygrp-lc .yiv1722419502ad {margin-bottom:10px;padding:0 0;}#yiv1722419502 #yiv1722419502actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1722419502 #yiv1722419502activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1722419502 #yiv1722419502activity span {font-weight:700;}#yiv1722419502 #yiv1722419502activity span:first-child {text-transform:uppercase;}#yiv1722419502 #yiv1722419502activity span a {color:#5085b6;text-decoration:none;}#yiv1722419502 #yiv1722419502activity span span {color:#ff7900;}#yiv1722419502 #yiv1722419502activity span .yiv1722419502underline {text-decoration:underline;}#yiv1722419502 .yiv1722419502attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1722419502 .yiv1722419502attach div a {text-decoration:none;}#yiv1722419502 .yiv1722419502attach img {border:none;padding-right:5px;}#yiv1722419502 .yiv1722419502attach label {display:block;margin-bottom:5px;}#yiv1722419502 .yiv1722419502attach label a {text-decoration:none;}#yiv1722419502 blockquote {margin:0 0 0 4px;}#yiv1722419502 .yiv1722419502bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1722419502 .yiv1722419502bold a {text-decoration:none;}#yiv1722419502 dd.yiv1722419502last p a {font-family:Verdana;font-weight:700;}#yiv1722419502 dd.yiv1722419502last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1722419502 dd.yiv1722419502last p span.yiv1722419502yshortcuts {margin-right:0;}#yiv1722419502 div.yiv1722419502attach-table div div a {text-decoration:none;}#yiv1722419502 div.yiv1722419502attach-table {width:400px;}#yiv1722419502 div.yiv1722419502file-title a, #yiv1722419502 div.yiv1722419502file-title a:active, #yiv1722419502 div.yiv1722419502file-title a:hover, #yiv1722419502 div.yiv1722419502file-title a:visited {text-decoration:none;}#yiv1722419502 div.yiv1722419502photo-title a, #yiv1722419502 div.yiv1722419502photo-title a:active, #yiv1722419502 div.yiv1722419502photo-title a:hover, #yiv1722419502 div.yiv1722419502photo-title a:visited {text-decoration:none;}#yiv1722419502 div#yiv1722419502ygrp-mlmsg #yiv1722419502ygrp-msg p a span.yiv1722419502yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1722419502 .yiv1722419502green {color:#628c2a;}#yiv1722419502 .yiv1722419502MsoNormal {margin:0 0 0 0;}#yiv1722419502 o {font-size:0;}#yiv1722419502 #yiv1722419502photos div {float:left;width:72px;}#yiv1722419502 #yiv1722419502photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1722419502 #yiv1722419502photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1722419502 #yiv1722419502reco-category {font-size:77%;}#yiv1722419502 #yiv1722419502reco-desc {font-size:77%;}#yiv1722419502 .yiv1722419502replbq {margin:4px;}#yiv1722419502 #yiv1722419502ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1722419502 #yiv1722419502ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1722419502 #yiv1722419502ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1722419502 #yiv1722419502ygrp-mlmsg select, #yiv1722419502 input, #yiv1722419502 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1722419502 #yiv1722419502ygrp-mlmsg pre, #yiv1722419502 code {font:115% monospace;}#yiv1722419502 #yiv1722419502ygrp-mlmsg * {line-height:1.22em;}#yiv1722419502 #yiv1722419502ygrp-mlmsg #yiv1722419502logo {padding-bottom:10px;}#yiv1722419502 #yiv1722419502ygrp-msg p a {font-family:Verdana;}#yiv1722419502 #yiv1722419502ygrp-msg p#yiv1722419502attach-count span {color:#1E66AE;font-weight:700;}#yiv1722419502 #yiv1722419502ygrp-reco #yiv1722419502reco-head {color:#ff7900;font-weight:700;}#yiv1722419502 #yiv1722419502ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1722419502 #yiv1722419502ygrp-sponsor #yiv1722419502ov li a {font-size:130%;text-decoration:none;}#yiv1722419502 #yiv1722419502ygrp-sponsor #yiv1722419502ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1722419502 #yiv1722419502ygrp-sponsor #yiv1722419502ov ul {margin:0;padding:0 0 0 8px;}#yiv1722419502 #yiv1722419502ygrp-text {font-family:Georgia;}#yiv1722419502 #yiv1722419502ygrp-text p {margin:0 0 1em 0;}#yiv1722419502 #yiv1722419502ygrp-text tt {font-size:120%;}#yiv1722419502 #yiv1722419502ygrp-vital ul li:last-child {border-right:none !important;}#yiv1722419502

Thu Oct 29, 2015 3:00 am (PDT) . Posted by:

"odong nando"

cell J4
=IF(($I$10<>"")*(COUNTIF($C$3:$C$17;$I$10)>=COLUMNS($I$2:I2));INDEX($C$3:$C$17;MATCH($I$10;$C$3:$C$17;0)+COLUMNS($I$2:I2)-1);"")bagian C ganti dengan kolom yang akan dituju, untuk yang lokasi
br,

odong nando


Pada Kamis, 29 Oktober 2015 16:48, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Maaf Pak Odong
Masalah saya sesuai lampiran berikut, yang pertama saya ralat, maaf Pak

Pada Kamis, 29 Oktober 2015 16:20, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Terimakasih Banyak Pak Odong
Maaf Kalau saya selalu tanya, Maklum saya juga pemula
TerimakasihSalam

Pada Kamis, 29 Oktober 2015 15:38, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  bisa memanfaatkan formula
=INDIRECT("F"&COLUMNS($J$2:J2)+2)

tinggal ganti F dengan kolom yang di inginkan dalam kasus ini kolom B dan E br,

odong nando


Pada Kamis, 29 Oktober 2015 15:04, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Yth. Para Master Excel
Assalamualaikum Wr. Wb.
Saya mengalami problem seperti data terlampir, Mohon Pencerahannya, agar dapat bekerja secara otomatis dengan formula dan semoga file excel dikalkulasi dengan ringan
Wassalamualaikum Wr. Wb.
TerimakasihHairul Alam

#yiv2810286094 #yiv2810286094 -- #yiv2810286094ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2810286094 #yiv2810286094ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2810286094 #yiv2810286094ygrp-mkp #yiv2810286094hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2810286094 #yiv2810286094ygrp-mkp #yiv2810286094ads {margin-bottom:10px;}#yiv2810286094 #yiv2810286094ygrp-mkp .yiv2810286094ad {padding:0 0;}#yiv2810286094 #yiv2810286094ygrp-mkp .yiv2810286094ad p {margin:0;}#yiv2810286094 #yiv2810286094ygrp-mkp .yiv2810286094ad a {color:#0000ff;text-decoration:none;}#yiv2810286094 #yiv2810286094ygrp-sponsor #yiv2810286094ygrp-lc {font-family:Arial;}#yiv2810286094 #yiv2810286094ygrp-sponsor #yiv2810286094ygrp-lc #yiv2810286094hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2810286094 #yiv2810286094ygrp-sponsor #yiv2810286094ygrp-lc .yiv2810286094ad {margin-bottom:10px;padding:0 0;}#yiv2810286094 #yiv2810286094actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2810286094 #yiv2810286094activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2810286094 #yiv2810286094activity span {font-weight:700;}#yiv2810286094 #yiv2810286094activity span:first-child {text-transform:uppercase;}#yiv2810286094 #yiv2810286094activity span a {color:#5085b6;text-decoration:none;}#yiv2810286094 #yiv2810286094activity span span {color:#ff7900;}#yiv2810286094 #yiv2810286094activity span .yiv2810286094underline {text-decoration:underline;}#yiv2810286094 .yiv2810286094attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2810286094 .yiv2810286094attach div a {text-decoration:none;}#yiv2810286094 .yiv2810286094attach img {border:none;padding-right:5px;}#yiv2810286094 .yiv2810286094attach label {display:block;margin-bottom:5px;}#yiv2810286094 .yiv2810286094attach label a {text-decoration:none;}#yiv2810286094 blockquote {margin:0 0 0 4px;}#yiv2810286094 .yiv2810286094bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2810286094 .yiv2810286094bold a {text-decoration:none;}#yiv2810286094 dd.yiv2810286094last p a {font-family:Verdana;font-weight:700;}#yiv2810286094 dd.yiv2810286094last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2810286094 dd.yiv2810286094last p span.yiv2810286094yshortcuts {margin-right:0;}#yiv2810286094 div.yiv2810286094attach-table div div a {text-decoration:none;}#yiv2810286094 div.yiv2810286094attach-table {width:400px;}#yiv2810286094 div.yiv2810286094file-title a, #yiv2810286094 div.yiv2810286094file-title a:active, #yiv2810286094 div.yiv2810286094file-title a:hover, #yiv2810286094 div.yiv2810286094file-title a:visited {text-decoration:none;}#yiv2810286094 div.yiv2810286094photo-title a, #yiv2810286094 div.yiv2810286094photo-title a:active, #yiv2810286094 div.yiv2810286094photo-title a:hover, #yiv2810286094 div.yiv2810286094photo-title a:visited {text-decoration:none;}#yiv2810286094 div#yiv2810286094ygrp-mlmsg #yiv2810286094ygrp-msg p a span.yiv2810286094yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2810286094 .yiv2810286094green {color:#628c2a;}#yiv2810286094 .yiv2810286094MsoNormal {margin:0 0 0 0;}#yiv2810286094 o {font-size:0;}#yiv2810286094 #yiv2810286094photos div {float:left;width:72px;}#yiv2810286094 #yiv2810286094photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2810286094 #yiv2810286094photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2810286094 #yiv2810286094reco-category {font-size:77%;}#yiv2810286094 #yiv2810286094reco-desc {font-size:77%;}#yiv2810286094 .yiv2810286094replbq {margin:4px;}#yiv2810286094 #yiv2810286094ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2810286094 #yiv2810286094ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2810286094 #yiv2810286094ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2810286094 #yiv2810286094ygrp-mlmsg select, #yiv2810286094 input, #yiv2810286094 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2810286094 #yiv2810286094ygrp-mlmsg pre, #yiv2810286094 code {font:115% monospace;}#yiv2810286094 #yiv2810286094ygrp-mlmsg * {line-height:1.22em;}#yiv2810286094 #yiv2810286094ygrp-mlmsg #yiv2810286094logo {padding-bottom:10px;}#yiv2810286094 #yiv2810286094ygrp-msg p a {font-family:Verdana;}#yiv2810286094 #yiv2810286094ygrp-msg p#yiv2810286094attach-count span {color:#1E66AE;font-weight:700;}#yiv2810286094 #yiv2810286094ygrp-reco #yiv2810286094reco-head {color:#ff7900;font-weight:700;}#yiv2810286094 #yiv2810286094ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2810286094 #yiv2810286094ygrp-sponsor #yiv2810286094ov li a {font-size:130%;text-decoration:none;}#yiv2810286094 #yiv2810286094ygrp-sponsor #yiv2810286094ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2810286094 #yiv2810286094ygrp-sponsor #yiv2810286094ov ul {margin:0;padding:0 0 0 8px;}#yiv2810286094 #yiv2810286094ygrp-text {font-family:Georgia;}#yiv2810286094 #yiv2810286094ygrp-text p {margin:0 0 1em 0;}#yiv2810286094 #yiv2810286094ygrp-text tt {font-size:120%;}#yiv2810286094 #yiv2810286094ygrp-vital ul li:last-child {border-right:none !important;}#yiv2810286094

Thu Oct 29, 2015 3:48 am (PDT) . Posted by:

"HAIRUL ALAM"

Terimakasih banyak Pak

Pada Kamis, 29 Oktober 2015 17:01, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  cell J4
=IF(($I$10<>"")*(COUNTIF($C$3:$C$17;$I$10)>=COLUMNS($I$2:I2));INDEX($C$3:$C$17;MATCH($I$10;$C$3:$C$17;0)+COLUMNS($I$2:I2)-1);"")bagian C ganti dengan kolom yang akan dituju, untuk yang lokasi
br,

odong nando


Pada Kamis, 29 Oktober 2015 16:48, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Maaf Pak Odong
Masalah saya sesuai lampiran berikut, yang pertama saya ralat, maaf Pak

Pada Kamis, 29 Oktober 2015 16:20, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Terimakasih Banyak Pak Odong
Maaf Kalau saya selalu tanya, Maklum saya juga pemula
TerimakasihSalam

Pada Kamis, 29 Oktober 2015 15:38, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  bisa memanfaatkan formula
=INDIRECT("F"&COLUMNS($J$2:J2)+2)

tinggal ganti F dengan kolom yang di inginkan dalam kasus ini kolom B dan E br,

odong nando


Pada Kamis, 29 Oktober 2015 15:04, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Yth. Para Master Excel
Assalamualaikum Wr. Wb.
Saya mengalami problem seperti data terlampir, Mohon Pencerahannya, agar dapat bekerja secara otomatis dengan formula dan semoga file excel dikalkulasi dengan ringan
Wassalamualaikum Wr. Wb.
TerimakasihHairul Alam

#yiv6819515648 #yiv6819515648 -- #yiv6819515648ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6819515648 #yiv6819515648ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6819515648 #yiv6819515648ygrp-mkp #yiv6819515648hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6819515648 #yiv6819515648ygrp-mkp #yiv6819515648ads {margin-bottom:10px;}#yiv6819515648 #yiv6819515648ygrp-mkp .yiv6819515648ad {padding:0 0;}#yiv6819515648 #yiv6819515648ygrp-mkp .yiv6819515648ad p {margin:0;}#yiv6819515648 #yiv6819515648ygrp-mkp .yiv6819515648ad a {color:#0000ff;text-decoration:none;}#yiv6819515648 #yiv6819515648ygrp-sponsor #yiv6819515648ygrp-lc {font-family:Arial;}#yiv6819515648 #yiv6819515648ygrp-sponsor #yiv6819515648ygrp-lc #yiv6819515648hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6819515648 #yiv6819515648ygrp-sponsor #yiv6819515648ygrp-lc .yiv6819515648ad {margin-bottom:10px;padding:0 0;}#yiv6819515648 #yiv6819515648actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6819515648 #yiv6819515648activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6819515648 #yiv6819515648activity span {font-weight:700;}#yiv6819515648 #yiv6819515648activity span:first-child {text-transform:uppercase;}#yiv6819515648 #yiv6819515648activity span a {color:#5085b6;text-decoration:none;}#yiv6819515648 #yiv6819515648activity span span {color:#ff7900;}#yiv6819515648 #yiv6819515648activity span .yiv6819515648underline {text-decoration:underline;}#yiv6819515648 .yiv6819515648attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6819515648 .yiv6819515648attach div a {text-decoration:none;}#yiv6819515648 .yiv6819515648attach img {border:none;padding-right:5px;}#yiv6819515648 .yiv6819515648attach label {display:block;margin-bottom:5px;}#yiv6819515648 .yiv6819515648attach label a {text-decoration:none;}#yiv6819515648 blockquote {margin:0 0 0 4px;}#yiv6819515648 .yiv6819515648bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6819515648 .yiv6819515648bold a {text-decoration:none;}#yiv6819515648 dd.yiv6819515648last p a {font-family:Verdana;font-weight:700;}#yiv6819515648 dd.yiv6819515648last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6819515648 dd.yiv6819515648last p span.yiv6819515648yshortcuts {margin-right:0;}#yiv6819515648 div.yiv6819515648attach-table div div a {text-decoration:none;}#yiv6819515648 div.yiv6819515648attach-table {width:400px;}#yiv6819515648 div.yiv6819515648file-title a, #yiv6819515648 div.yiv6819515648file-title a:active, #yiv6819515648 div.yiv6819515648file-title a:hover, #yiv6819515648 div.yiv6819515648file-title a:visited {text-decoration:none;}#yiv6819515648 div.yiv6819515648photo-title a, #yiv6819515648 div.yiv6819515648photo-title a:active, #yiv6819515648 div.yiv6819515648photo-title a:hover, #yiv6819515648 div.yiv6819515648photo-title a:visited {text-decoration:none;}#yiv6819515648 div#yiv6819515648ygrp-mlmsg #yiv6819515648ygrp-msg p a span.yiv6819515648yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6819515648 .yiv6819515648green {color:#628c2a;}#yiv6819515648 .yiv6819515648MsoNormal {margin:0 0 0 0;}#yiv6819515648 o {font-size:0;}#yiv6819515648 #yiv6819515648photos div {float:left;width:72px;}#yiv6819515648 #yiv6819515648photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6819515648 #yiv6819515648photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6819515648 #yiv6819515648reco-category {font-size:77%;}#yiv6819515648 #yiv6819515648reco-desc {font-size:77%;}#yiv6819515648 .yiv6819515648replbq {margin:4px;}#yiv6819515648 #yiv6819515648ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6819515648 #yiv6819515648ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6819515648 #yiv6819515648ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6819515648 #yiv6819515648ygrp-mlmsg select, #yiv6819515648 input, #yiv6819515648 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6819515648 #yiv6819515648ygrp-mlmsg pre, #yiv6819515648 code {font:115% monospace;}#yiv6819515648 #yiv6819515648ygrp-mlmsg * {line-height:1.22em;}#yiv6819515648 #yiv6819515648ygrp-mlmsg #yiv6819515648logo {padding-bottom:10px;}#yiv6819515648 #yiv6819515648ygrp-msg p a {font-family:Verdana;}#yiv6819515648 #yiv6819515648ygrp-msg p#yiv6819515648attach-count span {color:#1E66AE;font-weight:700;}#yiv6819515648 #yiv6819515648ygrp-reco #yiv6819515648reco-head {color:#ff7900;font-weight:700;}#yiv6819515648 #yiv6819515648ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6819515648 #yiv6819515648ygrp-sponsor #yiv6819515648ov li a {font-size:130%;text-decoration:none;}#yiv6819515648 #yiv6819515648ygrp-sponsor #yiv6819515648ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6819515648 #yiv6819515648ygrp-sponsor #yiv6819515648ov ul {margin:0;padding:0 0 0 8px;}#yiv6819515648 #yiv6819515648ygrp-text {font-family:Georgia;}#yiv6819515648 #yiv6819515648ygrp-text p {margin:0 0 1em 0;}#yiv6819515648 #yiv6819515648ygrp-text tt {font-size:120%;}#yiv6819515648 #yiv6819515648ygrp-vital ul li:last-child {border-right:none !important;}#yiv6819515648

Thu Oct 29, 2015 6:33 am (PDT) . Posted by:

"HAIRUL ALAM"

Yth. Master Excel
Saya punya masalah seperti data terlampir, bagaimana caranya agar bekerja secara otomatis dengan formula dan file excel tidak menjadi besar sehingga operasi excel menjadi lambat, Terimakasih Pencerahannya, dan Sukses selalu pada belajar-excel@yahoogroups.com
SalamHairul Alam

Thu Oct 29, 2015 7:27 pm (PDT) . Posted by:

"Dede Sulaeman"

Daer Para Suhu,

Assalamu'alaikum Wr Wb.

Mohon masukan terkait Macro dbi :

Sub Macro4()

Jmlhbrs = Range("a1").Value

Range("a2").Select

For i = 1 To Jmlhbrs

ActiveCell.Offset(1, 0).Select

Kode_Subdist = ActiveCell.Value

On Error Resume Next

Workbooks.Open Filename:="D:\#Master&#92;Pemusnahan BS\STD-STM PMA FINAL.xlsb"

Sheets("Persetujuan Pemusnahan BS").Select

Sheets("Persetujuan Pemusnahan BS new").Visible = 2 - xlSheetVerryHidden

Sheets("Parent code").Select

Range("A:AA").Select

Selection.Copy

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Sheets("Parent code").Visible = 2 - xlSheetVerryHidden

Sheets("STD-STM KSNI").Select

ActiveSheet.Unprotect Password:="a"

Range("a6").Value = Kode_Subdist

Kode_Barang = Range("c4").Value

Nama_File = Range("a104").Value

Range("c6:g" & Kode_Barang).Select

Selection.Copy

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Range("c6:c" & Kode_Barang).Select

Selection.Locked = True

Selection.FormulaHidden = True

Columns("I:L").Select

Selection.ClearContents

Range("c1:c2").Select

Selection.Locked = False

Selection.FormulaHidden = True

ActiveSheet.Protect Password:="a"

ChDir "D:\#Pemusnahan BS\Email"

ActiveWorkbook.SaveAs Filename:="D:\#Pemusnahan BS\Email&#92;" & Nama_File & ".xlsb", _

FileFormat:=xlExcel12, CreateBackup:=False

ActiveWorkbook.Save

ActiveWindow.Close

Next i

End Sub

Macro ini berjalan sesuai harapan, namun saya ingin menjalankan macro lain yaitu Send_Email (di file lain) setelah proses pada macro diatas selesai.

Saya coba tambahkan penggalan terakhir setelah Next i sbb :

Next i

Workbooks.Open Filename:="D:\#Master&#92;Send Email.xlsm"

Sheets("Kirim").Select

Sub Macro Send_Email().Run

End Sub

Tapi masih belum berjalan, file Send Email berjalan dengan baik sebenarnya. Mohon masukannya terkait masalah ini.

File untuk mengirim Email saya lampirkan.

Salam,

DD

Fri Oct 30, 2015 12:30 am (PDT) . Posted by:

"Huda All Yazid" huda_1810

Dear,

Teman teman BeExceller


Saya sudah mengikuti beberapa tips dari teman-teman BeExceller (hapus file temporary MSForms.exd dan register file fm20.dll) tapi ActiveX Controls tidak bisa diinsert juga (muncul pesan: "Cannot insert object"). Ketika saya coba menghapus MSForms.exd dari temporary file dan mencoba menginsertkan ActiveX Controls, file tersebut (MSForms.exd) muncul kembali di temporary file.


Mohon bantuan dari teman teman excel


--
Regard, Huda All Yazid








Fri Oct 30, 2015 12:30 am (PDT) . Posted by:

"Rudhie" rudhiedhie

Dear Be Exceller
Selamat siangMohon kiranya dapat membantu untuk memberikan pencerahanpada permasalahan pengolahan data yang saya hadapi.Disini saya ingin membuat pivot table dari sheet!DATA denganmenampilkan total qty per product dan juga ingin menampilkan grand Total qtyberdsarkan Tanggal.Contoh bentuk pivot table nya saya lampirkan pada file.
Besar harapan saya para master dapat memberikanpencerahannya, sebelumnya Saya ucapkan terima kasih.  Salam Ruddi

Fri Oct 30, 2015 1:16 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Spt inikah ang diinginkan ?
| Date | Customer | No Surat Jalan | _Product A_ | _Product B_  | _Product C_ | _Product D_ | Sum of Total Qty |
| 1-Oct | Bekasi | FDS.0100 | 672 | 0 | 0 | 0 | 672 |
| | | FDS.0104 | 420 | 0 | 0 | 252 | 672 |
| | Total Bekasi | | 1092 | 0 | 0 | 252 | 1344 |
| | Bogor | FDS.0107 | 168 | 168 | 168 | 168 | 672 |
| | | FDS.0108 | 0 | 126 | 126 | 420 | 672 |
| | Total Bogor | | 168 | 294 | 294 | 588 | 1344 |
| | Cakung | FDS.0102 | 672 | 0 | 0 | 0 | 672 |
| | | FDS.0103 | 168 | 168 | 168 | 168 | 672 |
| | Total Cakung | | 840 | 168 | 168 | 168 | 1344 |
| | Tangerang | FDS.0101 | 672 | 0 | 0 | 0 | 672 |
| | | FDS.0105 | 168 | 168 | 168 | 168 | 672 |
| | | FDS.0106 | 252 | 84 | 84 | 252 | 672 |
| | Total Tangerang | | 1092 | 252 | 252 | 420 | 2016 |
| Total 1-Oct | | | 3192 | 714 | 714 | 1428 | 6048 |
| 2-Oct | Bekasi | FDS.0109 | 0 | 672 | 0 | 0 | 672 |
| | | FDS.0112 | 0 | 0 | 672 | 0 | 672 |
| | Total Bekasi | | 0 | 672 | 672 | 0 | 1344 |
| | Bogor | FDS.0111 | 0 | 672 | 0 | 0 | 672 |
| | Total Bogor | | 0 | 672 | 0 | 0 | 672 |
| | Cakung | FDS.0110 | 0 | 672 | 0 | 0 | 672 |
| | Total Cakung | | 0 | 672 | 0 | 0 | 672 |
| | Tangerang | FDS.0113 | 0 | 672 | 0 | 0 | 672 |
| | | FDS.0114 | 0 | 0 | 672 | 0 | 672 |
| | Total Tangerang | | 0 | 672 | 672 | 0 | 1344 |
| Total 2-Oct | | | 0 | 2688 | 1344 | 0 | 4032 |
| Grand Total | | | 3192 | 3402 | 2058 | 1428 | 10080 |

Jika ya, berarti ada 3 hal yang musti dilakukan:- Design SubTotals....Bottom- Design Report Layout....Show in Tabular Form- Ganti kata2...tidak boleh sama dengan judul kolom yang ada di sheet Data.
Salam,HK
From: "Rudhie rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 30 October 2015, 13:15
Subject: [belajar-excel] Menampilkan subtotal dan grand total qty. produk pada pivot table [1 Attachment]

  Dear Be Exceller
Selamat siangMohon kiranya dapat membantu untuk memberikan pencerahanpada permasalahan pengolahan data yang saya hadapi.Disini saya ingin membuat pivot table dari sheet!DATA denganmenampilkan total qty per product dan juga ingin menampilkan grand Total qtyberdsarkan Tanggal.Contoh bentuk pivot table nya saya lampirkan pada file.
Besar harapan saya para master dapat memberikanpencerahannya, sebelumnya Saya ucapkan terima kasih.  Salam Ruddi #yiv0745090623 #yiv0745090623 -- #yiv0745090623ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0745090623 #yiv0745090623ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0745090623 #yiv0745090623ygrp-mkp #yiv0745090623hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0745090623 #yiv0745090623ygrp-mkp #yiv0745090623ads {margin-bottom:10px;}#yiv0745090623 #yiv0745090623ygrp-mkp .yiv0745090623ad {padding:0 0;}#yiv0745090623 #yiv0745090623ygrp-mkp .yiv0745090623ad p {margin:0;}#yiv0745090623 #yiv0745090623ygrp-mkp .yiv0745090623ad a {color:#0000ff;text-decoration:none;}#yiv0745090623 #yiv0745090623ygrp-sponsor #yiv0745090623ygrp-lc {font-family:Arial;}#yiv0745090623 #yiv0745090623ygrp-sponsor #yiv0745090623ygrp-lc #yiv0745090623hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0745090623 #yiv0745090623ygrp-sponsor #yiv0745090623ygrp-lc .yiv0745090623ad {margin-bottom:10px;padding:0 0;}#yiv0745090623 #yiv0745090623actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0745090623 #yiv0745090623activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0745090623 #yiv0745090623activity span {font-weight:700;}#yiv0745090623 #yiv0745090623activity span:first-child {text-transform:uppercase;}#yiv0745090623 #yiv0745090623activity span a {color:#5085b6;text-decoration:none;}#yiv0745090623 #yiv0745090623activity span span {color:#ff7900;}#yiv0745090623 #yiv0745090623activity span .yiv0745090623underline {text-decoration:underline;}#yiv0745090623 .yiv0745090623attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0745090623 .yiv0745090623attach div a {text-decoration:none;}#yiv0745090623 .yiv0745090623attach img {border:none;padding-right:5px;}#yiv0745090623 .yiv0745090623attach label {display:block;margin-bottom:5px;}#yiv0745090623 .yiv0745090623attach label a {text-decoration:none;}#yiv0745090623 blockquote {margin:0 0 0 4px;}#yiv0745090623 .yiv0745090623bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0745090623 .yiv0745090623bold a {text-decoration:none;}#yiv0745090623 dd.yiv0745090623last p a {font-family:Verdana;font-weight:700;}#yiv0745090623 dd.yiv0745090623last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0745090623 dd.yiv0745090623last p span.yiv0745090623yshortcuts {margin-right:0;}#yiv0745090623 div.yiv0745090623attach-table div div a {text-decoration:none;}#yiv0745090623 div.yiv0745090623attach-table {width:400px;}#yiv0745090623 div.yiv0745090623file-title a, #yiv0745090623 div.yiv0745090623file-title a:active, #yiv0745090623 div.yiv0745090623file-title a:hover, #yiv0745090623 div.yiv0745090623file-title a:visited {text-decoration:none;}#yiv0745090623 div.yiv0745090623photo-title a, #yiv0745090623 div.yiv0745090623photo-title a:active, #yiv0745090623 div.yiv0745090623photo-title a:hover, #yiv0745090623 div.yiv0745090623photo-title a:visited {text-decoration:none;}#yiv0745090623 div#yiv0745090623ygrp-mlmsg #yiv0745090623ygrp-msg p a span.yiv0745090623yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0745090623 .yiv0745090623green {color:#628c2a;}#yiv0745090623 .yiv0745090623MsoNormal {margin:0 0 0 0;}#yiv0745090623 o {font-size:0;}#yiv0745090623 #yiv0745090623photos div {float:left;width:72px;}#yiv0745090623 #yiv0745090623photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0745090623 #yiv0745090623photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0745090623 #yiv0745090623reco-category {font-size:77%;}#yiv0745090623 #yiv0745090623reco-desc {font-size:77%;}#yiv0745090623 .yiv0745090623replbq {margin:4px;}#yiv0745090623 #yiv0745090623ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0745090623 #yiv0745090623ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0745090623 #yiv0745090623ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0745090623 #yiv0745090623ygrp-mlmsg select, #yiv0745090623 input, #yiv0745090623 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0745090623 #yiv0745090623ygrp-mlmsg pre, #yiv0745090623 code {font:115% monospace;}#yiv0745090623 #yiv0745090623ygrp-mlmsg * {line-height:1.22em;}#yiv0745090623 #yiv0745090623ygrp-mlmsg #yiv0745090623logo {padding-bottom:10px;}#yiv0745090623 #yiv0745090623ygrp-msg p a {font-family:Verdana;}#yiv0745090623 #yiv0745090623ygrp-msg p#yiv0745090623attach-count span {color:#1E66AE;font-weight:700;}#yiv0745090623 #yiv0745090623ygrp-reco #yiv0745090623reco-head {color:#ff7900;font-weight:700;}#yiv0745090623 #yiv0745090623ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0745090623 #yiv0745090623ygrp-sponsor #yiv0745090623ov li a {font-size:130%;text-decoration:none;}#yiv0745090623 #yiv0745090623ygrp-sponsor #yiv0745090623ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0745090623 #yiv0745090623ygrp-sponsor #yiv0745090623ov ul {margin:0;padding:0 0 0 8px;}#yiv0745090623 #yiv0745090623ygrp-text {font-family:Georgia;}#yiv0745090623 #yiv0745090623ygrp-text p {margin:0 0 1em 0;}#yiv0745090623 #yiv0745090623ygrp-text tt {font-size:120%;}#yiv0745090623 #yiv0745090623ygrp-vital ul li:last-child {border-right:none !important;}#yiv0745090623

Fri Oct 30, 2015 1:27 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Rudhie,

Dengan asumsi sudah ada pivot table-nya,
coba klik kanan sebuah nilai yang akan di subtotal, lalu pilih Subtotal
blabla.
Misal akan subtotal tanggal, klik kanan sebuah nilai tanggal lalu pilih
subtotal blabla.
Jika akan subtotal field lainnya, misal di kanan tanggal ada field nama,
maka klik kanan sebuah nama lalu pilih subtotal, dst

Coba jalan-jalan kesini
<http://excel-mr-kid.blogspot.co.id/2013/09/pivot-table-3-pivot-field.html>
terutama di bagian Menata field pada Row Labels atau Column Labels

Wassalam,
Kid

2015-10-30 13:15 GMT+07:00 Rudhie rudhiedhie@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Dear Be Exceller
>
> Selamat siang
> Mohon kiranya dapat membantu untuk memberikan pencerahan pada permasalahan
> pengolahan data yang saya hadapi.
> Disini saya ingin membuat pivot table dari sheet!DATA dengan menampilkan
> total qty per product dan juga ingin menampilkan grand Total qty berdsarkan
> Tanggal.
> Contoh bentuk pivot table nya saya lampirkan pada file.
> Besar harapan saya para master dapat memberikan pencerahannya, sebelumnya
> Saya ucapkan terima kasih.
>
>
> Salam
> Ruddi
>
>
>

Fri Oct 30, 2015 1:28 am (PDT) . Posted by:

"Dede Sulaeman"

Dear Mr Rudi,

See Attach, semoga sesuai harapan.

Salam,

DD

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 30 Oktober 2015 13:16
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menampilkan subtotal dan grand total qty. produk pada pivot table [1 Attachment]

Dear Be Exceller

Selamat siang

Mohon kiranya dapat membantu untuk memberikan pencerahan pada permasalahan pengolahan data yang saya hadapi.

Disini saya ingin membuat pivot table dari sheet!DATA dengan menampilkan total qty per product dan juga ingin menampilkan grand Total qty berdsarkan Tanggal.

Contoh bentuk pivot table nya saya lampirkan pada file.

Besar harapan saya para master dapat memberikan pencerahannya, sebelumnya Saya ucapkan terima kasih.

Salam

Ruddi

Fri Oct 30, 2015 1:01 am (PDT) . Posted by:

"kiki tanjung" kieki_e

Dear Teman Teman
Mohon pencerahan
Saya punya file Excel di Dropbox yang saya share ke beberapa account Dropbox teman. 
Suatu ketika salah satu teman dengan tidak sengaja menghapus file Excel tersebut di komputernya sehingga saya dan teman teman yang lain tidak bisa mengakses file itu lagi.
Pertanyaannya : Bagaimanakah cara agar file yang saya share via Dropbox tidak bisa dihapus oleh yang lain...atau jika pun terhapus, file nya tetap ada di account Dropbox saya.
Terima kasih atas pencerahan dari teman teman semua.

Fri Oct 30, 2015 1:07 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Apakah dropbox tidak punya fitur backup Pak ?
Mungkin bisa dicoba mencari backup file di account dropbox nya. Kemudian di
recover dan di sync ulang ke komputer.

2015-10-30 14:49 GMT+07:00 kiki tanjung kieki_e@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Dear Teman Teman
>
> Mohon pencerahan
>
> Saya punya file Excel di Dropbox yang saya share ke beberapa account
> Dropbox teman.
>
> Suatu ketika salah satu teman dengan tidak sengaja menghapus file Excel
> tersebut di komputernya sehingga saya dan teman teman yang lain tidak bisa
> mengakses file itu lagi.
>
> Pertanyaannya : Bagaimanakah cara agar file yang saya share via Dropbox
> tidak bisa dihapus oleh yang lain...atau jika pun terhapus, file nya tetap
> ada di account Dropbox saya.
>
> Terima kasih atas pencerahan dari teman teman semua.
>
>
>
>

Fri Oct 30, 2015 1:36 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Kiki,Kalau belum didelete secara permanen harusnya bisa direstore.
Caranya:- Klik kanan Mouse pada Menu "File" di sebelah kiri- Klik Show deleted file- Seharusnya deleted files akan muncul dengan keterangan "deleted"- Klik kanan pada file yang bersangkutan- Klik Restore
Semoga berhasil.
Salam,HK
From: "kiki tanjung kieki_e@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 30 October 2015, 14:49
Subject: [belajar-excel] Data Excel di Dropbox

  Dear Teman Teman
Mohon pencerahan
Saya punya file Excel di Dropbox yang saya share ke beberapa account Dropbox teman. 
Suatu ketika salah satu teman dengan tidak sengaja menghapus file Excel tersebut di komputernya sehingga saya dan teman teman yang lain tidak bisa mengakses file itu lagi.
Pertanyaannya : Bagaimanakah cara agar file yang saya share via Dropbox tidak bisa dihapus oleh yang lain...atau jika pun terhapus, file nya tetap ada di account Dropbox saya.
Terima kasih atas pencerahan dari teman teman semua.

#yiv4892722454 #yiv4892722454 -- #yiv4892722454ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4892722454 #yiv4892722454ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4892722454 #yiv4892722454ygrp-mkp #yiv4892722454hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4892722454 #yiv4892722454ygrp-mkp #yiv4892722454ads {margin-bottom:10px;}#yiv4892722454 #yiv4892722454ygrp-mkp .yiv4892722454ad {padding:0 0;}#yiv4892722454 #yiv4892722454ygrp-mkp .yiv4892722454ad p {margin:0;}#yiv4892722454 #yiv4892722454ygrp-mkp .yiv4892722454ad a {color:#0000ff;text-decoration:none;}#yiv4892722454 #yiv4892722454ygrp-sponsor #yiv4892722454ygrp-lc {font-family:Arial;}#yiv4892722454 #yiv4892722454ygrp-sponsor #yiv4892722454ygrp-lc #yiv4892722454hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4892722454 #yiv4892722454ygrp-sponsor #yiv4892722454ygrp-lc .yiv4892722454ad {margin-bottom:10px;padding:0 0;}#yiv4892722454 #yiv4892722454actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4892722454 #yiv4892722454activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4892722454 #yiv4892722454activity span {font-weight:700;}#yiv4892722454 #yiv4892722454activity span:first-child {text-transform:uppercase;}#yiv4892722454 #yiv4892722454activity span a {color:#5085b6;text-decoration:none;}#yiv4892722454 #yiv4892722454activity span span {color:#ff7900;}#yiv4892722454 #yiv4892722454activity span .yiv4892722454underline {text-decoration:underline;}#yiv4892722454 .yiv4892722454attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4892722454 .yiv4892722454attach div a {text-decoration:none;}#yiv4892722454 .yiv4892722454attach img {border:none;padding-right:5px;}#yiv4892722454 .yiv4892722454attach label {display:block;margin-bottom:5px;}#yiv4892722454 .yiv4892722454attach label a {text-decoration:none;}#yiv4892722454 blockquote {margin:0 0 0 4px;}#yiv4892722454 .yiv4892722454bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4892722454 .yiv4892722454bold a {text-decoration:none;}#yiv4892722454 dd.yiv4892722454last p a {font-family:Verdana;font-weight:700;}#yiv4892722454 dd.yiv4892722454last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4892722454 dd.yiv4892722454last p span.yiv4892722454yshortcuts {margin-right:0;}#yiv4892722454 div.yiv4892722454attach-table div div a {text-decoration:none;}#yiv4892722454 div.yiv4892722454attach-table {width:400px;}#yiv4892722454 div.yiv4892722454file-title a, #yiv4892722454 div.yiv4892722454file-title a:active, #yiv4892722454 div.yiv4892722454file-title a:hover, #yiv4892722454 div.yiv4892722454file-title a:visited {text-decoration:none;}#yiv4892722454 div.yiv4892722454photo-title a, #yiv4892722454 div.yiv4892722454photo-title a:active, #yiv4892722454 div.yiv4892722454photo-title a:hover, #yiv4892722454 div.yiv4892722454photo-title a:visited {text-decoration:none;}#yiv4892722454 div#yiv4892722454ygrp-mlmsg #yiv4892722454ygrp-msg p a span.yiv4892722454yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4892722454 .yiv4892722454green {color:#628c2a;}#yiv4892722454 .yiv4892722454MsoNormal {margin:0 0 0 0;}#yiv4892722454 o {font-size:0;}#yiv4892722454 #yiv4892722454photos div {float:left;width:72px;}#yiv4892722454 #yiv4892722454photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4892722454 #yiv4892722454photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4892722454 #yiv4892722454reco-category {font-size:77%;}#yiv4892722454 #yiv4892722454reco-desc {font-size:77%;}#yiv4892722454 .yiv4892722454replbq {margin:4px;}#yiv4892722454 #yiv4892722454ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4892722454 #yiv4892722454ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4892722454 #yiv4892722454ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4892722454 #yiv4892722454ygrp-mlmsg select, #yiv4892722454 input, #yiv4892722454 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4892722454 #yiv4892722454ygrp-mlmsg pre, #yiv4892722454 code {font:115% monospace;}#yiv4892722454 #yiv4892722454ygrp-mlmsg * {line-height:1.22em;}#yiv4892722454 #yiv4892722454ygrp-mlmsg #yiv4892722454logo {padding-bottom:10px;}#yiv4892722454 #yiv4892722454ygrp-msg p a {font-family:Verdana;}#yiv4892722454 #yiv4892722454ygrp-msg p#yiv4892722454attach-count span {color:#1E66AE;font-weight:700;}#yiv4892722454 #yiv4892722454ygrp-reco #yiv4892722454reco-head {color:#ff7900;font-weight:700;}#yiv4892722454 #yiv4892722454ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4892722454 #yiv4892722454ygrp-sponsor #yiv4892722454ov li a {font-size:130%;text-decoration:none;}#yiv4892722454 #yiv4892722454ygrp-sponsor #yiv4892722454ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4892722454 #yiv4892722454ygrp-sponsor #yiv4892722454ov ul {margin:0;padding:0 0 0 8px;}#yiv4892722454 #yiv4892722454ygrp-text {font-family:Georgia;}#yiv4892722454 #yiv4892722454ygrp-text p {margin:0 0 1em 0;}#yiv4892722454 #yiv4892722454ygrp-text tt {font-size:120%;}#yiv4892722454 #yiv4892722454ygrp-vital ul li:last-child {border-right:none !important;}#yiv4892722454

Fri Oct 30, 2015 1:29 am (PDT) . Posted by:

"HAIRUL ALAM"

Yth.Para Master
Mohon Pencerahan untuk file terlampir, agar pada OUTPUT bekerja otomatis sesuai dengan data INPUT
Terimakasih Banyak
SalamHairul Alam
============================================================
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:

Posting Komentar