yoo prazt,
klo boleh saran, coba buat 1 tabel kolom bantu khusus untuk kata2 kerja, jadi
kata kerjanya sudah di kumpulkan dalam 1 tabel tersebut. setelah itu baru bisa
di cari dengan rumus excel yang mengacu pada tabel bantu yang sudah ada. jadi
apa pun karakter yang sudah anda masukan pada tabel bantu, akan menjadi acuan
untuk dicari dalam sebuah kalimat, hasil pencarian akan dikembalikan pada nilai
tabel tersebut.
dengan gabungan lookup, search dan metoda yang saya sebutkan di atas, masalah
anda akan terselesaikan.
= lookup ( 9^9 ; search ( _tabel bantu_ ; _cell kalimat yang akan di cari_ ) ;
_tabel bantu_ ) br,
odong nando
Pada Selasa, 12 Januari 2016 16:22, "'prazt' [email protected]
[belajar-excel]" <[email protected]> menulis:
Selamat sore para master dan teman-teman semuaMohon bantuannya, cara
mencari (mendapatkan) kata kerja dari suatu kalimat, sedangkan kalimat tersebut
tidak selalu tetapSaya sudah mencoba tapi belum pas dan mencari difile milis
tapi belum nemu juga, mungkin para rekan bisa membantu untuk membuatkan
formulanya.Penjelasan lebih lanjut seperti pada lampiranTerimakasih sebelumnya.
| | Email tidak mengandung virus pemeriksaan mengunakan piranti Avast
antivirus.
www.avast.com |
#yiv6112207510 #yiv6112207510 -- #yiv6112207510ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6112207510
#yiv6112207510ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6112207510
#yiv6112207510ygrp-mkp #yiv6112207510hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6112207510 #yiv6112207510ygrp-mkp #yiv6112207510ads
{margin-bottom:10px;}#yiv6112207510 #yiv6112207510ygrp-mkp .yiv6112207510ad
{padding:0 0;}#yiv6112207510 #yiv6112207510ygrp-mkp .yiv6112207510ad p
{margin:0;}#yiv6112207510 #yiv6112207510ygrp-mkp .yiv6112207510ad a
{color:#0000ff;text-decoration:none;}#yiv6112207510 #yiv6112207510ygrp-sponsor
#yiv6112207510ygrp-lc {font-family:Arial;}#yiv6112207510
#yiv6112207510ygrp-sponsor #yiv6112207510ygrp-lc #yiv6112207510hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6112207510
#yiv6112207510ygrp-sponsor #yiv6112207510ygrp-lc .yiv6112207510ad
{margin-bottom:10px;padding:0 0;}#yiv6112207510 #yiv6112207510actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6112207510
#yiv6112207510activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6112207510
#yiv6112207510activity span {font-weight:700;}#yiv6112207510
#yiv6112207510activity span:first-child
{text-transform:uppercase;}#yiv6112207510 #yiv6112207510activity span a
{color:#5085b6;text-decoration:none;}#yiv6112207510 #yiv6112207510activity span
span {color:#ff7900;}#yiv6112207510 #yiv6112207510activity span
.yiv6112207510underline {text-decoration:underline;}#yiv6112207510
.yiv6112207510attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6112207510 .yiv6112207510attach div a
{text-decoration:none;}#yiv6112207510 .yiv6112207510attach img
{border:none;padding-right:5px;}#yiv6112207510 .yiv6112207510attach label
{display:block;margin-bottom:5px;}#yiv6112207510 .yiv6112207510attach label a
{text-decoration:none;}#yiv6112207510 blockquote {margin:0 0 0
4px;}#yiv6112207510 .yiv6112207510bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6112207510
.yiv6112207510bold a {text-decoration:none;}#yiv6112207510 dd.yiv6112207510last
p a {font-family:Verdana;font-weight:700;}#yiv6112207510 dd.yiv6112207510last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6112207510
dd.yiv6112207510last p span.yiv6112207510yshortcuts
{margin-right:0;}#yiv6112207510 div.yiv6112207510attach-table div div a
{text-decoration:none;}#yiv6112207510 div.yiv6112207510attach-table
{width:400px;}#yiv6112207510 div.yiv6112207510file-title a, #yiv6112207510
div.yiv6112207510file-title a:active, #yiv6112207510
div.yiv6112207510file-title a:hover, #yiv6112207510 div.yiv6112207510file-title
a:visited {text-decoration:none;}#yiv6112207510 div.yiv6112207510photo-title a,
#yiv6112207510 div.yiv6112207510photo-title a:active, #yiv6112207510
div.yiv6112207510photo-title a:hover, #yiv6112207510
div.yiv6112207510photo-title a:visited {text-decoration:none;}#yiv6112207510
div#yiv6112207510ygrp-mlmsg #yiv6112207510ygrp-msg p a
span.yiv6112207510yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6112207510
.yiv6112207510green {color:#628c2a;}#yiv6112207510 .yiv6112207510MsoNormal
{margin:0 0 0 0;}#yiv6112207510 o {font-size:0;}#yiv6112207510
#yiv6112207510photos div {float:left;width:72px;}#yiv6112207510
#yiv6112207510photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6112207510
#yiv6112207510photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6112207510
#yiv6112207510reco-category {font-size:77%;}#yiv6112207510
#yiv6112207510reco-desc {font-size:77%;}#yiv6112207510 .yiv6112207510replbq
{margin:4px;}#yiv6112207510 #yiv6112207510ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6112207510 #yiv6112207510ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6112207510
#yiv6112207510ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6112207510
#yiv6112207510ygrp-mlmsg select, #yiv6112207510 input, #yiv6112207510 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6112207510
#yiv6112207510ygrp-mlmsg pre, #yiv6112207510 code {font:115%
monospace;}#yiv6112207510 #yiv6112207510ygrp-mlmsg *
{line-height:1.22em;}#yiv6112207510 #yiv6112207510ygrp-mlmsg #yiv6112207510logo
{padding-bottom:10px;}#yiv6112207510 #yiv6112207510ygrp-msg p a
{font-family:Verdana;}#yiv6112207510 #yiv6112207510ygrp-msg
p#yiv6112207510attach-count span {color:#1E66AE;font-weight:700;}#yiv6112207510
#yiv6112207510ygrp-reco #yiv6112207510reco-head
{color:#ff7900;font-weight:700;}#yiv6112207510 #yiv6112207510ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6112207510 #yiv6112207510ygrp-sponsor
#yiv6112207510ov li a {font-size:130%;text-decoration:none;}#yiv6112207510
#yiv6112207510ygrp-sponsor #yiv6112207510ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6112207510
#yiv6112207510ygrp-sponsor #yiv6112207510ov ul {margin:0;padding:0 0 0
8px;}#yiv6112207510 #yiv6112207510ygrp-text
{font-family:Georgia;}#yiv6112207510 #yiv6112207510ygrp-text p {margin:0 0 1em
0;}#yiv6112207510 #yiv6112207510ygrp-text tt {font-size:120%;}#yiv6112207510
#yiv6112207510ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6112207510
