Assalamualaikum
Yth. Pak KID
Terimakasih Banyak Penjelasannya, Sangat membantu, yang tadinya tidak tau jadi
tau, Alhamdulillah bertambah ilmunya, makin suksess ya dan semoga berkah
Wassalamualaikum
Pada Sabtu, 2 Januari 2016 21:28, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
wa'alaikumussalam wr wb
Hai Hairul,
Pakai kolom bantu di sisi data berisi formula penyusun teks output yang
diinginkan.
Kemudian, pada cells output menggunakan fungsi LookUp untuk mengambil teks dari
kolom bantu di sisi data tadi.
File terlampir.
Wassalamu'alaikum wr wb
Kid
2016-01-02 17:59 GMT+07:00 HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:
Assalamualaikum
Yth. Para Master
Saya sedang membuat data status pekerjaan seperti data terlampir,
Bagaimana Rumusnya agar dapat terisi otomatis sesuai data yang diinput
Terimakasih
Wassalamualaikum
#yiv2001420024 #yiv2001420024 -- #yiv2001420024ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2001420024
#yiv2001420024ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2001420024
#yiv2001420024ygrp-mkp #yiv2001420024hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2001420024 #yiv2001420024ygrp-mkp #yiv2001420024ads
{margin-bottom:10px;}#yiv2001420024 #yiv2001420024ygrp-mkp .yiv2001420024ad
{padding:0 0;}#yiv2001420024 #yiv2001420024ygrp-mkp .yiv2001420024ad p
{margin:0;}#yiv2001420024 #yiv2001420024ygrp-mkp .yiv2001420024ad a
{color:#0000ff;text-decoration:none;}#yiv2001420024 #yiv2001420024ygrp-sponsor
#yiv2001420024ygrp-lc {font-family:Arial;}#yiv2001420024
#yiv2001420024ygrp-sponsor #yiv2001420024ygrp-lc #yiv2001420024hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2001420024
#yiv2001420024ygrp-sponsor #yiv2001420024ygrp-lc .yiv2001420024ad
{margin-bottom:10px;padding:0 0;}#yiv2001420024 #yiv2001420024actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2001420024
#yiv2001420024activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2001420024
#yiv2001420024activity span {font-weight:700;}#yiv2001420024
#yiv2001420024activity span:first-child
{text-transform:uppercase;}#yiv2001420024 #yiv2001420024activity span a
{color:#5085b6;text-decoration:none;}#yiv2001420024 #yiv2001420024activity span
span {color:#ff7900;}#yiv2001420024 #yiv2001420024activity span
.yiv2001420024underline {text-decoration:underline;}#yiv2001420024
.yiv2001420024attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2001420024 .yiv2001420024attach div a
{text-decoration:none;}#yiv2001420024 .yiv2001420024attach img
{border:none;padding-right:5px;}#yiv2001420024 .yiv2001420024attach label
{display:block;margin-bottom:5px;}#yiv2001420024 .yiv2001420024attach label a
{text-decoration:none;}#yiv2001420024 blockquote {margin:0 0 0
4px;}#yiv2001420024 .yiv2001420024bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2001420024
.yiv2001420024bold a {text-decoration:none;}#yiv2001420024 dd.yiv2001420024last
p a {font-family:Verdana;font-weight:700;}#yiv2001420024 dd.yiv2001420024last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2001420024
dd.yiv2001420024last p span.yiv2001420024yshortcuts
{margin-right:0;}#yiv2001420024 div.yiv2001420024attach-table div div a
{text-decoration:none;}#yiv2001420024 div.yiv2001420024attach-table
{width:400px;}#yiv2001420024 div.yiv2001420024file-title a, #yiv2001420024
div.yiv2001420024file-title a:active, #yiv2001420024
div.yiv2001420024file-title a:hover, #yiv2001420024 div.yiv2001420024file-title
a:visited {text-decoration:none;}#yiv2001420024 div.yiv2001420024photo-title a,
#yiv2001420024 div.yiv2001420024photo-title a:active, #yiv2001420024
div.yiv2001420024photo-title a:hover, #yiv2001420024
div.yiv2001420024photo-title a:visited {text-decoration:none;}#yiv2001420024
div#yiv2001420024ygrp-mlmsg #yiv2001420024ygrp-msg p a
span.yiv2001420024yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2001420024
.yiv2001420024green {color:#628c2a;}#yiv2001420024 .yiv2001420024MsoNormal
{margin:0 0 0 0;}#yiv2001420024 o {font-size:0;}#yiv2001420024
#yiv2001420024photos div {float:left;width:72px;}#yiv2001420024
#yiv2001420024photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2001420024
#yiv2001420024photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2001420024
#yiv2001420024reco-category {font-size:77%;}#yiv2001420024
#yiv2001420024reco-desc {font-size:77%;}#yiv2001420024 .yiv2001420024replbq
{margin:4px;}#yiv2001420024 #yiv2001420024ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2001420024 #yiv2001420024ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2001420024
#yiv2001420024ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2001420024
#yiv2001420024ygrp-mlmsg select, #yiv2001420024 input, #yiv2001420024 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2001420024
#yiv2001420024ygrp-mlmsg pre, #yiv2001420024 code {font:115%
monospace;}#yiv2001420024 #yiv2001420024ygrp-mlmsg *
{line-height:1.22em;}#yiv2001420024 #yiv2001420024ygrp-mlmsg #yiv2001420024logo
{padding-bottom:10px;}#yiv2001420024 #yiv2001420024ygrp-msg p a
{font-family:Verdana;}#yiv2001420024 #yiv2001420024ygrp-msg
p#yiv2001420024attach-count span {color:#1E66AE;font-weight:700;}#yiv2001420024
#yiv2001420024ygrp-reco #yiv2001420024reco-head
{color:#ff7900;font-weight:700;}#yiv2001420024 #yiv2001420024ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2001420024 #yiv2001420024ygrp-sponsor
#yiv2001420024ov li a {font-size:130%;text-decoration:none;}#yiv2001420024
#yiv2001420024ygrp-sponsor #yiv2001420024ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2001420024
#yiv2001420024ygrp-sponsor #yiv2001420024ov ul {margin:0;padding:0 0 0
8px;}#yiv2001420024 #yiv2001420024ygrp-text
{font-family:Georgia;}#yiv2001420024 #yiv2001420024ygrp-text p {margin:0 0 1em
0;}#yiv2001420024 #yiv2001420024ygrp-text tt {font-size:120%;}#yiv2001420024
#yiv2001420024ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2001420024
