Bls: [belajar-excel] Look Up Nilai Yang Tidak Unik [1 Attachment]

2017-07-30 Terurut Topik odong nando odongna...@yahoo.com [belajar-excel] 
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

Re: [belajar-excel] Look Up Nilai Yang Tidak Unik [1 Attachment]

2017-07-30 Terurut Topik nangagus nanga...@gmail.com [belajar-excel] 

Walaikumsalam warahmatullah.

Bisa juga pakai formula:
=IF(COUNTIF($A$3:$A$9;D3)>3;INDEX($B$1:$B$9;LARGE(INDEX(ROW($A$3:$A$9)*($A$3:$A$9=D3);;);4))&",";"")&IF(COUNTIF($A$3:$A$9;D3)>2;INDEX($B$1:$B$9;LARGE(INDEX(ROW($A$3:$A$9)*($A$3:$A$9=D3);;);3))&",";"")&IF(COUNTIF($A$3:$A$9;D3)>1;INDEX($B$1:$B$9;LARGE(INDEX(ROW($A$3:$A$9)*($A$3:$A$9=D3);;);2))&",";"")&INDEX($B$1:$B$9;LARGE(INDEX(ROW($A$3:$A$9)*($A$3:$A$9=D3);;);1))

Tapi sayang, Formula hanya untuk 4 data! jika lebih dari 4 data akan 
lebih panjang lagi


SAlam

NangAgus


On 7/30/2017 7:56 PM, Zerlinda Seismica seism...@yahoo.com 
[belajar-excel] wrote:

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






Nilai Yang Tidak Unik.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

[belajar-excel] Look Up Nilai Yang Tidak Unik [1 Attachment]

2017-07-30 Terurut Topik Zerlinda Seismica seism...@yahoo.com [belajar-excel] 
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



Look Up Nilai Yang Tidak Unik.xlsx
Description: MS-Excel 2007 spreadsheet