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

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
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 (12K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
Sambil menunggu jawaban Mr. Kid, sila coba UDF nya pak Anton (salah satu bang Momod juga).
Copas UDF di bawah ini pada module di VBE Sheet,
Function vlookupgab(x As Range, y As Range, z As String) As String
'anton suryadi 1/Des/2010 
For Each a In x
    If a.Text = y.Text Then
    b = b & a.Offset(, 1).Text & z
    End If
Next
vlookupgab = Left(b, Len(b) - 1) End Function

dan ketik UDF di bawah ini,

=vlookupgab($A$3:$A$9,D3,",") pada Range E3, kemudian copy ke bawah.

Salam,HK

On Sunday, July 30, 2017, 9:38:56 PM GMT+7, Zerlinda Seismica [hidden email] [belajar-excel] <[hidden email]> 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

 
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
Jangan lupa aktifkan Macronya.....

----- Forwarded Message -----From: hendrik karnadi [hidden email] [belajar-excel] <[hidden email]>To: Zerlinda Seismica [hidden email] [belajar-excel] <[hidden email]>Sent: Monday, July 31, 2017, 9:46:51 AM GMT+7Subject: Re: [belajar-excel] Look Up Nilai Yang Tidak Unik
   

Sambil menunggu jawaban Mr. Kid, sila coba UDF nya pak Anton (salah satu bang Momod juga).
Copas UDF di bawah ini pada module di VBE Sheet,
Function vlookupgab(x As Range, y As Range, z As String) As String
'anton suryadi 1/Des/2010 
For Each a In x
    If a.Text = y.Text Then
    b = b & a.Offset(, 1).Text & z
    End If
Next
vlookupgab = Left(b, Len(b) - 1) End Function

dan ketik UDF di bawah ini,

=vlookupgab($A$3:$A$9,D3,",") pada Range E3, kemudian copy ke bawah.

Salam,HK

On Sunday, July 30, 2017, 9:38:56 PM GMT+7, Zerlinda Seismica [hidden email] [belajar-excel] <[hidden email]> 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

   
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
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 [hidden email]
[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 (25K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Kalau mau direkalkulasi ulang secara otomatis setiap ada perubahan boleh ditambahkan Application.Volatile pada bagian awal code. Namun harus berhati-hati agar tidak tejadi "calculation lag", seperti catatan di bawah ini: 

This example marks the user-defined function "My_Func" as volatile. The function will be recalculated when any cell in any workbook in the application window changes value. Recalculation of the function is not restricted to changes or calculation cycles in the worksheet for which this function applies. Therefore, use it moderately to avoid calculation lag.
Function My_Func()
 Application.Volatile
 '
 ' Remainder of the function
 '
End FunctionSalam,HK

On Monday, July 31, 2017, 9:47:46 AM GMT+7, hendrik karnadi <[hidden email]> wrote:

Jangan lupa aktifkan Macronya.....

----- Forwarded Message -----From: hendrik karnadi [hidden email] [belajar-excel] <[hidden email]>To: Zerlinda Seismica [hidden email] [belajar-excel] <[hidden email]>Sent: Monday, July 31, 2017, 9:46:51 AM GMT+7Subject: Re: [belajar-excel] Look Up Nilai Yang Tidak Unik
   

Sambil menunggu jawaban Mr. Kid, sila coba UDF nya pak Anton (salah satu bang Momod juga).
Copas UDF di bawah ini pada module di VBE Sheet,
Function vlookupgab(x As Range, y As Range, z As String) As String
'anton suryadi 1/Des/2010 
For Each a In x
    If a.Text = y.Text Then
    b = b & a.Offset(, 1).Text & z
    End If
Next
vlookupgab = Left(b, Len(b) - 1) End Function

dan ketik UDF di bawah ini,

=vlookupgab($A$3:$A$9,D3,",") pada Range E3, kemudian copy ke bawah.

Salam,HK

On Sunday, July 30, 2017, 9:38:56 PM GMT+7, Zerlinda Seismica [hidden email] [belajar-excel] <[hidden email]> 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

   
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
hai seismica,
terlampir ya, dengan kolom bantu, bisa menampung ribuan deret  angka yang anda mau kelompokkan... br,

odong nando


      Dari: "Zerlinda Seismica [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
 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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4449008944 #yiv4449008944photos div label {color:#666666;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, #yiv4449008944 code {font:115% monospace;}#yiv4449008944 #yiv4449008944ygrp-mlmsg * {line-height:1.22em;}#yiv4449008944 #yiv4449008944ygrp-mlmsg #yiv4449008944logo {padding-bottom:10px;}#yiv4449008944 #yiv4449008944ygrp-msg p a {font-family:Verdana;}#yiv4449008944 #yiv4449008944ygrp-msg p#yiv4449008944attach-count span {color:#1E66AE;font-weight:700;}#yiv4449008944 #yiv4449008944ygrp-reco #yiv4449008944reco-head {color:#ff7900;font-weight:700;}#yiv4449008944 #yiv4449008944ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4449008944 #yiv4449008944ygrp-sponsor #yiv4449008944ov li a {font-size:130%;text-decoration:none;}#yiv4449008944 #yiv4449008944ygrp-sponsor #yiv4449008944ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4449008944 #yiv4449008944ygrp-sponsor #yiv4449008944ov ul {margin:0;padding:0 0 0 8px;}#yiv4449008944 #yiv4449008944ygrp-text {font-family:Georgia;}#yiv4449008944 #yiv4449008944ygrp-text p {margin:0 0 1em 0;}#yiv4449008944 #yiv4449008944ygrp-text tt {font-size:120%;}#yiv4449008944 #yiv4449008944ygrp-vital ul li:last-child {border-right:none !important;}#yiv4449008944

   
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
maaf ya lampiran ketinggalan... br,

odong nando


      Dari: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 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 [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
 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 (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Milis Belajar Excel mailing list
alhamdulillah....done...makasih untuk semua solusi yang diberikan...sampe mau loncat saking senengny....semoga jadi jalan kemudahan atas kesulitan bapak ibu...aamiin
SalamSeismica

    Pada Senin, 31 Juli 2017 14:20, "odong nando [hidden email] [belajar-excel]" <[hidden email]> 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 [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 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 [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
 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:#0000ff;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;}#yiv2546125445 div.yiv2546125445attach-table {width:400px;}#yiv2546125445 div.yiv2546125445file-title a, #yiv2546125445 div.yiv2546125445file-title a:active, #yiv2546125445 div.yiv2546125445file-title a:hover, #yiv2546125445 div.yiv2546125445file-title a:visited {text-decoration:none;}#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#yiv2546125445ygrp-mlmsg #yiv2546125445ygrp-msg p a span.yiv2546125445yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2546125445 .yiv2546125445green {color:#628c2a;}#yiv2546125445 .yiv2546125445MsoNormal {margin:0 0 0 0;}#yiv2546125445 o {font-size:0;}#yiv2546125445 #yiv2546125445photos div {float:left;width:72px;}#yiv2546125445 #yiv2546125445photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2546125445 #yiv2546125445photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2546125445 #yiv2546125445reco-category {font-size:77%;}#yiv2546125445 #yiv2546125445reco-desc {font-size:77%;}#yiv2546125445 .yiv2546125445replbq {margin:4px;}#yiv2546125445 #yiv2546125445ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2546125445 #yiv2546125445ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2546125445 #yiv2546125445ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2546125445 #yiv2546125445ygrp-mlmsg select, #yiv2546125445 input, #yiv2546125445 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2546125445 #yiv2546125445ygrp-mlmsg pre, #yiv2546125445 code {font:115% monospace;}#yiv2546125445 #yiv2546125445ygrp-mlmsg * {line-height:1.22em;}#yiv2546125445 #yiv2546125445ygrp-mlmsg #yiv2546125445logo {padding-bottom:10px;}#yiv2546125445 #yiv2546125445ygrp-msg p a {font-family:Verdana;}#yiv2546125445 #yiv2546125445ygrp-msg p#yiv2546125445attach-count span {color:#1E66AE;font-weight:700;}#yiv2546125445 #yiv2546125445ygrp-reco #yiv2546125445reco-head {color:#ff7900;font-weight:700;}#yiv2546125445 #yiv2546125445ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2546125445 #yiv2546125445ygrp-sponsor #yiv2546125445ov li a {font-size:130%;text-decoration:none;}#yiv2546125445 #yiv2546125445ygrp-sponsor #yiv2546125445ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2546125445 #yiv2546125445ygrp-sponsor #yiv2546125445ov ul {margin:0;padding:0 0 0 8px;}#yiv2546125445 #yiv2546125445ygrp-text {font-family:Georgia;}#yiv2546125445 #yiv2546125445ygrp-text p {margin:0 0 1em 0;}#yiv2546125445 #yiv2546125445ygrp-text tt {font-size:120%;}#yiv2546125445 #yiv2546125445ygrp-vital ul li:last-child {border-right:none !important;}#yiv2546125445







|  | Virus-free. www.avast.com  |

Loading...