Dear Farud,
Mungkin seperti ini..
TerimaKasih.
Pada Jumat, 17 Februari 2017 13:49, "farud oke [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamualaikum para master
Mohon maaf bertanya lagi dengan pertanyaan yang hampir sama dengan yg
kemarin,tapi kali ini berdasarkan kata bukan angka.saya coba otak atik sendiri
gak bisa2 jadi saya lempar saja pertanyaannya disini karena insya Allah para
master excel disini bisa menyelesaikannya.lebih jelasnya ada di file
atas bantuannya saya sampaikan terimakasih
#yiv7219759563 #yiv7219759563 -- #yiv7219759563ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7219759563
#yiv7219759563ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7219759563
#yiv7219759563ygrp-mkp #yiv7219759563hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7219759563 #yiv7219759563ygrp-mkp #yiv7219759563ads
{margin-bottom:10px;}#yiv7219759563 #yiv7219759563ygrp-mkp .yiv7219759563ad
{padding:0 0;}#yiv7219759563 #yiv7219759563ygrp-mkp .yiv7219759563ad p
{margin:0;}#yiv7219759563 #yiv7219759563ygrp-mkp .yiv7219759563ad a
{color:#0000ff;text-decoration:none;}#yiv7219759563 #yiv7219759563ygrp-sponsor
#yiv7219759563ygrp-lc {font-family:Arial;}#yiv7219759563
#yiv7219759563ygrp-sponsor #yiv7219759563ygrp-lc #yiv7219759563hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7219759563
#yiv7219759563ygrp-sponsor #yiv7219759563ygrp-lc .yiv7219759563ad
{margin-bottom:10px;padding:0 0;}#yiv7219759563 #yiv7219759563actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7219759563
#yiv7219759563activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7219759563
#yiv7219759563activity span {font-weight:700;}#yiv7219759563
#yiv7219759563activity span:first-child
{text-transform:uppercase;}#yiv7219759563 #yiv7219759563activity span a
{color:#5085b6;text-decoration:none;}#yiv7219759563 #yiv7219759563activity span
span {color:#ff7900;}#yiv7219759563 #yiv7219759563activity span
.yiv7219759563underline {text-decoration:underline;}#yiv7219759563
.yiv7219759563attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7219759563 .yiv7219759563attach div a
{text-decoration:none;}#yiv7219759563 .yiv7219759563attach img
{border:none;padding-right:5px;}#yiv7219759563 .yiv7219759563attach label
{display:block;margin-bottom:5px;}#yiv7219759563 .yiv7219759563attach label a
{text-decoration:none;}#yiv7219759563 blockquote {margin:0 0 0
4px;}#yiv7219759563 .yiv7219759563bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7219759563
.yiv7219759563bold a {text-decoration:none;}#yiv7219759563 dd.yiv7219759563last
p a {font-family:Verdana;font-weight:700;}#yiv7219759563 dd.yiv7219759563last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7219759563
dd.yiv7219759563last p span.yiv7219759563yshortcuts
{margin-right:0;}#yiv7219759563 div.yiv7219759563attach-table div div a
{text-decoration:none;}#yiv7219759563 div.yiv7219759563attach-table
{width:400px;}#yiv7219759563 div.yiv7219759563file-title a, #yiv7219759563
div.yiv7219759563file-title a:active, #yiv7219759563
div.yiv7219759563file-title a:hover, #yiv7219759563 div.yiv7219759563file-title
a:visited {text-decoration:none;}#yiv7219759563 div.yiv7219759563photo-title a,
#yiv7219759563 div.yiv7219759563photo-title a:active, #yiv7219759563
div.yiv7219759563photo-title a:hover, #yiv7219759563
div.yiv7219759563photo-title a:visited {text-decoration:none;}#yiv7219759563
div#yiv7219759563ygrp-mlmsg #yiv7219759563ygrp-msg p a
span.yiv7219759563yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7219759563
.yiv7219759563green {color:#628c2a;}#yiv7219759563 .yiv7219759563MsoNormal
{margin:0 0 0 0;}#yiv7219759563 o {font-size:0;}#yiv7219759563
#yiv7219759563photos div {float:left;width:72px;}#yiv7219759563
#yiv7219759563photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7219759563
#yiv7219759563photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7219759563
#yiv7219759563reco-category {font-size:77%;}#yiv7219759563
#yiv7219759563reco-desc {font-size:77%;}#yiv7219759563 .yiv7219759563replbq
{margin:4px;}#yiv7219759563 #yiv7219759563ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7219759563 #yiv7219759563ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7219759563
#yiv7219759563ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7219759563
#yiv7219759563ygrp-mlmsg select, #yiv7219759563 input, #yiv7219759563 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7219759563
#yiv7219759563ygrp-mlmsg pre, #yiv7219759563 code {font:115%
monospace;}#yiv7219759563 #yiv7219759563ygrp-mlmsg *
{line-height:1.22em;}#yiv7219759563 #yiv7219759563ygrp-mlmsg #yiv7219759563logo
{padding-bottom:10px;}#yiv7219759563 #yiv7219759563ygrp-msg p a
{font-family:Verdana;}#yiv7219759563 #yiv7219759563ygrp-msg
p#yiv7219759563attach-count span {color:#1E66AE;font-weight:700;}#yiv7219759563
#yiv7219759563ygrp-reco #yiv7219759563reco-head
{color:#ff7900;font-weight:700;}#yiv7219759563 #yiv7219759563ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7219759563 #yiv7219759563ygrp-sponsor
#yiv7219759563ov li a {font-size:130%;text-decoration:none;}#yiv7219759563
#yiv7219759563ygrp-sponsor #yiv7219759563ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7219759563
#yiv7219759563ygrp-sponsor #yiv7219759563ov ul {margin:0;padding:0 0 0
8px;}#yiv7219759563 #yiv7219759563ygrp-text
{font-family:Georgia;}#yiv7219759563 #yiv7219759563ygrp-text p {margin:0 0 1em
0;}#yiv7219759563 #yiv7219759563ygrp-text tt {font-size:120%;}#yiv7219759563
#yiv7219759563ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7219759563
sembunyi kolom berdasarkan kata1_Toby.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
