Jumat, 08 April 2016

[belajar-excel] Digest Number 3815

2 Messages

Digest #3815
1b
Re: GABUNGAN FUNGSI LEFT, MID DAN HLOOKUP (KEMUNGKINAN) by "Pukka Hamonangan Pardede" angan_lov3

Messages

Fri Apr 8, 2016 12:19 am (PDT) . Posted by:

"Slamet Prakoso" akhicilik



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:

"Pukka Hamonangan Pardede" angan_lov3

GREEATT....
Hasil sudah pas dengan hati..
Thanks sobat..

Salam EXCEL-LENT..

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar