dear bos kid,
itu gmn ya cara nyusun pivot tablenya... kok ga da headernya ya... apa di
sembunyiin di mana ya...? tp kok ga da yang di hiden...hehe... br,
odong nando
Dari: "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]>
Kepada: BeExcel <[email protected]>
Dikirim: Selasa, 21 Februari 2017 9:40
Judul: Re: [belajar-excel] Lookup Transporse [1 Attachment]
Hai Modby,
File terlampir sekadar alternatif tanpa VBA dan untuk Excel 2010 ke atas.
Regards,
Kid
2017-02-14 17:48 GMT+07:00 Modby Matsnawabi [email protected] [belajar-excel]
<[email protected]>:
Dear rekan-rekan B-Excel,
Selamat sore,
Sebelum libur Pilkada, mohon dibantu penyelesai case berikut ini.
saya punya master data di sheet "data"Data dari sheet tersebut bermaksud saya
uraikan sesuai dengan jumlah hari kerja per minggu di bulan berjalan (table
bantuan ada di sheet "WD").yang sulit saya lakukan adalah jika perhitungan di
minggu akhir atau awal bulan dimana, ada terikut hari kerja yang masuk ke bulan
berikutnya sehingga angka "SUM" nya pun berbeda dengan angka "SUM" di bulan
tersebut lalu mentranspose hasilnya ke row dibawahnya.hasil dari calculasi
tersebut akan muncul di sheet hasil.
Mohon solusi dan pencerahanya.
Terima kasih,
Modby
#yiv1129665656 #yiv1129665656 -- #yiv1129665656ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1129665656
#yiv1129665656ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1129665656
#yiv1129665656ygrp-mkp #yiv1129665656hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1129665656 #yiv1129665656ygrp-mkp #yiv1129665656ads
{margin-bottom:10px;}#yiv1129665656 #yiv1129665656ygrp-mkp .yiv1129665656ad
{padding:0 0;}#yiv1129665656 #yiv1129665656ygrp-mkp .yiv1129665656ad p
{margin:0;}#yiv1129665656 #yiv1129665656ygrp-mkp .yiv1129665656ad a
{color:#0000ff;text-decoration:none;}#yiv1129665656 #yiv1129665656ygrp-sponsor
#yiv1129665656ygrp-lc {font-family:Arial;}#yiv1129665656
#yiv1129665656ygrp-sponsor #yiv1129665656ygrp-lc #yiv1129665656hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1129665656
#yiv1129665656ygrp-sponsor #yiv1129665656ygrp-lc .yiv1129665656ad
{margin-bottom:10px;padding:0 0;}#yiv1129665656 #yiv1129665656actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1129665656
#yiv1129665656activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1129665656
#yiv1129665656activity span {font-weight:700;}#yiv1129665656
#yiv1129665656activity span:first-child
{text-transform:uppercase;}#yiv1129665656 #yiv1129665656activity span a
{color:#5085b6;text-decoration:none;}#yiv1129665656 #yiv1129665656activity span
span {color:#ff7900;}#yiv1129665656 #yiv1129665656activity span
.yiv1129665656underline {text-decoration:underline;}#yiv1129665656
.yiv1129665656attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1129665656 .yiv1129665656attach div a
{text-decoration:none;}#yiv1129665656 .yiv1129665656attach img
{border:none;padding-right:5px;}#yiv1129665656 .yiv1129665656attach label
{display:block;margin-bottom:5px;}#yiv1129665656 .yiv1129665656attach label a
{text-decoration:none;}#yiv1129665656 blockquote {margin:0 0 0
4px;}#yiv1129665656 .yiv1129665656bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1129665656
.yiv1129665656bold a {text-decoration:none;}#yiv1129665656 dd.yiv1129665656last
p a {font-family:Verdana;font-weight:700;}#yiv1129665656 dd.yiv1129665656last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1129665656
dd.yiv1129665656last p span.yiv1129665656yshortcuts
{margin-right:0;}#yiv1129665656 div.yiv1129665656attach-table div div a
{text-decoration:none;}#yiv1129665656 div.yiv1129665656attach-table
{width:400px;}#yiv1129665656 div.yiv1129665656file-title a, #yiv1129665656
div.yiv1129665656file-title a:active, #yiv1129665656
div.yiv1129665656file-title a:hover, #yiv1129665656 div.yiv1129665656file-title
a:visited {text-decoration:none;}#yiv1129665656 div.yiv1129665656photo-title a,
#yiv1129665656 div.yiv1129665656photo-title a:active, #yiv1129665656
div.yiv1129665656photo-title a:hover, #yiv1129665656
div.yiv1129665656photo-title a:visited {text-decoration:none;}#yiv1129665656
div#yiv1129665656ygrp-mlmsg #yiv1129665656ygrp-msg p a
span.yiv1129665656yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1129665656
.yiv1129665656green {color:#628c2a;}#yiv1129665656 .yiv1129665656MsoNormal
{margin:0 0 0 0;}#yiv1129665656 o {font-size:0;}#yiv1129665656
#yiv1129665656photos div {float:left;width:72px;}#yiv1129665656
#yiv1129665656photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1129665656
#yiv1129665656photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1129665656
#yiv1129665656reco-category {font-size:77%;}#yiv1129665656
#yiv1129665656reco-desc {font-size:77%;}#yiv1129665656 .yiv1129665656replbq
{margin:4px;}#yiv1129665656 #yiv1129665656ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1129665656 #yiv1129665656ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1129665656
#yiv1129665656ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1129665656
#yiv1129665656ygrp-mlmsg select, #yiv1129665656 input, #yiv1129665656 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1129665656
#yiv1129665656ygrp-mlmsg pre, #yiv1129665656 code {font:115%
monospace;}#yiv1129665656 #yiv1129665656ygrp-mlmsg *
{line-height:1.22em;}#yiv1129665656 #yiv1129665656ygrp-mlmsg #yiv1129665656logo
{padding-bottom:10px;}#yiv1129665656 #yiv1129665656ygrp-msg p a
{font-family:Verdana;}#yiv1129665656 #yiv1129665656ygrp-msg
p#yiv1129665656attach-count span {color:#1E66AE;font-weight:700;}#yiv1129665656
#yiv1129665656ygrp-reco #yiv1129665656reco-head
{color:#ff7900;font-weight:700;}#yiv1129665656 #yiv1129665656ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1129665656 #yiv1129665656ygrp-sponsor
#yiv1129665656ov li a {font-size:130%;text-decoration:none;}#yiv1129665656
#yiv1129665656ygrp-sponsor #yiv1129665656ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1129665656
#yiv1129665656ygrp-sponsor #yiv1129665656ov ul {margin:0;padding:0 0 0
8px;}#yiv1129665656 #yiv1129665656ygrp-text
{font-family:Georgia;}#yiv1129665656 #yiv1129665656ygrp-text p {margin:0 0 1em
0;}#yiv1129665656 #yiv1129665656ygrp-text tt {font-size:120%;}#yiv1129665656
#yiv1129665656ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1129665656
