trimakasih boz kid,
sy yakin om momod na ngerti kok...asal boz kid berkacanya sama cermin, bukan
sama tembok...hehehe....pizzz... br,
odong nando
Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
Dikirim: Rabu, 11 April 2018 14:41
Judul: Re: [belajar-excel] Rincian PO
Sila
*** sorry ya om momod, file size gak bisa dikurangi. Kebanyakan gambar kali..
Tapi kalo gambarnya dikurangi, nanti jadi sulit dipelajari...
statusnya jangan diturunin jadi di-moderasi ya... plis...
On Wed, Apr 11, 2018 at 2:31 PM, odong nando odongna...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
bos kid, klo senggang mau dunk di contoh ken pivot consolidation
nya...berikut penjelasannya yak....hehe,,,
br,
odong nando
Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com >
Kepada: BeExcel <belajar-excel@yahoogroups.com >
Dikirim: Selasa, 10 April 2018 20:21
Judul: Re: [belajar-excel] Rincian PO
Pakai pivot consolidation juga bisa.
2018-04-05 10:02 GMT+07:00 Pak Cik Lukman pakcikluk...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.. com>:
Wahh terima kasih pak Ghozi,
Sekalian mau tanya juga dongJika tabel tsb di balik, dari tabel menyamping
menjadi runut ke bawah (transpose), formulanya spt apa ya pak...
Terima kasih atas bantuannya
Salam, PCL
Sent from my iPhone
On Apr 5, 2018, at 9:40 AM, ghozi alkatiri ghozialkat...@yahoo..co.id
[belajar-excel] <belajar-excel@yahoogroups.com > wrote:
tulis di G4 (formula array)
=IFERROR(INDEX($B$3:$B$9, MATCH(,COUNTIF(G$3:G3,$B$3:$B$ 9),0)),"")
copy ke bawah
tulis di H4 (formula array)
=IFERROR(INDEX($C$3:$C$9, SMALL(IF($B$3:$B$9=$G4,ROW($B$
3:$B$9)-2),COLUMN(A:A))),"")
copy ke kanan dan ke bawah
wassalam
Ghozi Alkatiri Pada Kamis, 5 April 2018 07.31.48 GMT+7, Kusnadi Bin zain
kbinz...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com > menulis:
dear pakar Excell
mohon bantuaanya untuk kasus Rician PO kesamping seperti ini rumusnya bagaimana
ya
#yiv5721953094 #yiv5721953094 -- #yiv5721953094ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5721953094
#yiv5721953094ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5721953094
#yiv5721953094ygrp-mkp #yiv5721953094hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5721953094 #yiv5721953094ygrp-mkp #yiv5721953094ads
{margin-bottom:10px;}#yiv5721953094 #yiv5721953094ygrp-mkp .yiv5721953094ad
{padding:0 0;}#yiv5721953094 #yiv5721953094ygrp-mkp .yiv5721953094ad p
{margin:0;}#yiv5721953094 #yiv5721953094ygrp-mkp .yiv5721953094ad a
{color:#0000ff;text-decoration:none;}#yiv5721953094 #yiv5721953094ygrp-sponsor
#yiv5721953094ygrp-lc {font-family:Arial;}#yiv5721953094
#yiv5721953094ygrp-sponsor #yiv5721953094ygrp-lc #yiv5721953094hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5721953094
#yiv5721953094ygrp-sponsor #yiv5721953094ygrp-lc .yiv5721953094ad
{margin-bottom:10px;padding:0 0;}#yiv5721953094 #yiv5721953094actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5721953094
#yiv5721953094activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5721953094
#yiv5721953094activity span {font-weight:700;}#yiv5721953094
#yiv5721953094activity span:first-child
{text-transform:uppercase;}#yiv5721953094 #yiv5721953094activity span a
{color:#5085b6;text-decoration:none;}#yiv5721953094 #yiv5721953094activity span
span {color:#ff7900;}#yiv5721953094 #yiv5721953094activity span
.yiv5721953094underline {text-decoration:underline;}#yiv5721953094
.yiv5721953094attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5721953094 .yiv5721953094attach div a
{text-decoration:none;}#yiv5721953094 .yiv5721953094attach img
{border:none;padding-right:5px;}#yiv5721953094 .yiv5721953094attach label
{display:block;margin-bottom:5px;}#yiv5721953094 .yiv5721953094attach label a
{text-decoration:none;}#yiv5721953094 blockquote {margin:0 0 0
4px;}#yiv5721953094 .yiv5721953094bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5721953094
.yiv5721953094bold a {text-decoration:none;}#yiv5721953094 dd.yiv5721953094last
p a {font-family:Verdana;font-weight:700;}#yiv5721953094 dd.yiv5721953094last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5721953094
dd.yiv5721953094last p span.yiv5721953094yshortcuts
{margin-right:0;}#yiv5721953094 div.yiv5721953094attach-table div div a
{text-decoration:none;}#yiv5721953094 div.yiv5721953094attach-table
{width:400px;}#yiv5721953094 div.yiv5721953094file-title a, #yiv5721953094
div.yiv5721953094file-title a:active, #yiv5721953094
div.yiv5721953094file-title a:hover, #yiv5721953094 div.yiv5721953094file-title
a:visited {text-decoration:none;}#yiv5721953094 div.yiv5721953094photo-title a,
#yiv5721953094 div.yiv5721953094photo-title a:active, #yiv5721953094
div.yiv5721953094photo-title a:hover, #yiv5721953094
div.yiv5721953094photo-title a:visited {text-decoration:none;}#yiv5721953094
div#yiv5721953094ygrp-mlmsg #yiv5721953094ygrp-msg p a
span.yiv5721953094yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5721953094
.yiv5721953094green {color:#628c2a;}#yiv5721953094 .yiv5721953094MsoNormal
{margin:0 0 0 0;}#yiv5721953094 o {font-size:0;}#yiv5721953094
#yiv5721953094photos div {float:left;width:72px;}#yiv5721953094
#yiv5721953094photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5721953094
#yiv5721953094photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5721953094
#yiv5721953094reco-category {font-size:77%;}#yiv5721953094
#yiv5721953094reco-desc {font-size:77%;}#yiv5721953094 .yiv5721953094replbq
{margin:4px;}#yiv5721953094 #yiv5721953094ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5721953094 #yiv5721953094ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5721953094
#yiv5721953094ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5721953094
#yiv5721953094ygrp-mlmsg select, #yiv5721953094 input, #yiv5721953094 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5721953094
#yiv5721953094ygrp-mlmsg pre, #yiv5721953094 code {font:115%
monospace;}#yiv5721953094 #yiv5721953094ygrp-mlmsg *
{line-height:1.22em;}#yiv5721953094 #yiv5721953094ygrp-mlmsg #yiv5721953094logo
{padding-bottom:10px;}#yiv5721953094 #yiv5721953094ygrp-msg p a
{font-family:Verdana;}#yiv5721953094 #yiv5721953094ygrp-msg
p#yiv5721953094attach-count span {color:#1E66AE;font-weight:700;}#yiv5721953094
#yiv5721953094ygrp-reco #yiv5721953094reco-head
{color:#ff7900;font-weight:700;}#yiv5721953094 #yiv5721953094ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5721953094 #yiv5721953094ygrp-sponsor
#yiv5721953094ov li a {font-size:130%;text-decoration:none;}#yiv5721953094
#yiv5721953094ygrp-sponsor #yiv5721953094ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5721953094
#yiv5721953094ygrp-sponsor #yiv5721953094ov ul {margin:0;padding:0 0 0
8px;}#yiv5721953094 #yiv5721953094ygrp-text
{font-family:Georgia;}#yiv5721953094 #yiv5721953094ygrp-text p {margin:0 0 1em
0;}#yiv5721953094 #yiv5721953094ygrp-text tt {font-size:120%;}#yiv5721953094
#yiv5721953094ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5721953094
