Dear Pakar yang budiman,
Terimakasih atas solusi nya Mr.Kid dan temans semua..amazing sekali..saya pikir
Excel tidak dapat memecahkan masalah..ternyata masalah ini bisa berada ditangan
yang handal dan baik..
Salam,TonyB
Pada Kamis, 22 Januari 2015 19:57, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Tony,
File terlampir menggunakan 2 buah kolom bantu pada sisi data. Kolom bantu
pertama untuk menyusun id setiap item pertama kombinasi week dan kode. Kolom
bantu kedua untuk menyusun teks gabungan berdasar kolom bantu pertama.
Nilai-nilai data di kolom bantu kedua yang diambil untuk hasil akhir.
Wassalam,
Kid.
2015-01-22 13:58 GMT+11:00 Tony Bexcel [email protected] [belajar-excel]
<[email protected]>:
Dear Pakar dan temans semua..
Mohon bantuan nya untuk solusi terlampir..Yang ingin ditanyakan pada kolom
pengisian yang diberi tanda kuning.Selama ini dilakukan secara manual seperti
contoh yg saya lakukan,bagaimana kah rumusan dalam excel agar mempermudah input
nya.?Terimakasih atas segala bantuan ilmu dan waktu nya.
Salam,Tony B
#yiv3163045466 #yiv3163045466 -- #yiv3163045466ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3163045466
#yiv3163045466ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3163045466
#yiv3163045466ygrp-mkp #yiv3163045466hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3163045466 #yiv3163045466ygrp-mkp #yiv3163045466ads
{margin-bottom:10px;}#yiv3163045466 #yiv3163045466ygrp-mkp .yiv3163045466ad
{padding:0 0;}#yiv3163045466 #yiv3163045466ygrp-mkp .yiv3163045466ad p
{margin:0;}#yiv3163045466 #yiv3163045466ygrp-mkp .yiv3163045466ad a
{color:#0000ff;text-decoration:none;}#yiv3163045466 #yiv3163045466ygrp-sponsor
#yiv3163045466ygrp-lc {font-family:Arial;}#yiv3163045466
#yiv3163045466ygrp-sponsor #yiv3163045466ygrp-lc #yiv3163045466hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3163045466
#yiv3163045466ygrp-sponsor #yiv3163045466ygrp-lc .yiv3163045466ad
{margin-bottom:10px;padding:0 0;}#yiv3163045466 #yiv3163045466actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3163045466
#yiv3163045466activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3163045466
#yiv3163045466activity span {font-weight:700;}#yiv3163045466
#yiv3163045466activity span:first-child
{text-transform:uppercase;}#yiv3163045466 #yiv3163045466activity span a
{color:#5085b6;text-decoration:none;}#yiv3163045466 #yiv3163045466activity span
span {color:#ff7900;}#yiv3163045466 #yiv3163045466activity span
.yiv3163045466underline {text-decoration:underline;}#yiv3163045466
.yiv3163045466attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3163045466 .yiv3163045466attach div a
{text-decoration:none;}#yiv3163045466 .yiv3163045466attach img
{border:none;padding-right:5px;}#yiv3163045466 .yiv3163045466attach label
{display:block;margin-bottom:5px;}#yiv3163045466 .yiv3163045466attach label a
{text-decoration:none;}#yiv3163045466 blockquote {margin:0 0 0
4px;}#yiv3163045466 .yiv3163045466bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3163045466
.yiv3163045466bold a {text-decoration:none;}#yiv3163045466 dd.yiv3163045466last
p a {font-family:Verdana;font-weight:700;}#yiv3163045466 dd.yiv3163045466last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3163045466
dd.yiv3163045466last p span.yiv3163045466yshortcuts
{margin-right:0;}#yiv3163045466 div.yiv3163045466attach-table div div a
{text-decoration:none;}#yiv3163045466 div.yiv3163045466attach-table
{width:400px;}#yiv3163045466 div.yiv3163045466file-title a, #yiv3163045466
div.yiv3163045466file-title a:active, #yiv3163045466
div.yiv3163045466file-title a:hover, #yiv3163045466 div.yiv3163045466file-title
a:visited {text-decoration:none;}#yiv3163045466 div.yiv3163045466photo-title a,
#yiv3163045466 div.yiv3163045466photo-title a:active, #yiv3163045466
div.yiv3163045466photo-title a:hover, #yiv3163045466
div.yiv3163045466photo-title a:visited {text-decoration:none;}#yiv3163045466
div#yiv3163045466ygrp-mlmsg #yiv3163045466ygrp-msg p a
span.yiv3163045466yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3163045466
.yiv3163045466green {color:#628c2a;}#yiv3163045466 .yiv3163045466MsoNormal
{margin:0 0 0 0;}#yiv3163045466 o {font-size:0;}#yiv3163045466
#yiv3163045466photos div {float:left;width:72px;}#yiv3163045466
#yiv3163045466photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3163045466
#yiv3163045466photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3163045466
#yiv3163045466reco-category {font-size:77%;}#yiv3163045466
#yiv3163045466reco-desc {font-size:77%;}#yiv3163045466 .yiv3163045466replbq
{margin:4px;}#yiv3163045466 #yiv3163045466ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3163045466 #yiv3163045466ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3163045466
#yiv3163045466ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3163045466
#yiv3163045466ygrp-mlmsg select, #yiv3163045466 input, #yiv3163045466 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3163045466
#yiv3163045466ygrp-mlmsg pre, #yiv3163045466 code {font:115%
monospace;}#yiv3163045466 #yiv3163045466ygrp-mlmsg *
{line-height:1.22em;}#yiv3163045466 #yiv3163045466ygrp-mlmsg #yiv3163045466logo
{padding-bottom:10px;}#yiv3163045466 #yiv3163045466ygrp-msg p a
{font-family:Verdana;}#yiv3163045466 #yiv3163045466ygrp-msg
p#yiv3163045466attach-count span {color:#1E66AE;font-weight:700;}#yiv3163045466
#yiv3163045466ygrp-reco #yiv3163045466reco-head
{color:#ff7900;font-weight:700;}#yiv3163045466 #yiv3163045466ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3163045466 #yiv3163045466ygrp-sponsor
#yiv3163045466ov li a {font-size:130%;text-decoration:none;}#yiv3163045466
#yiv3163045466ygrp-sponsor #yiv3163045466ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3163045466
#yiv3163045466ygrp-sponsor #yiv3163045466ov ul {margin:0;padding:0 0 0
8px;}#yiv3163045466 #yiv3163045466ygrp-text
{font-family:Georgia;}#yiv3163045466 #yiv3163045466ygrp-text p {margin:0 0 1em
0;}#yiv3163045466 #yiv3163045466ygrp-text tt {font-size:120%;}#yiv3163045466
#yiv3163045466ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3163045466
