Bls: [belajar-excel] Look Up Nilai Yang Tidak Unik
alhamdulillahdone...makasih untuk semua solusi yang diberikan...sampe mau
loncat saking senengnysemoga jadi jalan kemudahan atas kesulitan bapak
ibu...aamiin
SalamSeismica
Pada Senin, 31 Juli 2017 14:20, "odong nando odongna...@yahoo.com
[belajar-excel]" menulis:
#yiv2546125445 #yiv2546125445 -- #yiv2546125445
.yiv2546125445ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv2546125445
div.yiv2546125445ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;min-height:62px;width:62px;}#yiv2546125445
div.yiv2546125445photo-title a, #yiv2546125445 div.yiv2546125445photo-title
a:active, #yiv2546125445 div.yiv2546125445photo-title a:hover, #yiv2546125445
div.yiv2546125445photo-title a:visited {text-decoration:none;}#yiv2546125445
div.yiv2546125445attach-table div.yiv2546125445attach-row
{clear:both;}#yiv2546125445 div.yiv2546125445attach-table
div.yiv2546125445attach-row div {float:left;}#yiv2546125445 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv2546125445
div.yiv2546125445ygrp-file {width:30px;}#yiv2546125445
div.yiv2546125445attach-table div.yiv2546125445attach-row div div a
{text-decoration:none;}#yiv2546125445 div.yiv2546125445attach-table
div.yiv2546125445attach-row div div span {font-weight:normal;}#yiv2546125445
div.yiv2546125445ygrp-file-title {font-weight:bold;}#yiv2546125445
#yiv2546125445
maaf ya lampiran ketinggalan... br,
odong nando
Dari: "odong nando odongna...@yahoo.com [belajar-excel]"
Kepada: "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]"
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
#yiv2546125445 -- #yiv2546125445ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2546125445
#yiv2546125445ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2546125445
#yiv2546125445ygrp-mkp #yiv2546125445hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2546125445 #yiv2546125445ygrp-mkp #yiv2546125445ads
{margin-bottom:10px;}#yiv2546125445 #yiv2546125445ygrp-mkp .yiv2546125445ad
{padding:0 0;}#yiv2546125445 #yiv2546125445ygrp-mkp .yiv2546125445ad p
{margin:0;}#yiv2546125445 #yiv2546125445ygrp-mkp .yiv2546125445ad a
{color:#ff;text-decoration:none;}#yiv2546125445 #yiv2546125445ygrp-sponsor
#yiv2546125445ygrp-lc {font-family:Arial;}#yiv2546125445
#yiv2546125445ygrp-sponsor #yiv2546125445ygrp-lc #yiv2546125445hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2546125445
#yiv2546125445ygrp-sponsor #yiv2546125445ygrp-lc .yiv2546125445ad
{margin-bottom:10px;padding:0 0;}#yiv2546125445 #yiv2546125445actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2546125445
#yiv2546125445activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2546125445
#yiv2546125445activity span {font-weight:700;}#yiv2546125445
#yiv2546125445activity span:first-child
{text-transform:uppercase;}#yiv2546125445 #yiv2546125445activity span a
{color:#5085b6;text-decoration:none;}#yiv2546125445 #yiv2546125445activity span
span {color:#ff7900;}#yiv2546125445 #yiv2546125445activity span
.yiv2546125445underline {text-decoration:underline;}#yiv2546125445
.yiv2546125445attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2546125445 .yiv2546125445attach div a
{text-decoration:none;}#yiv2546125445 .yiv2546125445attach img
{border:none;padding-right:5px;}#yiv2546125445 .yiv2546125445attach label
{display:block;margin-bottom:5px;}#yiv2546125445 .yiv2546125445attach label a
{text-decoration:none;}#yiv2546125445 blockquote {margin:0 0 0
4px;}#yiv2546125445 .yiv2546125445bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2546125445
.yiv2546125445bold a {text-decoration:none;}#yiv2546125445 dd.yiv2546125445last
p a {font-family:Verdana;font-weight:700;}#yiv2546125445 dd.yiv2546125445last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2546125445
dd.yiv2546125445last p span.yiv2546125445yshortcuts
{margin-right:0;}#yiv2546125445 div.yiv2546125445attach-table div div a
{text-decoration:none;}#yiv25461254
Bls: [belajar-excel] Look Up Nilai Yang Tidak Unik [1 Attachment]
maaf ya lampiran ketinggalan... br,
odong nando
Dari: "odong nando odongna...@yahoo.com [belajar-excel]"
Kepada: "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]"
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:#ff;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
#66;min-height:62px;overflow:hidden;width:62px;}#yiv6079590674
#yiv6079590674photos div label
{color:#66;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
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]"
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
#yiv4449008944 #yiv4449008944 -- #yiv4449008944ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4449008944
#yiv4449008944ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4449008944
#yiv4449008944ygrp-mkp #yiv4449008944hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4449008944 #yiv4449008944ygrp-mkp #yiv4449008944ads
{margin-bottom:10px;}#yiv4449008944 #yiv4449008944ygrp-mkp .yiv4449008944ad
{padding:0 0;}#yiv4449008944 #yiv4449008944ygrp-mkp .yiv4449008944ad p
{margin:0;}#yiv4449008944 #yiv4449008944ygrp-mkp .yiv4449008944ad a
{color:#ff;text-decoration:none;}#yiv4449008944 #yiv4449008944ygrp-sponsor
#yiv4449008944ygrp-lc {font-family:Arial;}#yiv4449008944
#yiv4449008944ygrp-sponsor #yiv4449008944ygrp-lc #yiv4449008944hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4449008944
#yiv4449008944ygrp-sponsor #yiv4449008944ygrp-lc .yiv4449008944ad
{margin-bottom:10px;padding:0 0;}#yiv4449008944 #yiv4449008944actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4449008944
#yiv4449008944activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4449008944
#yiv4449008944activity span {font-weight:700;}#yiv4449008944
#yiv4449008944activity span:first-child
{text-transform:uppercase;}#yiv4449008944 #yiv4449008944activity span a
{color:#5085b6;text-decoration:none;}#yiv4449008944 #yiv4449008944activity span
span {color:#ff7900;}#yiv4449008944 #yiv4449008944activity span
.yiv4449008944underline {text-decoration:underline;}#yiv4449008944
.yiv4449008944attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4449008944 .yiv4449008944attach div a
{text-decoration:none;}#yiv4449008944 .yiv4449008944attach img
{border:none;padding-right:5px;}#yiv4449008944 .yiv4449008944attach label
{display:block;margin-bottom:5px;}#yiv4449008944 .yiv4449008944attach label a
{text-decoration:none;}#yiv4449008944 blockquote {margin:0 0 0
4px;}#yiv4449008944 .yiv4449008944bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4449008944
.yiv4449008944bold a {text-decoration:none;}#yiv4449008944 dd.yiv4449008944last
p a {font-family:Verdana;font-weight:700;}#yiv4449008944 dd.yiv4449008944last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4449008944
dd.yiv4449008944last p span.yiv4449008944yshortcuts
{margin-right:0;}#yiv4449008944 div.yiv4449008944attach-table div div a
{text-decoration:none;}#yiv4449008944 div.yiv4449008944attach-table
{width:400px;}#yiv4449008944 div.yiv4449008944file-title a, #yiv4449008944
div.yiv4449008944file-title a:active, #yiv4449008944
div.yiv4449008944file-title a:hover, #yiv4449008944 div.yiv4449008944file-title
a:visited {text-decoration:none;}#yiv4449008944 div.yiv4449008944photo-title a,
#yiv4449008944 div.yiv4449008944photo-title a:active, #yiv4449008944
div.yiv4449008944photo-title a:hover, #yiv4449008944
div.yiv4449008944photo-title a:visited {text-decoration:none;}#yiv4449008944
div#yiv4449008944ygrp-mlmsg #yiv4449008944ygrp-msg p a
span.yiv4449008944yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4449008944
.yiv4449008944green {color:#628c2a;}#yiv4449008944 .yiv4449008944MsoNormal
{margin:0 0 0 0;}#yiv4449008944 o {font-size:0;}#yiv4449008944
#yiv4449008944photos div {float:left;width:72px;}#yiv4449008944
#yiv4449008944photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv4449008944
#yiv4449008944photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4449008944
#yiv4449008944reco-category {font-size:77%;}#yiv4449008944
#yiv4449008944reco-desc {font-size:77%;}#yiv4449008944 .yiv4449008944replbq
{margin:4px;}#yiv4449008944 #yiv4449008944ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4449008944 #yiv4449008944ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4449008944
#yiv4449008944ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4449008944
#yiv4449008944ygrp-mlmsg select, #yiv4449008944 input, #yiv4449008944 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4449008944
#yiv4449008944ygrp-mlmsg pre, #yi
