Terimakasih banyak pencerahannya Mr.Ade
Pada Selasa, 9 Mei 2017 18:15, "'M.Ade Alfarid' q...@kkmi.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Mungkin dengan formula lookup . ade From: belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, May 9, 2017 3:52 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Formula (IF) Jika dengan Karakter Huruf dan Angka [1
Attachment] Assalamualaikum Wr. Wb.Para Master Bagaimana formula (IF) pada
kolom "D" jika criteria yang dibutuhkan adalah huruf pertama yang ada pada
kolom "B" Misal G11852 = 16.33 atau B0404213 = 13.06, bila diisi manual seperti
pada Kolom "C" dan bila dapat dengan formula (IF) maka pada kolom "D" sama
dengan kolom "C" dengan banyak data pada kolom "B" seperti data terlampir
TerimakasihWassalamualaikum Wr. Wb. Hairul Alam #yiv9802877519 #yiv9802877519
-- #yiv9802877519ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9802877519
#yiv9802877519ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9802877519
#yiv9802877519ygrp-mkp #yiv9802877519hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9802877519 #yiv9802877519ygrp-mkp #yiv9802877519ads
{margin-bottom:10px;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad
{padding:0 0;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad p
{margin:0;}#yiv9802877519 #yiv9802877519ygrp-mkp .yiv9802877519ad a
{color:#0000ff;text-decoration:none;}#yiv9802877519 #yiv9802877519ygrp-sponsor
#yiv9802877519ygrp-lc {font-family:Arial;}#yiv9802877519
#yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc #yiv9802877519hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9802877519
#yiv9802877519ygrp-sponsor #yiv9802877519ygrp-lc .yiv9802877519ad
{margin-bottom:10px;padding:0 0;}#yiv9802877519 #yiv9802877519actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9802877519
#yiv9802877519activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9802877519
#yiv9802877519activity span {font-weight:700;}#yiv9802877519
#yiv9802877519activity span:first-child
{text-transform:uppercase;}#yiv9802877519 #yiv9802877519activity span a
{color:#5085b6;text-decoration:none;}#yiv9802877519 #yiv9802877519activity span
span {color:#ff7900;}#yiv9802877519 #yiv9802877519activity span
.yiv9802877519underline {text-decoration:underline;}#yiv9802877519
.yiv9802877519attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9802877519 .yiv9802877519attach div a
{text-decoration:none;}#yiv9802877519 .yiv9802877519attach img
{border:none;padding-right:5px;}#yiv9802877519 .yiv9802877519attach label
{display:block;margin-bottom:5px;}#yiv9802877519 .yiv9802877519attach label a
{text-decoration:none;}#yiv9802877519 blockquote {margin:0 0 0
4px;}#yiv9802877519 .yiv9802877519bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9802877519
.yiv9802877519bold a {text-decoration:none;}#yiv9802877519 dd.yiv9802877519last
p a {font-family:Verdana;font-weight:700;}#yiv9802877519 dd.yiv9802877519last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9802877519
dd.yiv9802877519last p span.yiv9802877519yshortcuts
{margin-right:0;}#yiv9802877519 div.yiv9802877519attach-table div div a
{text-decoration:none;}#yiv9802877519 div.yiv9802877519attach-table
{width:400px;}#yiv9802877519 div.yiv9802877519file-title a, #yiv9802877519
div.yiv9802877519file-title a:active, #yiv9802877519
div.yiv9802877519file-title a:hover, #yiv9802877519 div.yiv9802877519file-title
a:visited {text-decoration:none;}#yiv9802877519 div.yiv9802877519photo-title a,
#yiv9802877519 div.yiv9802877519photo-title a:active, #yiv9802877519
div.yiv9802877519photo-title a:hover, #yiv9802877519
div.yiv9802877519photo-title a:visited {text-decoration:none;}#yiv9802877519
div#yiv9802877519ygrp-mlmsg #yiv9802877519ygrp-msg p a
span.yiv9802877519yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9802877519
.yiv9802877519green {color:#628c2a;}#yiv9802877519 .yiv9802877519MsoNormal
{margin:0 0 0 0;}#yiv9802877519 o {font-size:0;}#yiv9802877519
#yiv9802877519photos div {float:left;width:72px;}#yiv9802877519
#yiv9802877519photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9802877519
#yiv9802877519photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9802877519
#yiv9802877519reco-category {font-size:77%;}#yiv9802877519
#yiv9802877519reco-desc {font-size:77%;}#yiv9802877519 .yiv9802877519replbq
{margin:4px;}#yiv9802877519 #yiv9802877519ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9802877519 #yiv9802877519ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9802877519
#yiv9802877519ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9802877519
#yiv9802877519ygrp-mlmsg select, #yiv9802877519 input, #yiv9802877519 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9802877519
#yiv9802877519ygrp-mlmsg pre, #yiv9802877519 code {font:115%
monospace;}#yiv9802877519 #yiv9802877519ygrp-mlmsg *
{line-height:1.22em;}#yiv9802877519 #yiv9802877519ygrp-mlmsg #yiv9802877519logo
{padding-bottom:10px;}#yiv9802877519 #yiv9802877519ygrp-msg p a
{font-family:Verdana;}#yiv9802877519 #yiv9802877519ygrp-msg
p#yiv9802877519attach-count span {color:#1E66AE;font-weight:700;}#yiv9802877519
#yiv9802877519ygrp-reco #yiv9802877519reco-head
{color:#ff7900;font-weight:700;}#yiv9802877519 #yiv9802877519ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9802877519 #yiv9802877519ygrp-sponsor
#yiv9802877519ov li a {font-size:130%;text-decoration:none;}#yiv9802877519
#yiv9802877519ygrp-sponsor #yiv9802877519ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9802877519
#yiv9802877519ygrp-sponsor #yiv9802877519ov ul {margin:0;padding:0 0 0
8px;}#yiv9802877519 #yiv9802877519ygrp-text
{font-family:Georgia;}#yiv9802877519 #yiv9802877519ygrp-text p {margin:0 0 1em
0;}#yiv9802877519 #yiv9802877519ygrp-text tt {font-size:120%;}#yiv9802877519
#yiv9802877519ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9802877519
