iya nih boz kid, ahir tahun blm closing jg makanya lg konsen kesana...hehe...
padahal sepele, tp klo blm tau tetep aja bingung...
hahahaha...
thx ya boz kid.... br,
odong nando
Dari: "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]>
Kepada: BeExcel <[email protected]>
Dikirim: Selasa, 21 Februari 2017 19:15
Judul: Re: [belajar-excel] Lookup Transporse
Hai Odong,
Tumben muncul.
Pivot table bila diklik akan muncul menu tools PivotTable Tools. Pada ribbon
Analyze (xl2010 ke atas) atau ribbon Options (xl2007) ada group bernama Show
(xl2010 ke atas) atau Show/Hide (xl2007). Salah satu item dalam group tersebut
adalah Field Headers (berupa toogle button).
Regards,
Kid
On Tue, Feb 21, 2017 at 6:12 PM, odong nando [email protected]
[belajar-excel] <[email protected]> wrote:
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
#yiv8471060761 #yiv8471060761 -- #yiv8471060761ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8471060761
#yiv8471060761ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8471060761
#yiv8471060761ygrp-mkp #yiv8471060761hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8471060761 #yiv8471060761ygrp-mkp #yiv8471060761ads
{margin-bottom:10px;}#yiv8471060761 #yiv8471060761ygrp-mkp .yiv8471060761ad
{padding:0 0;}#yiv8471060761 #yiv8471060761ygrp-mkp .yiv8471060761ad p
{margin:0;}#yiv8471060761 #yiv8471060761ygrp-mkp .yiv8471060761ad a
{color:#0000ff;text-decoration:none;}#yiv8471060761 #yiv8471060761ygrp-sponsor
#yiv8471060761ygrp-lc {font-family:Arial;}#yiv8471060761
#yiv8471060761ygrp-sponsor #yiv8471060761ygrp-lc #yiv8471060761hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8471060761
#yiv8471060761ygrp-sponsor #yiv8471060761ygrp-lc .yiv8471060761ad
{margin-bottom:10px;padding:0 0;}#yiv8471060761 #yiv8471060761actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8471060761
#yiv8471060761activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8471060761
#yiv8471060761activity span {font-weight:700;}#yiv8471060761
#yiv8471060761activity span:first-child
{text-transform:uppercase;}#yiv8471060761 #yiv8471060761activity span a
{color:#5085b6;text-decoration:none;}#yiv8471060761 #yiv8471060761activity span
span {color:#ff7900;}#yiv8471060761 #yiv8471060761activity span
.yiv8471060761underline {text-decoration:underline;}#yiv8471060761
.yiv8471060761attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8471060761 .yiv8471060761attach div a
{text-decoration:none;}#yiv8471060761 .yiv8471060761attach img
{border:none;padding-right:5px;}#yiv8471060761 .yiv8471060761attach label
{display:block;margin-bottom:5px;}#yiv8471060761 .yiv8471060761attach label a
{text-decoration:none;}#yiv8471060761 blockquote {margin:0 0 0
4px;}#yiv8471060761 .yiv8471060761bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8471060761
.yiv8471060761bold a {text-decoration:none;}#yiv8471060761 dd.yiv8471060761last
p a {font-family:Verdana;font-weight:700;}#yiv8471060761 dd.yiv8471060761last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8471060761
dd.yiv8471060761last p span.yiv8471060761yshortcuts
{margin-right:0;}#yiv8471060761 div.yiv8471060761attach-table div div a
{text-decoration:none;}#yiv8471060761 div.yiv8471060761attach-table
{width:400px;}#yiv8471060761 div.yiv8471060761file-title a, #yiv8471060761
div.yiv8471060761file-title a:active, #yiv8471060761
div.yiv8471060761file-title a:hover, #yiv8471060761 div.yiv8471060761file-title
a:visited {text-decoration:none;}#yiv8471060761 div.yiv8471060761photo-title a,
#yiv8471060761 div.yiv8471060761photo-title a:active, #yiv8471060761
div.yiv8471060761photo-title a:hover, #yiv8471060761
div.yiv8471060761photo-title a:visited {text-decoration:none;}#yiv8471060761
div#yiv8471060761ygrp-mlmsg #yiv8471060761ygrp-msg p a
span.yiv8471060761yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8471060761
.yiv8471060761green {color:#628c2a;}#yiv8471060761 .yiv8471060761MsoNormal
{margin:0 0 0 0;}#yiv8471060761 o {font-size:0;}#yiv8471060761
#yiv8471060761photos div {float:left;width:72px;}#yiv8471060761
#yiv8471060761photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8471060761
#yiv8471060761photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8471060761
#yiv8471060761reco-category {font-size:77%;}#yiv8471060761
#yiv8471060761reco-desc {font-size:77%;}#yiv8471060761 .yiv8471060761replbq
{margin:4px;}#yiv8471060761 #yiv8471060761ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8471060761 #yiv8471060761ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8471060761
#yiv8471060761ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8471060761
#yiv8471060761ygrp-mlmsg select, #yiv8471060761 input, #yiv8471060761 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8471060761
#yiv8471060761ygrp-mlmsg pre, #yiv8471060761 code {font:115%
monospace;}#yiv8471060761 #yiv8471060761ygrp-mlmsg *
{line-height:1.22em;}#yiv8471060761 #yiv8471060761ygrp-mlmsg #yiv8471060761logo
{padding-bottom:10px;}#yiv8471060761 #yiv8471060761ygrp-msg p a
{font-family:Verdana;}#yiv8471060761 #yiv8471060761ygrp-msg
p#yiv8471060761attach-count span {color:#1E66AE;font-weight:700;}#yiv8471060761
#yiv8471060761ygrp-reco #yiv8471060761reco-head
{color:#ff7900;font-weight:700;}#yiv8471060761 #yiv8471060761ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8471060761 #yiv8471060761ygrp-sponsor
#yiv8471060761ov li a {font-size:130%;text-decoration:none;}#yiv8471060761
#yiv8471060761ygrp-sponsor #yiv8471060761ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8471060761
#yiv8471060761ygrp-sponsor #yiv8471060761ov ul {margin:0;padding:0 0 0
8px;}#yiv8471060761 #yiv8471060761ygrp-text
{font-family:Georgia;}#yiv8471060761 #yiv8471060761ygrp-text p {margin:0 0 1em
0;}#yiv8471060761 #yiv8471060761ygrp-text tt {font-size:120%;}#yiv8471060761
#yiv8471060761ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8471060761
