[belajar-excel] Digest Number 4475

Milis Belajar Microsoft Excel Group

9 Messages

Digest #4475

1a

Rincian PO by "Kusnadi Bin zain" kbinzain

1b

Re: Rincian PO by "ghozi alkatiri" ghozialkatiri

1c

Bls: [belajar-excel] Rincian PO by "odong nando"

1d

Re: Rincian PO by "M.Ade Alfarid" aderyo

1e

Re: Rincian PO by "ghozi alkatiri" ghozialkatiri

1f

Re: Rincian PO by "Pak Cik Lukman"

1g

Bls: [belajar-excel] Rincian PO by "odong nando"

1h

Re: Rincian PO by "ghozi alkatiri" ghozialkatiri

1i

Fw: Bls: [belajar-excel] Rincian PO by "hendrik karnadi" hendrikkarnadi

Messages

1a

Rincian PO

Wed Apr 4, 2018 5:31 pm (PDT) . Posted by:

"Kusnadi Bin zain" kbinzain

dear pakar Excell
mohon bantuaanya untuk kasus Rician PO kesamping seperti ini rumusnya bagaimana ya

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1b

Re: Rincian PO

Wed Apr 4, 2018 7:41 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

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 kbinzain@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
#yiv1396792047 #yiv1396792047 -- #yiv1396792047ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1396792047 #yiv1396792047ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1396792047 #yiv1396792047ygrp-mkp #yiv1396792047hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1396792047 #yiv1396792047ygrp-mkp #yiv1396792047ads {margin-bottom:10px;}#yiv1396792047 #yiv1396792047ygrp-mkp .yiv1396792047ad {padding:0 0;}#yiv1396792047 #yiv1396792047ygrp-mkp .yiv1396792047ad p {margin:0;}#yiv1396792047 #yiv1396792047ygrp-mkp .yiv1396792047ad a {color:#0000ff;text-decoration:none;}#yiv1396792047 #yiv1396792047ygrp-sponsor #yiv1396792047ygrp-lc {font-family:Arial;}#yiv1396792047 #yiv1396792047ygrp-sponsor #yiv1396792047ygrp-lc #yiv1396792047hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1396792047 #yiv1396792047ygrp-sponsor #yiv1396792047ygrp-lc .yiv1396792047ad {margin-bottom:10px;padding:0 0;}#yiv1396792047 #yiv1396792047actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1396792047 #yiv1396792047activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1396792047 #yiv1396792047activity span {font-weight:700;}#yiv1396792047 #yiv1396792047activity span:first-child {text-transform:uppercase;}#yiv1396792047 #yiv1396792047activity span a {color:#5085b6;text-decoration:none;}#yiv1396792047 #yiv1396792047activity span span {color:#ff7900;}#yiv1396792047 #yiv1396792047activity span .yiv1396792047underline {text-decoration:underline;}#yiv1396792047 .yiv1396792047attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1396792047 .yiv1396792047attach div a {text-decoration:none;}#yiv1396792047 .yiv1396792047attach img {border:none;padding-right:5px;}#yiv1396792047 .yiv1396792047attach label {display:block;margin-bottom:5px;}#yiv1396792047 .yiv1396792047attach label a {text-decoration:none;}#yiv1396792047 blockquote {margin:0 0 0 4px;}#yiv1396792047 .yiv1396792047bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1396792047 .yiv1396792047bold a {text-decoration:none;}#yiv1396792047 dd.yiv1396792047last p a {font-family:Verdana;font-weight:700;}#yiv1396792047 dd.yiv1396792047last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1396792047 dd.yiv1396792047last p span.yiv1396792047yshortcuts {margin-right:0;}#yiv1396792047 div.yiv1396792047attach-table div div a {text-decoration:none;}#yiv1396792047 div.yiv1396792047attach-table {width:400px;}#yiv1396792047 div.yiv1396792047file-title a, #yiv1396792047 div.yiv1396792047file-title a:active, #yiv1396792047 div.yiv1396792047file-title a:hover, #yiv1396792047 div.yiv1396792047file-title a:visited {text-decoration:none;}#yiv1396792047 div.yiv1396792047photo-title a, #yiv1396792047 div.yiv1396792047photo-title a:active, #yiv1396792047 div.yiv1396792047photo-title a:hover, #yiv1396792047 div.yiv1396792047photo-title a:visited {text-decoration:none;}#yiv1396792047 div#yiv1396792047ygrp-mlmsg #yiv1396792047ygrp-msg p a span.yiv1396792047yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1396792047 .yiv1396792047green {color:#628c2a;}#yiv1396792047 .yiv1396792047MsoNormal {margin:0 0 0 0;}#yiv1396792047 o {font-size:0;}#yiv1396792047 #yiv1396792047photos div {float:left;width:72px;}#yiv1396792047 #yiv1396792047photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1396792047 #yiv1396792047photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1396792047 #yiv1396792047reco-category {font-size:77%;}#yiv1396792047 #yiv1396792047reco-desc {font-size:77%;}#yiv1396792047 .yiv1396792047replbq {margin:4px;}#yiv1396792047 #yiv1396792047ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1396792047 #yiv1396792047ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1396792047 #yiv1396792047ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1396792047 #yiv1396792047ygrp-mlmsg select, #yiv1396792047 input, #yiv1396792047 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1396792047 #yiv1396792047ygrp-mlmsg pre, #yiv1396792047 code {font:115% monospace;}#yiv1396792047 #yiv1396792047ygrp-mlmsg * {line-height:1..22em;}#yiv1396792047 #yiv1396792047ygrp-mlmsg #yiv1396792047logo {padding-bottom:10px;}#yiv1396792047 #yiv1396792047ygrp-msg p a {font-family:Verdana;}#yiv1396792047 #yiv1396792047ygrp-msg p#yiv1396792047attach-count span {color:#1E66AE;font-weight:700;}#yiv1396792047 #yiv1396792047ygrp-reco #yiv1396792047reco-head {color:#ff7900;font-weight:700;}#yiv1396792047 #yiv1396792047ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1396792047 #yiv1396792047ygrp-sponsor #yiv1396792047ov li a {font-size:130%;text-decoration:none;}#yiv1396792047 #yiv1396792047ygrp-sponsor #yiv1396792047ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1396792047 #yiv1396792047ygrp-sponsor #yiv1396792047ov ul {margin:0;padding:0 0 0 8px;}#yiv1396792047 #yiv1396792047ygrp-text {font-family:Georgia;}#yiv1396792047 #yiv1396792047ygrp-text p {margin:0 0 1em 0;}#yiv1396792047 #yiv1396792047ygrp-text tt {font-size:120%;}#yiv1396792047 #yiv1396792047ygrp-vital ul li:last-child {border-right:none !important;}#yiv1396792047

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1c

Bls: [belajar-excel] Rincian PO

Wed Apr 4, 2018 8:02 pm (PDT) . Posted by:

"odong nando"

 br,

odong nando

Dari: "Kusnadi Bin zain kbinzain@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 5 April 2018 7:31
Judul: [belajar-excel] Rincian PO

  dear pakar Excell
mohon bantuaanya untuk kasus Rician PO kesamping seperti ini rumusnya bagaimana ya
#yiv6630457683 #yiv6630457683 -- #yiv6630457683ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6630457683 #yiv6630457683ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6630457683 #yiv6630457683ygrp-mkp #yiv6630457683hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6630457683 #yiv6630457683ygrp-mkp #yiv6630457683ads {margin-bottom:10px;}#yiv6630457683 #yiv6630457683ygrp-mkp .yiv6630457683ad {padding:0 0;}#yiv6630457683 #yiv6630457683ygrp-mkp .yiv6630457683ad p {margin:0;}#yiv6630457683 #yiv6630457683ygrp-mkp .yiv6630457683ad a {color:#0000ff;text-decoration:none;}#yiv6630457683 #yiv6630457683ygrp-sponsor #yiv6630457683ygrp-lc {font-family:Arial;}#yiv6630457683 #yiv6630457683ygrp-sponsor #yiv6630457683ygrp-lc #yiv6630457683hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6630457683 #yiv6630457683ygrp-sponsor #yiv6630457683ygrp-lc .yiv6630457683ad {margin-bottom:10px;padding:0 0;}#yiv6630457683 #yiv6630457683actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6630457683 #yiv6630457683activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6630457683 #yiv6630457683activity span {font-weight:700;}#yiv6630457683 #yiv6630457683activity span:first-child {text-transform:uppercase;}#yiv6630457683 #yiv6630457683activity span a {color:#5085b6;text-decoration:none;}#yiv6630457683 #yiv6630457683activity span span {color:#ff7900;}#yiv6630457683 #yiv6630457683activity span .yiv6630457683underline {text-decoration:underline;}#yiv6630457683 .yiv6630457683attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6630457683 .yiv6630457683attach div a {text-decoration:none;}#yiv6630457683 .yiv6630457683attach img {border:none;padding-right:5px;}#yiv6630457683 .yiv6630457683attach label {display:block;margin-bottom:5px;}#yiv6630457683 .yiv6630457683attach label a {text-decoration:none;}#yiv6630457683 blockquote {margin:0 0 0 4px;}#yiv6630457683 .yiv6630457683bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6630457683 .yiv6630457683bold a {text-decoration:none;}#yiv6630457683 dd.yiv6630457683last p a {font-family:Verdana;font-weight:700;}#yiv6630457683 dd.yiv6630457683last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6630457683 dd.yiv6630457683last p span.yiv6630457683yshortcuts {margin-right:0;}#yiv6630457683 div.yiv6630457683attach-table div div a {text-decoration:none;}#yiv6630457683 div.yiv6630457683attach-table {width:400px;}#yiv6630457683 div.yiv6630457683file-title a, #yiv6630457683 div.yiv6630457683file-title a:active, #yiv6630457683 div.yiv6630457683file-title a:hover, #yiv6630457683 div.yiv6630457683file-title a:visited {text-decoration:none;}#yiv6630457683 div.yiv6630457683photo-title a, #yiv6630457683 div.yiv6630457683photo-title a:active, #yiv6630457683 div.yiv6630457683photo-title a:hover, #yiv6630457683 div.yiv6630457683photo-title a:visited {text-decoration:none;}#yiv6630457683 div#yiv6630457683ygrp-mlmsg #yiv6630457683ygrp-msg p a span.yiv6630457683yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6630457683 .yiv6630457683green {color:#628c2a;}#yiv6630457683 .yiv6630457683MsoNormal {margin:0 0 0 0;}#yiv6630457683 o {font-size:0;}#yiv6630457683 #yiv6630457683photos div {float:left;width:72px;}#yiv6630457683 #yiv6630457683photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6630457683 #yiv6630457683photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6630457683 #yiv6630457683reco-category {font-size:77%;}#yiv6630457683 #yiv6630457683reco-desc {font-size:77%;}#yiv6630457683 .yiv6630457683replbq {margin:4px;}#yiv6630457683 #yiv6630457683ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6630457683 #yiv6630457683ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6630457683 #yiv6630457683ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6630457683 #yiv6630457683ygrp-mlmsg select, #yiv6630457683 input, #yiv6630457683 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6630457683 #yiv6630457683ygrp-mlmsg pre, #yiv6630457683 code {font:115% monospace;}#yiv6630457683 #yiv6630457683ygrp-mlmsg * {line-height:1..22em;}#yiv6630457683 #yiv6630457683ygrp-mlmsg #yiv6630457683logo {padding-bottom:10px;}#yiv6630457683 #yiv6630457683ygrp-msg p a {font-family:Verdana;}#yiv6630457683 #yiv6630457683ygrp-msg p#yiv6630457683attach-count span {color:#1E66AE;font-weight:700;}#yiv6630457683 #yiv6630457683ygrp-reco #yiv6630457683reco-head {color:#ff7900;font-weight:700;}#yiv6630457683 #yiv6630457683ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6630457683 #yiv6630457683ygrp-sponsor #yiv6630457683ov li a {font-size:130%;text-decoration:none;}#yiv6630457683 #yiv6630457683ygrp-sponsor #yiv6630457683ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6630457683 #yiv6630457683ygrp-sponsor #yiv6630457683ov ul {margin:0;padding:0 0 0 8px;}#yiv6630457683 #yiv6630457683ygrp-text {font-family:Georgia;}#yiv6630457683 #yiv6630457683ygrp-text p {margin:0 0 1em 0;}#yiv6630457683 #yiv6630457683ygrp-text tt {font-size:120%;}#yiv6630457683 #yiv6630457683ygrp-vital ul li:last-child {border-right:none !important;}#yiv6630457683

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1d

Re: Rincian PO

Wed Apr 4, 2018 8:10 pm (PDT) . Posted by:

"M.Ade Alfarid" aderyo

Master Ghozi & Od Nando,

Bagaimana jika ada penambahan ID & PO number?

Apakah formulanya mesti diubah setiap penambahan ID dan PO yang baru?

Kemungkinan besar source PO tersebut bertambah.

Ade

*From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]

*Sent:* Thursday, April 5, 2018 9:59 AM
*To:* belajar-excel@yahoogroups.com
*Subject:* Bls: [belajar-excel] Rincian PO

br,

odong nando

------------------------------

*Dari:* "Kusnadi Bin zain kbinzain@yahoo.co.id [belajar-excel]" <
belajar-excel@yahoogroups.com>
*Kepada:* belajar-excel@yahoogroups.com
*Dikirim:* Kamis, 5 April 2018 7:31
*Judul:* [belajar-excel] Rincian PO

dear pakar Excell

mohon bantuaanya untuk kasus Rician PO kesamping seperti ini rumusnya
bagaimana ya

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1e

Re: Rincian PO

Wed Apr 4, 2018 10:14 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

tinggal ditambahkan aja bentang range datanya 
misalnya pada kolom ID yang semula di formula hanya B3:B9
ditambahkan lebih panjang sesuai kebutuhan misalkan  sampaiB3:B1000
demikian juga pada pada PO Number  jadi C3:C1000
wassalam
Ghozi Alkatiri Pada Kamis, 5 April 2018 10.15.07 GMT+7, 'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Master Ghozi & Od Nando,

Bagaimana jika ada penambahan ID & PO number?

Apakah formulanya mesti diubah setiap penambahan ID dan PO yang baru?

Kemungkinan besar source PO tersebut bertambah.

 

 

Ade

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, April 5, 2018 9:59 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Rincian PO

 

 

 

br,

odong nando

 

Dari: "Kusnadi Bin zain kbinzain@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 5 April 2018 7:31
Judul: [belajar-excel] Rincian PO

 

 

dear pakar Excell

 

mohon bantuaanya untuk kasus Rician PO kesamping seperti ini rumusnya bagaimana ya

 

 

#yiv3507885064 #yiv3507885064 -- #yiv3507885064ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3507885064 #yiv3507885064ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3507885064 #yiv3507885064ygrp-mkp #yiv3507885064hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3507885064 #yiv3507885064ygrp-mkp #yiv3507885064ads {margin-bottom:10px;}#yiv3507885064 #yiv3507885064ygrp-mkp .yiv3507885064ad {padding:0 0;}#yiv3507885064 #yiv3507885064ygrp-mkp .yiv3507885064ad p {margin:0;}#yiv3507885064 #yiv3507885064ygrp-mkp .yiv3507885064ad a {color:#0000ff;text-decoration:none;}#yiv3507885064 #yiv3507885064ygrp-sponsor #yiv3507885064ygrp-lc {font-family:Arial;}#yiv3507885064 #yiv3507885064ygrp-sponsor #yiv3507885064ygrp-lc #yiv3507885064hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3507885064 #yiv3507885064ygrp-sponsor #yiv3507885064ygrp-lc .yiv3507885064ad {margin-bottom:10px;padding:0 0;}#yiv3507885064 #yiv3507885064actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3507885064 #yiv3507885064activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3507885064 #yiv3507885064activity span {font-weight:700;}#yiv3507885064 #yiv3507885064activity span:first-child {text-transform:uppercase;}#yiv3507885064 #yiv3507885064activity span a {color:#5085b6;text-decoration:none;}#yiv3507885064 #yiv3507885064activity span span {color:#ff7900;}#yiv3507885064 #yiv3507885064activity span .yiv3507885064underline {text-decoration:underline;}#yiv3507885064 .yiv3507885064attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3507885064 .yiv3507885064attach div a {text-decoration:none;}#yiv3507885064 .yiv3507885064attach img {border:none;padding-right:5px;}#yiv3507885064 .yiv3507885064attach label {display:block;margin-bottom:5px;}#yiv3507885064 .yiv3507885064attach label a {text-decoration:none;}#yiv3507885064 blockquote {margin:0 0 0 4px;}#yiv3507885064 .yiv3507885064bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3507885064 .yiv3507885064bold a {text-decoration:none;}#yiv3507885064 dd.yiv3507885064last p a {font-family:Verdana;font-weight:700;}#yiv3507885064 dd.yiv3507885064last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3507885064 dd.yiv3507885064last p span.yiv3507885064yshortcuts {margin-right:0;}#yiv3507885064 div.yiv3507885064attach-table div div a {text-decoration:none;}#yiv3507885064 div.yiv3507885064attach-table {width:400px;}#yiv3507885064 div.yiv3507885064file-title a, #yiv3507885064 div.yiv3507885064file-title a:active, #yiv3507885064 div.yiv3507885064file-title a:hover, #yiv3507885064 div.yiv3507885064file-title a:visited {text-decoration:none;}#yiv3507885064 div.yiv3507885064photo-title a, #yiv3507885064 div.yiv3507885064photo-title a:active, #yiv3507885064 div.yiv3507885064photo-title a:hover, #yiv3507885064 div.yiv3507885064photo-title a:visited {text-decoration:none;}#yiv3507885064 div#yiv3507885064ygrp-mlmsg #yiv3507885064ygrp-msg p a span.yiv3507885064yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3507885064 .yiv3507885064green {color:#628c2a;}#yiv3507885064 .yiv3507885064MsoNormal {margin:0 0 0 0;}#yiv3507885064 o {font-size:0;}#yiv3507885064 #yiv3507885064photos div {float:left;width:72px;}#yiv3507885064 #yiv3507885064photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3507885064 #yiv3507885064photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3507885064 #yiv3507885064reco-category {font-size:77%;}#yiv3507885064 #yiv3507885064reco-desc {font-size:77%;}#yiv3507885064 .yiv3507885064replbq {margin:4px;}#yiv3507885064 #yiv3507885064ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3507885064 #yiv3507885064ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3507885064 #yiv3507885064ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3507885064 #yiv3507885064ygrp-mlmsg select, #yiv3507885064 input, #yiv3507885064 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3507885064 #yiv3507885064ygrp-mlmsg pre, #yiv3507885064 code {font:115% monospace;}#yiv3507885064 #yiv3507885064ygrp-mlmsg * {line-height:1.22em;}#yiv3507885064 #yiv3507885064ygrp-mlmsg #yiv3507885064logo {padding-bottom:10px;}#yiv3507885064 #yiv3507885064ygrp-msg p a {font-family:Verdana;}#yiv3507885064 #yiv3507885064ygrp-msg p#yiv3507885064attach-count span {color:#1E66AE;font-weight:700;}#yiv3507885064 #yiv3507885064ygrp-reco #yiv3507885064reco-head {color:#ff7900;font-weight:700;}#yiv3507885064 #yiv3507885064ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3507885064 #yiv3507885064ygrp-sponsor #yiv3507885064ov li a {font-size:130%;text-decoration:none;}#yiv3507885064 #yiv3507885064ygrp-sponsor #yiv3507885064ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3507885064 #yiv3507885064ygrp-sponsor #yiv3507885064ov ul {margin:0;padding:0 0 0 8px;}#yiv3507885064 #yiv3507885064ygrp-text {font-family:Georgia;}#yiv3507885064 #yiv3507885064ygrp-text p {margin:0 0 1em 0;}#yiv3507885064 #yiv3507885064ygrp-text tt {font-size:120%;}#yiv3507885064 #yiv3507885064ygrp-vital ul li:last-child {border-right:none !important;}#yiv3507885064

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1f

Re: Rincian PO

Wed Apr 4, 2018 10:47 pm (PDT) . Posted by:

"Pak Cik Lukman"

Wahh terima kasih pak Ghozi,

Sekalian mau tanya juga dong
Jika 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 ghozialkatiri@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 kbinzain@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
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1g

Bls: [belajar-excel] Rincian PO

Thu Apr 5, 2018 12:07 am (PDT) . Posted by:

"odong nando"

pahami formulanya, buat kembali rangkai dengan kombinasi table excel ID dan PO NUMBER br,

odong nando

Dari: "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 5 April 2018 10:14
Judul: RE: [belajar-excel] Rincian PO

  Master Ghozi & Od Nando,Bagaimana jika ada penambahan ID & PO number?Apakah formulanya mesti diubah setiap penambahan ID dan PO yang baru?Kemungkinan besar source PO tersebut bertambah.  Ade From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, April 5, 2018 9:59 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Rincian PO    br,

odong nando Dari: "Kusnadi Bin zain kbinzain@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 5 April 2018 7:31
Judul: [belajar-excel] Rincian PO   dear pakar Excell mohon bantuaanya untuk kasus Rician PO kesamping seperti ini rumusnya bagaimana ya   #yiv1969811829 #yiv1969811829 -- #yiv1969811829ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1969811829 #yiv1969811829ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1969811829 #yiv1969811829ygrp-mkp #yiv1969811829hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1969811829 #yiv1969811829ygrp-mkp #yiv1969811829ads {margin-bottom:10px;}#yiv1969811829 #yiv1969811829ygrp-mkp .yiv1969811829ad {padding:0 0;}#yiv1969811829 #yiv1969811829ygrp-mkp .yiv1969811829ad p {margin:0;}#yiv1969811829 #yiv1969811829ygrp-mkp .yiv1969811829ad a {color:#0000ff;text-decoration:none;}#yiv1969811829 #yiv1969811829ygrp-sponsor #yiv1969811829ygrp-lc {font-family:Arial;}#yiv1969811829 #yiv1969811829ygrp-sponsor #yiv1969811829ygrp-lc #yiv1969811829hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1969811829 #yiv1969811829ygrp-sponsor #yiv1969811829ygrp-lc .yiv1969811829ad {margin-bottom:10px;padding:0 0;}#yiv1969811829 #yiv1969811829actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1969811829 #yiv1969811829activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1969811829 #yiv1969811829activity span {font-weight:700;}#yiv1969811829 #yiv1969811829activity span:first-child {text-transform:uppercase;}#yiv1969811829 #yiv1969811829activity span a {color:#5085b6;text-decoration:none;}#yiv1969811829 #yiv1969811829activity span span {color:#ff7900;}#yiv1969811829 #yiv1969811829activity span .yiv1969811829underline {text-decoration:underline;}#yiv1969811829 .yiv1969811829attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1969811829 .yiv1969811829attach div a {text-decoration:none;}#yiv1969811829 .yiv1969811829attach img {border:none;padding-right:5px;}#yiv1969811829 .yiv1969811829attach label {display:block;margin-bottom:5px;}#yiv1969811829 .yiv1969811829attach label a {text-decoration:none;}#yiv1969811829 blockquote {margin:0 0 0 4px;}#yiv1969811829 .yiv1969811829bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1969811829 .yiv1969811829bold a {text-decoration:none;}#yiv1969811829 dd.yiv1969811829last p a {font-family:Verdana;font-weight:700;}#yiv1969811829 dd.yiv1969811829last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1969811829 dd.yiv1969811829last p span.yiv1969811829yshortcuts {margin-right:0;}#yiv1969811829 div.yiv1969811829attach-table div div a {text-decoration:none;}#yiv1969811829 div.yiv1969811829attach-table {width:400px;}#yiv1969811829 div.yiv1969811829file-title a, #yiv1969811829 div.yiv1969811829file-title a:active, #yiv1969811829 div.yiv1969811829file-title a:hover, #yiv1969811829 div.yiv1969811829file-title a:visited {text-decoration:none;}#yiv1969811829 div.yiv1969811829photo-title a, #yiv1969811829 div.yiv1969811829photo-title a:active, #yiv1969811829 div.yiv1969811829photo-title a:hover, #yiv1969811829 div.yiv1969811829photo-title a:visited {text-decoration:none;}#yiv1969811829 div#yiv1969811829ygrp-mlmsg #yiv1969811829ygrp-msg p a span.yiv1969811829yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1969811829 .yiv1969811829green {color:#628c2a;}#yiv1969811829 .yiv1969811829MsoNormal {margin:0 0 0 0;}#yiv1969811829 o {font-size:0;}#yiv1969811829 #yiv1969811829photos div {float:left;width:72px;}#yiv1969811829 #yiv1969811829photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1969811829 #yiv1969811829photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1969811829 #yiv1969811829reco-category {font-size:77%;}#yiv1969811829 #yiv1969811829reco-desc {font-size:77%;}#yiv1969811829 .yiv1969811829replbq {margin:4px;}#yiv1969811829 #yiv1969811829ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1969811829 #yiv1969811829ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1969811829 #yiv1969811829ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1969811829 #yiv1969811829ygrp-mlmsg select, #yiv1969811829 input, #yiv1969811829 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1969811829 #yiv1969811829ygrp-mlmsg pre, #yiv1969811829 code {font:115% monospace;}#yiv1969811829 #yiv1969811829ygrp-mlmsg * {line-height:1.22em;}#yiv1969811829 #yiv1969811829ygrp-mlmsg #yiv1969811829logo {padding-bottom:10px;}#yiv1969811829 #yiv1969811829ygrp-msg p a {font-family:Verdana;}#yiv1969811829 #yiv1969811829ygrp-msg p#yiv1969811829attach-count span {color:#1E66AE;font-weight:700;}#yiv1969811829 #yiv1969811829ygrp-reco #yiv1969811829reco-head {color:#ff7900;font-weight:700;}#yiv1969811829 #yiv1969811829ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1969811829 #yiv1969811829ygrp-sponsor #yiv1969811829ov li a {font-size:130%;text-decoration:none;}#yiv1969811829 #yiv1969811829ygrp-sponsor #yiv1969811829ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1969811829 #yiv1969811829ygrp-sponsor #yiv1969811829ov ul {margin:0;padding:0 0 0 8px;}#yiv1969811829 #yiv1969811829ygrp-text {font-family:Georgia;}#yiv1969811829 #yiv1969811829ygrp-text p {margin:0 0 1em 0;}#yiv1969811829 #yiv1969811829ygrp-text tt {font-size:120%;}#yiv1969811829 #yiv1969811829ygrp-vital ul li:last-child {border-right:none !important;}#yiv1969811829

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1h

Re: Rincian PO

Thu Apr 5, 2018 2:54 am (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

kirimkan contoh filenya dan apa yang diinginkan supaya saya paham maksudnya.
wassalam 
Ghozi Alkatiri
Pada Kamis, 5 April 2018 12.48.07 GMT+7, Pak Cik Lukman pakciklukman@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

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 ghozialkatiri@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 kbinzain@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


#yiv9020966376 #yiv9020966376 -- #yiv9020966376ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9020966376 #yiv9020966376ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9020966376 #yiv9020966376ygrp-mkp #yiv9020966376hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9020966376 #yiv9020966376ygrp-mkp #yiv9020966376ads {margin-bottom:10px;}#yiv9020966376 #yiv9020966376ygrp-mkp .yiv9020966376ad {padding:0 0;}#yiv9020966376 #yiv9020966376ygrp-mkp .yiv9020966376ad p {margin:0;}#yiv9020966376 #yiv9020966376ygrp-mkp .yiv9020966376ad a {color:#0000ff;text-decoration:none;}#yiv9020966376 #yiv9020966376ygrp-sponsor #yiv9020966376ygrp-lc {font-family:Arial;}#yiv9020966376 #yiv9020966376ygrp-sponsor #yiv9020966376ygrp-lc #yiv9020966376hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9020966376 #yiv9020966376ygrp-sponsor #yiv9020966376ygrp-lc .yiv9020966376ad {margin-bottom:10px;padding:0 0;}#yiv9020966376 #yiv9020966376actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9020966376 #yiv9020966376activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9020966376 #yiv9020966376activity span {font-weight:700;}#yiv9020966376 #yiv9020966376activity span:first-child {text-transform:uppercase;}#yiv9020966376 #yiv9020966376activity span a {color:#5085b6;text-decoration:none;}#yiv9020966376 #yiv9020966376activity span span {color:#ff7900;}#yiv9020966376 #yiv9020966376activity span .yiv9020966376underline {text-decoration:underline;}#yiv9020966376 .yiv9020966376attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9020966376 .yiv9020966376attach div a {text-decoration:none;}#yiv9020966376 .yiv9020966376attach img {border:none;padding-right:5px;}#yiv9020966376 .yiv9020966376attach label {display:block;margin-bottom:5px;}#yiv9020966376 .yiv9020966376attach label a {text-decoration:none;}#yiv9020966376 blockquote {margin:0 0 0 4px;}#yiv9020966376 .yiv9020966376bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9020966376 .yiv9020966376bold a {text-decoration:none;}#yiv9020966376 dd.yiv9020966376last p a {font-family:Verdana;font-weight:700;}#yiv9020966376 dd.yiv9020966376last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9020966376 dd.yiv9020966376last p span.yiv9020966376yshortcuts {margin-right:0;}#yiv9020966376 div.yiv9020966376attach-table div div a {text-decoration:none;}#yiv9020966376 div.yiv9020966376attach-table {width:400px;}#yiv9020966376 div.yiv9020966376file-title a, #yiv9020966376 div.yiv9020966376file-title a:active, #yiv9020966376 div.yiv9020966376file-title a:hover, #yiv9020966376 div.yiv9020966376file-title a:visited {text-decoration:none;}#yiv9020966376 div.yiv9020966376photo-title a, #yiv9020966376 div.yiv9020966376photo-title a:active, #yiv9020966376 div.yiv9020966376photo-title a:hover, #yiv9020966376 div.yiv9020966376photo-title a:visited {text-decoration:none;}#yiv9020966376 div#yiv9020966376ygrp-mlmsg #yiv9020966376ygrp-msg p a span.yiv9020966376yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9020966376 .yiv9020966376green {color:#628c2a;}#yiv9020966376 .yiv9020966376MsoNormal {margin:0 0 0 0;}#yiv9020966376 o {font-size:0;}#yiv9020966376 #yiv9020966376photos div {float:left;width:72px;}#yiv9020966376 #yiv9020966376photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9020966376 #yiv9020966376photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9020966376 #yiv9020966376reco-category {font-size:77%;}#yiv9020966376 #yiv9020966376reco-desc {font-size:77%;}#yiv9020966376 .yiv9020966376replbq {margin:4px;}#yiv9020966376 #yiv9020966376ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9020966376 #yiv9020966376ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9020966376 #yiv9020966376ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9020966376 #yiv9020966376ygrp-mlmsg select, #yiv9020966376 input, #yiv9020966376 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9020966376 #yiv9020966376ygrp-mlmsg pre, #yiv9020966376 code {font:115% monospace;}#yiv9020966376 #yiv9020966376ygrp-mlmsg * {line-height:1.22em;}#yiv9020966376 #yiv9020966376ygrp-mlmsg #yiv9020966376logo {padding-bottom:10px;}#yiv9020966376 #yiv9020966376ygrp-msg p a {font-family:Verdana;}#yiv9020966376 #yiv9020966376ygrp-msg p#yiv9020966376attach-count span {color:#1E66AE;font-weight:700;}#yiv9020966376 #yiv9020966376ygrp-reco #yiv9020966376reco-head {color:#ff7900;font-weight:700;}#yiv9020966376 #yiv9020966376ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9020966376 #yiv9020966376ygrp-sponsor #yiv9020966376ov li a {font-size:130%;text-decoration:none;}#yiv9020966376 #yiv9020966376ygrp-sponsor #yiv9020966376ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9020966376 #yiv9020966376ygrp-sponsor #yiv9020966376ov ul {margin:0;padding:0 0 0 8px;}#yiv9020966376 #yiv9020966376ygrp-text {font-family:Georgia;}#yiv9020966376 #yiv9020966376ygrp-text p {margin:0 0 1em 0;}#yiv9020966376 #yiv9020966376ygrp-text tt {font-size:120%;}#yiv9020966376 #yiv9020966376ygrp-vital ul li:last-child {border-right:none !important;}#yiv9020966376

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1i

Fw: Bls: [belajar-excel] Rincian PO

Thu Apr 5, 2018 9:27 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Ade,Pinjam formula pak Ghozi ditambah kolom bantu....Kalau ada perubahan data, seperti saran beliau, ya formulanya harus disesuaikan..
Salam,HK

----- Forwarded message ----- From: odong nando odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>To: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>Sent: Thursday, 5 April 2018, 2:07:32 PM GMT+7Subject: Bls: [belajar-excel] Rincian PO
 

pahami formulanya, buat kembali rangkai dengan kombinasi table excel ID dan PO NUMBER br,

odong nando

Dari: "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 5 April 2018 10:14
Judul: RE: [belajar-excel] Rincian PO

  Master Ghozi & Od Nando,Bagaimana jika ada penambahan ID & PO number?Apakah formulanya mesti diubah setiap penambahan ID dan PO yang baru?Kemungkinan besar source PO tersebut bertambah.  Ade From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, April 5, 2018 9:59 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Rincian PO    br,

odong nando Dari: "Kusnadi Bin zain kbinzain@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 5 April 2018 7:31
Judul: [belajar-excel] Rincian PO   dear pakar Excell mohon bantuaanya untuk kasus Rician PO kesamping seperti ini rumusnya bagaimana ya  

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

============================================================
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
---------------------------------------------------------------------

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use