Dear Mr. Kid
Terima kasih atas bantuannya, Saya akan coba pelajari.
Wassalam
Rudhie
Pada Jumat, 14 Oktober 2016 12:51, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Rudhie,
Formula lookup picture ya. Coba file yang ada disini.
Regards,
Kid
2016-10-14 8:55 GMT+07:00 Rudhie [email protected] [belajar-excel]
<[email protected]>:
Dear Be Exceller
Selamat Pagi
Saya ingin menanyakan "Bagaimanakah cara di excel untuk menampilkan picture
tanpa menggunakan VBA / macro ?
tetapi dibuat dengan menggunakan formula dan define picture ?".
Sebelumnya saya sudah mencoba file yang pernah di download di milis ini, tetapi
file di protect dan tidak ada cara
atau penjelasan langkah-langkahnya. Saya sudah mencoba, tetapi kurang paham
langkah-langkahnya.
Mohon kiranya Be Exceller dapat memberikan pencerahannya beserta contoh file
yang mudah dan dapat dijelaskan
langkah-langkahnya satu per-satu.
Terima Kasih
Rudhie
#yiv2970118883 #yiv2970118883 -- #yiv2970118883ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2970118883
#yiv2970118883ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2970118883
#yiv2970118883ygrp-mkp #yiv2970118883hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2970118883 #yiv2970118883ygrp-mkp #yiv2970118883ads
{margin-bottom:10px;}#yiv2970118883 #yiv2970118883ygrp-mkp .yiv2970118883ad
{padding:0 0;}#yiv2970118883 #yiv2970118883ygrp-mkp .yiv2970118883ad p
{margin:0;}#yiv2970118883 #yiv2970118883ygrp-mkp .yiv2970118883ad a
{color:#0000ff;text-decoration:none;}#yiv2970118883 #yiv2970118883ygrp-sponsor
#yiv2970118883ygrp-lc {font-family:Arial;}#yiv2970118883
#yiv2970118883ygrp-sponsor #yiv2970118883ygrp-lc #yiv2970118883hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2970118883
#yiv2970118883ygrp-sponsor #yiv2970118883ygrp-lc .yiv2970118883ad
{margin-bottom:10px;padding:0 0;}#yiv2970118883 #yiv2970118883actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2970118883
#yiv2970118883activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2970118883
#yiv2970118883activity span {font-weight:700;}#yiv2970118883
#yiv2970118883activity span:first-child
{text-transform:uppercase;}#yiv2970118883 #yiv2970118883activity span a
{color:#5085b6;text-decoration:none;}#yiv2970118883 #yiv2970118883activity span
span {color:#ff7900;}#yiv2970118883 #yiv2970118883activity span
.yiv2970118883underline {text-decoration:underline;}#yiv2970118883
.yiv2970118883attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2970118883 .yiv2970118883attach div a
{text-decoration:none;}#yiv2970118883 .yiv2970118883attach img
{border:none;padding-right:5px;}#yiv2970118883 .yiv2970118883attach label
{display:block;margin-bottom:5px;}#yiv2970118883 .yiv2970118883attach label a
{text-decoration:none;}#yiv2970118883 blockquote {margin:0 0 0
4px;}#yiv2970118883 .yiv2970118883bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2970118883
.yiv2970118883bold a {text-decoration:none;}#yiv2970118883 dd.yiv2970118883last
p a {font-family:Verdana;font-weight:700;}#yiv2970118883 dd.yiv2970118883last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2970118883
dd.yiv2970118883last p span.yiv2970118883yshortcuts
{margin-right:0;}#yiv2970118883 div.yiv2970118883attach-table div div a
{text-decoration:none;}#yiv2970118883 div.yiv2970118883attach-table
{width:400px;}#yiv2970118883 div.yiv2970118883file-title a, #yiv2970118883
div.yiv2970118883file-title a:active, #yiv2970118883
div.yiv2970118883file-title a:hover, #yiv2970118883 div.yiv2970118883file-title
a:visited {text-decoration:none;}#yiv2970118883 div.yiv2970118883photo-title a,
#yiv2970118883 div.yiv2970118883photo-title a:active, #yiv2970118883
div.yiv2970118883photo-title a:hover, #yiv2970118883
div.yiv2970118883photo-title a:visited {text-decoration:none;}#yiv2970118883
div#yiv2970118883ygrp-mlmsg #yiv2970118883ygrp-msg p a
span.yiv2970118883yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2970118883
.yiv2970118883green {color:#628c2a;}#yiv2970118883 .yiv2970118883MsoNormal
{margin:0 0 0 0;}#yiv2970118883 o {font-size:0;}#yiv2970118883
#yiv2970118883photos div {float:left;width:72px;}#yiv2970118883
#yiv2970118883photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2970118883
#yiv2970118883photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2970118883
#yiv2970118883reco-category {font-size:77%;}#yiv2970118883
#yiv2970118883reco-desc {font-size:77%;}#yiv2970118883 .yiv2970118883replbq
{margin:4px;}#yiv2970118883 #yiv2970118883ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2970118883 #yiv2970118883ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2970118883
#yiv2970118883ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2970118883
#yiv2970118883ygrp-mlmsg select, #yiv2970118883 input, #yiv2970118883 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2970118883
#yiv2970118883ygrp-mlmsg pre, #yiv2970118883 code {font:115%
monospace;}#yiv2970118883 #yiv2970118883ygrp-mlmsg *
{line-height:1.22em;}#yiv2970118883 #yiv2970118883ygrp-mlmsg #yiv2970118883logo
{padding-bottom:10px;}#yiv2970118883 #yiv2970118883ygrp-msg p a
{font-family:Verdana;}#yiv2970118883 #yiv2970118883ygrp-msg
p#yiv2970118883attach-count span {color:#1E66AE;font-weight:700;}#yiv2970118883
#yiv2970118883ygrp-reco #yiv2970118883reco-head
{color:#ff7900;font-weight:700;}#yiv2970118883 #yiv2970118883ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2970118883 #yiv2970118883ygrp-sponsor
#yiv2970118883ov li a {font-size:130%;text-decoration:none;}#yiv2970118883
#yiv2970118883ygrp-sponsor #yiv2970118883ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2970118883
#yiv2970118883ygrp-sponsor #yiv2970118883ov ul {margin:0;padding:0 0 0
8px;}#yiv2970118883 #yiv2970118883ygrp-text
{font-family:Georgia;}#yiv2970118883 #yiv2970118883ygrp-text p {margin:0 0 1em
0;}#yiv2970118883 #yiv2970118883ygrp-text tt {font-size:120%;}#yiv2970118883
#yiv2970118883ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2970118883
