maaf ya lampiran ketinggalan... br, odong nando
Dari: "odong nando odongna...@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Dikirim: Senin, 31 Juli 2017 12:11
Judul: Bls: [belajar-excel] Look Up Nilai Yang Tidak Unik
hai seismica,
terlampir ya, dengan kolom bantu, bisa menampung ribuan deret angka yang anda
mau kelompokkan... br,
odong nando
Dari: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Minggu, 30 Juli 2017 21:38
Judul: [belajar-excel] Look Up Nilai Yang Tidak Unik [1 Attachment]
Assalamualaikum wrwb
Bapak dan ibu wabil khusus Mr Kid hehe...menurut asumsi saya fungsi look hanya
untuk cari data yang unik.Sementara cari data yang ga unik apa ada sintaknya
ya...Seperti biasa akan lebih jelas kalau bapak ibu bisa cek dulu lampiran
saya...
Salam hormat buat bapak ibu
Wassalam
Seismica
#yiv6079590674 #yiv6079590674 -- #yiv6079590674ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6079590674
#yiv6079590674ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6079590674
#yiv6079590674ygrp-mkp #yiv6079590674hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6079590674 #yiv6079590674ygrp-mkp #yiv6079590674ads
{margin-bottom:10px;}#yiv6079590674 #yiv6079590674ygrp-mkp .yiv6079590674ad
{padding:0 0;}#yiv6079590674 #yiv6079590674ygrp-mkp .yiv6079590674ad p
{margin:0;}#yiv6079590674 #yiv6079590674ygrp-mkp .yiv6079590674ad a
{color:#0000ff;text-decoration:none;}#yiv6079590674 #yiv6079590674ygrp-sponsor
#yiv6079590674ygrp-lc {font-family:Arial;}#yiv6079590674
#yiv6079590674ygrp-sponsor #yiv6079590674ygrp-lc #yiv6079590674hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6079590674
#yiv6079590674ygrp-sponsor #yiv6079590674ygrp-lc .yiv6079590674ad
{margin-bottom:10px;padding:0 0;}#yiv6079590674 #yiv6079590674actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6079590674
#yiv6079590674activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6079590674
#yiv6079590674activity span {font-weight:700;}#yiv6079590674
#yiv6079590674activity span:first-child
{text-transform:uppercase;}#yiv6079590674 #yiv6079590674activity span a
{color:#5085b6;text-decoration:none;}#yiv6079590674 #yiv6079590674activity span
span {color:#ff7900;}#yiv6079590674 #yiv6079590674activity span
.yiv6079590674underline {text-decoration:underline;}#yiv6079590674
.yiv6079590674attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6079590674 .yiv6079590674attach div a
{text-decoration:none;}#yiv6079590674 .yiv6079590674attach img
{border:none;padding-right:5px;}#yiv6079590674 .yiv6079590674attach label
{display:block;margin-bottom:5px;}#yiv6079590674 .yiv6079590674attach label a
{text-decoration:none;}#yiv6079590674 blockquote {margin:0 0 0
4px;}#yiv6079590674 .yiv6079590674bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6079590674
.yiv6079590674bold a {text-decoration:none;}#yiv6079590674 dd.yiv6079590674last
p a {font-family:Verdana;font-weight:700;}#yiv6079590674 dd.yiv6079590674last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6079590674
dd.yiv6079590674last p span.yiv6079590674yshortcuts
{margin-right:0;}#yiv6079590674 div.yiv6079590674attach-table div div a
{text-decoration:none;}#yiv6079590674 div.yiv6079590674attach-table
{width:400px;}#yiv6079590674 div.yiv6079590674file-title a, #yiv6079590674
div.yiv6079590674file-title a:active, #yiv6079590674
div.yiv6079590674file-title a:hover, #yiv6079590674 div.yiv6079590674file-title
a:visited {text-decoration:none;}#yiv6079590674 div.yiv6079590674photo-title a,
#yiv6079590674 div.yiv6079590674photo-title a:active, #yiv6079590674
div.yiv6079590674photo-title a:hover, #yiv6079590674
div.yiv6079590674photo-title a:visited {text-decoration:none;}#yiv6079590674
div#yiv6079590674ygrp-mlmsg #yiv6079590674ygrp-msg p a
span.yiv6079590674yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6079590674
.yiv6079590674green {color:#628c2a;}#yiv6079590674 .yiv6079590674MsoNormal
{margin:0 0 0 0;}#yiv6079590674 o {font-size:0;}#yiv6079590674
#yiv6079590674photos div {float:left;width:72px;}#yiv6079590674
#yiv6079590674photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6079590674
#yiv6079590674photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6079590674
#yiv6079590674reco-category {font-size:77%;}#yiv6079590674
#yiv6079590674reco-desc {font-size:77%;}#yiv6079590674 .yiv6079590674replbq
{margin:4px;}#yiv6079590674 #yiv6079590674ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6079590674 #yiv6079590674ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6079590674
#yiv6079590674ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6079590674
#yiv6079590674ygrp-mlmsg select, #yiv6079590674 input, #yiv6079590674 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6079590674
#yiv6079590674ygrp-mlmsg pre, #yiv6079590674 code {font:115%
monospace;}#yiv6079590674 #yiv6079590674ygrp-mlmsg *
{line-height:1.22em;}#yiv6079590674 #yiv6079590674ygrp-mlmsg #yiv6079590674logo
{padding-bottom:10px;}#yiv6079590674 #yiv6079590674ygrp-msg p a
{font-family:Verdana;}#yiv6079590674 #yiv6079590674ygrp-msg
p#yiv6079590674attach-count span {color:#1E66AE;font-weight:700;}#yiv6079590674
#yiv6079590674ygrp-reco #yiv6079590674reco-head
{color:#ff7900;font-weight:700;}#yiv6079590674 #yiv6079590674ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6079590674 #yiv6079590674ygrp-sponsor
#yiv6079590674ov li a {font-size:130%;text-decoration:none;}#yiv6079590674
#yiv6079590674ygrp-sponsor #yiv6079590674ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6079590674
#yiv6079590674ygrp-sponsor #yiv6079590674ov ul {margin:0;padding:0 0 0
8px;}#yiv6079590674 #yiv6079590674ygrp-text
{font-family:Georgia;}#yiv6079590674 #yiv6079590674ygrp-text p {margin:0 0 1em
0;}#yiv6079590674 #yiv6079590674ygrp-text tt {font-size:120%;}#yiv6079590674
#yiv6079590674ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6079590674
Look Up Nilai Yang Tidak Unik_OD.xlsx
Description: MS-Excel 2007 spreadsheet
