Messages
Fri Apr 8, 2016 12:19 am (PDT) . Posted by:
On Friday, 8 April 2016, 14:04, "Susilo - susilo.ib@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Dear angan_lov3
Namanya cantik banget :)
di sel D20 tertulis rumus =HLOOKUP(MID(B20,7,2),$C$3:$G$4,2,FALSE)Saya mengubahnya sebagai berikut =LEFT(B20,5)&" "&HLOOKUP(MID(B20,7,2),$C$3:$G$4,2,FALSE)
Kemudian copy rumus D20 ke bawahSilakan dicoba
Terima kasihSusilo
Pada 8 April 2016 12.49, angan_lov3@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
thanks pak.. rumus yg anda kirim memang bekerja, namun tidak tepat dengan jawaban yang saya cari, seharusnya hasilnya menjadi "SMKN1 BINJAI"
mohon pencerahannya pak.. klo bisa formulanya dimasukkan ke attachment saya pak. thanks.
#yiv0171256961 #yiv0171256961 -- #yiv0171256961ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0171256961 #yiv0171256961ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0171256961 #yiv0171256961ygrp-mkp #yiv0171256961hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0171256961 #yiv0171256961ygrp-mkp #yiv0171256961ads {margin-bottom:10px;}#yiv0171256961 #yiv0171256961ygrp-mkp .yiv0171256961ad {padding:0 0;}#yiv0171256961 #yiv0171256961ygrp-mkp .yiv0171256961ad p {margin:0;}#yiv0171256961 #yiv0171256961ygrp-mkp .yiv0171256961ad a {color:#0000ff;text-decoration:none;}#yiv0171256961 #yiv0171256961ygrp-sponsor #yiv0171256961ygrp-lc {font-family:Arial;}#yiv0171256961 #yiv0171256961ygrp-sponsor #yiv0171256961ygrp-lc #yiv0171256961hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0171256961 #yiv0171256961ygrp-sponsor #yiv0171256961ygrp-lc .yiv0171256961ad {margin-bottom:10px;padding:0 0;}#yiv0171256961 #yiv0171256961actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0171256961 #yiv0171256961activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0171256961 #yiv0171256961activity span {font-weight:700;}#yiv0171256961 #yiv0171256961activity span:first-child {text-transform:uppercase;}#yiv0171256961 #yiv0171256961activity span a {color:#5085b6;text-decoration:none;}#yiv0171256961 #yiv0171256961activity span span {color:#ff7900;}#yiv0171256961 #yiv0171256961activity span .yiv0171256961underline {text-decoration:underline;}#yiv0171256961 .yiv0171256961attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0171256961 .yiv0171256961attach div a {text-decoration:none;}#yiv0171256961 .yiv0171256961attach img {border:none;padding-right:5px;}#yiv0171256961 .yiv0171256961attach label {display:block;margin-bottom:5px;}#yiv0171256961 .yiv0171256961attach label a {text-decoration:none;}#yiv0171256961 blockquote {margin:0 0 0 4px;}#yiv0171256961 .yiv0171256961bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0171256961 .yiv0171256961bold a {text-decoration:none;}#yiv0171256961 dd.yiv0171256961last p a {font-family:Verdana;font-weight:700;}#yiv0171256961 dd.yiv0171256961last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0171256961 dd.yiv0171256961last p span.yiv0171256961yshortcuts {margin-right:0;}#yiv0171256961 div.yiv0171256961attach-table div div a {text-decoration:none;}#yiv0171256961 div.yiv0171256961attach-table {width:400px;}#yiv0171256961 div.yiv0171256961file-title a, #yiv0171256961 div.yiv0171256961file-title a:active, #yiv0171256961 div.yiv0171256961file-title a:hover, #yiv0171256961 div.yiv0171256961file-title a:visited {text-decoration:none;}#yiv0171256961 div.yiv0171256961photo-title a, #yiv0171256961 div.yiv0171256961photo-title a:active, #yiv0171256961 div.yiv0171256961photo-title a:hover, #yiv0171256961 div.yiv0171256961photo-title a:visited {text-decoration:none;}#yiv0171256961 div#yiv0171256961ygrp-mlmsg #yiv0171256961ygrp-msg p a span.yiv0171256961yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0171256961 .yiv0171256961green {color:#628c2a;}#yiv0171256961 .yiv0171256961MsoNormal {margin:0 0 0 0;}#yiv0171256961 o {font-size:0;}#yiv0171256961 #yiv0171256961photos div {float:left;width:72px;}#yiv0171256961 #yiv0171256961photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0171256961 #yiv0171256961photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0171256961 #yiv0171256961reco-category {font-size:77%;}#yiv0171256961 #yiv0171256961reco-desc {font-size:77%;}#yiv0171256961 .yiv0171256961replbq {margin:4px;}#yiv0171256961 #yiv0171256961ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0171256961 #yiv0171256961ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0171256961 #yiv0171256961ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0171256961 #yiv0171256961ygrp-mlmsg select, #yiv0171256961 input, #yiv0171256961 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0171256961 #yiv0171256961ygrp-mlmsg pre, #yiv0171256961 code {font:115% monospace;}#yiv0171256961 #yiv0171256961ygrp-mlmsg * {line-height:1.22em;}#yiv0171256961 #yiv0171256961ygrp-mlmsg #yiv0171256961logo {padding-bottom:10px;}#yiv0171256961 #yiv0171256961ygrp-msg p a {font-family:Verdana;}#yiv0171256961 #yiv0171256961ygrp-msg p#yiv0171256961attach-count span {color:#1E66AE;font-weight:700;}#yiv0171256961 #yiv0171256961ygrp-reco #yiv0171256961reco-head {color:#ff7900;font-weight:700;}#yiv0171256961 #yiv0171256961ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0171256961 #yiv0171256961ygrp-sponsor #yiv0171256961ov li a {font-size:130%;text-decoration:none;}#yiv0171256961 #yiv0171256961ygrp-sponsor #yiv0171256961ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0171256961 #yiv0171256961ygrp-sponsor #yiv0171256961ov ul {margin:0;padding:0 0 0 8px;}#yiv0171256961 #yiv0171256961ygrp-text {font-family:Georgia;}#yiv0171256961 #yiv0171256961ygrp-text p {margin:0 0 1em 0;}#yiv0171256961 #yiv0171256961ygrp-text tt {font-size:120%;}#yiv0171256961 #yiv0171256961ygrp-vital ul li:last-child {border-right:none !important;}#yiv0171256961
Fri Apr 8, 2016 12:47 am (PDT) . Posted by:
GREEATT....
Hasil sudah pas dengan hati..
Thanks sobat..
Salam EXCEL-LENT..
Tidak ada komentar:
Posting Komentar