Maaf Pak Odong, Benar sekali saya memang belum terlalu paham, saya pikir isian
yang di samping itu manual, karena tidak dijelasin, tiba-tiba muncul hasil.
Terimakasih Banyak Penjelasannya
Pada Kamis, 22 Oktober 2015 14:34, "odong nando odongna...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
maaf pak hairul, saya rasa apa yang sudah di buat bos kid sudah memenuni
semua keinginan yang bpk mau, namun saya mengira bahwa bpk tidak bisa
membedakan mana hasil kalkulasi dari pivot table dan bukan (manual), berikut
saya lampirkan yang sudah terbuka dan tampak jelas hasil dari povot table file
boz kid yang terdahulu.
thx,
odong nando
Pada Kamis, 22 Oktober 2015 14:13, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
wa'alaikumussalam wr wb
Maaf, rada gagal paham atas penjelasan Anda nih.
Bagaimana jika Anda coba lebih dulu di file lampiran dalam email tempo lalu.
Jika ada yang kurang pas, silakan lampirkan hasil uji coba Anda tersebut ke
milis.
Wassalamu'alaikum wr wb.
Kid
On Thu, Oct 22, 2015 at 1:56 PM, HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Assalamualaikum
Maaf Saya Mengganggu
Terimakasih atas pencerahannya, bila data saya rubah input tanggalnya diluar
dari contoh 1 sd 4 = 4, 5 sd 6 = 0, 7sd9 =3, 10 = 0, 11 sd 16 =6, 17=0, 18sd22
= 5, namun saya lihat untuk range nya yang saya beri warna merah tetap di buat
manual, kalau misal data 1 sd 22 bukan range tsb diatas misalakan 1sd2, 4sd6,
8sd12, 14sd22 diisi nilai apakah output bisa otomatis menujjukan seperti range
yang saya beri warna kuning
Wassalamualaikum
Pada Selasa, 20 Oktober 2015 10:07, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb
File terlampir dengan banyak sekali kolom bantu sebagai pembentuk tabel data
yang utuh.
Wassalamu'alaikum wr wb
Kid
2015-10-20 6:09 GMT+07:00 HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:
Assalamualaikum
Nama Saya : Hairul Alam
Saya memiliki masalah tentang excel untuk mengelompokkan data secara otomatis
seperti contoh terlampir, mohon pencerahannya
TerimakasihWassalamualaikum
#yiv5426785627 #yiv5426785627 -- #yiv5426785627ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5426785627
#yiv5426785627ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5426785627
#yiv5426785627ygrp-mkp #yiv5426785627hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5426785627 #yiv5426785627ygrp-mkp #yiv5426785627ads
{margin-bottom:10px;}#yiv5426785627 #yiv5426785627ygrp-mkp .yiv5426785627ad
{padding:0 0;}#yiv5426785627 #yiv5426785627ygrp-mkp .yiv5426785627ad p
{margin:0;}#yiv5426785627 #yiv5426785627ygrp-mkp .yiv5426785627ad a
{color:#0000ff;text-decoration:none;}#yiv5426785627 #yiv5426785627ygrp-sponsor
#yiv5426785627ygrp-lc {font-family:Arial;}#yiv5426785627
#yiv5426785627ygrp-sponsor #yiv5426785627ygrp-lc #yiv5426785627hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5426785627
#yiv5426785627ygrp-sponsor #yiv5426785627ygrp-lc .yiv5426785627ad
{margin-bottom:10px;padding:0 0;}#yiv5426785627 #yiv5426785627actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5426785627
#yiv5426785627activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5426785627
#yiv5426785627activity span {font-weight:700;}#yiv5426785627
#yiv5426785627activity span:first-child
{text-transform:uppercase;}#yiv5426785627 #yiv5426785627activity span a
{color:#5085b6;text-decoration:none;}#yiv5426785627 #yiv5426785627activity span
span {color:#ff7900;}#yiv5426785627 #yiv5426785627activity span
.yiv5426785627underline {text-decoration:underline;}#yiv5426785627
.yiv5426785627attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5426785627 .yiv5426785627attach div a
{text-decoration:none;}#yiv5426785627 .yiv5426785627attach img
{border:none;padding-right:5px;}#yiv5426785627 .yiv5426785627attach label
{display:block;margin-bottom:5px;}#yiv5426785627 .yiv5426785627attach label a
{text-decoration:none;}#yiv5426785627 blockquote {margin:0 0 0
4px;}#yiv5426785627 .yiv5426785627bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5426785627
.yiv5426785627bold a {text-decoration:none;}#yiv5426785627 dd.yiv5426785627last
p a {font-family:Verdana;font-weight:700;}#yiv5426785627 dd.yiv5426785627last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5426785627
dd.yiv5426785627last p span.yiv5426785627yshortcuts
{margin-right:0;}#yiv5426785627 div.yiv5426785627attach-table div div a
{text-decoration:none;}#yiv5426785627 div.yiv5426785627attach-table
{width:400px;}#yiv5426785627 div.yiv5426785627file-title a, #yiv5426785627
div.yiv5426785627file-title a:active, #yiv5426785627
div.yiv5426785627file-title a:hover, #yiv5426785627 div.yiv5426785627file-title
a:visited {text-decoration:none;}#yiv5426785627 div.yiv5426785627photo-title a,
#yiv5426785627 div.yiv5426785627photo-title a:active, #yiv5426785627
div.yiv5426785627photo-title a:hover, #yiv5426785627
div.yiv5426785627photo-title a:visited {text-decoration:none;}#yiv5426785627
div#yiv5426785627ygrp-mlmsg #yiv5426785627ygrp-msg p a
span.yiv5426785627yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5426785627
.yiv5426785627green {color:#628c2a;}#yiv5426785627 .yiv5426785627MsoNormal
{margin:0 0 0 0;}#yiv5426785627 o {font-size:0;}#yiv5426785627
#yiv5426785627photos div {float:left;width:72px;}#yiv5426785627
#yiv5426785627photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5426785627
#yiv5426785627photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5426785627
#yiv5426785627reco-category {font-size:77%;}#yiv5426785627
#yiv5426785627reco-desc {font-size:77%;}#yiv5426785627 .yiv5426785627replbq
{margin:4px;}#yiv5426785627 #yiv5426785627ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5426785627 #yiv5426785627ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5426785627
#yiv5426785627ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5426785627
#yiv5426785627ygrp-mlmsg select, #yiv5426785627 input, #yiv5426785627 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5426785627
#yiv5426785627ygrp-mlmsg pre, #yiv5426785627 code {font:115%
monospace;}#yiv5426785627 #yiv5426785627ygrp-mlmsg *
{line-height:1.22em;}#yiv5426785627 #yiv5426785627ygrp-mlmsg #yiv5426785627logo
{padding-bottom:10px;}#yiv5426785627 #yiv5426785627ygrp-msg p a
{font-family:Verdana;}#yiv5426785627 #yiv5426785627ygrp-msg
p#yiv5426785627attach-count span {color:#1E66AE;font-weight:700;}#yiv5426785627
#yiv5426785627ygrp-reco #yiv5426785627reco-head
{color:#ff7900;font-weight:700;}#yiv5426785627 #yiv5426785627ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5426785627 #yiv5426785627ygrp-sponsor
#yiv5426785627ov li a {font-size:130%;text-decoration:none;}#yiv5426785627
#yiv5426785627ygrp-sponsor #yiv5426785627ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5426785627
#yiv5426785627ygrp-sponsor #yiv5426785627ov ul {margin:0;padding:0 0 0
8px;}#yiv5426785627 #yiv5426785627ygrp-text
{font-family:Georgia;}#yiv5426785627 #yiv5426785627ygrp-text p {margin:0 0 1em
0;}#yiv5426785627 #yiv5426785627ygrp-text tt {font-size:120%;}#yiv5426785627
#yiv5426785627ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5426785627
