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