[belajar-excel] Filter dalam Tabel [1 Attachment]

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

[belajar-excel] Filter dalam Tabel [1 Attachment]

Milis Belajar Excel mailing list
Dear pada suhu2 Excel.

mohon bantuanya terkait permasalahan yg saya hadapi.

maaf sekiranya sudah pernah dibahas sebelumnya.

atas bantuan para suhu saya sangat berterima kasih.

Salam

Urut Otomatis.xlsx (30K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Filter dalam Tabel [1 Attachment]

Milis Belajar Excel mailing list
nyoba setengah jawab .. yang filter jatuh tempo belum .. hehehe ..


    On Wednesday, June 7, 2017 3:30 PM, "'Roy@ld' [hidden email] [belajar-excel]" <[hidden email]> wrote:



     Dear pada suhu2 Excel.


mohon bantuanya terkait permasalahan yg saya hadapi.


maaf sekiranya sudah pernah dibahas sebelumnya.


atas bantuan para suhu saya sangat berterima kasih.


Salam
  #yiv8342339659 #yiv8342339659 -- #yiv8342339659ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8342339659 #yiv8342339659ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8342339659 #yiv8342339659ygrp-mkp #yiv8342339659hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8342339659 #yiv8342339659ygrp-mkp #yiv8342339659ads {margin-bottom:10px;}#yiv8342339659 #yiv8342339659ygrp-mkp .yiv8342339659ad {padding:0 0;}#yiv8342339659 #yiv8342339659ygrp-mkp .yiv8342339659ad p {margin:0;}#yiv8342339659 #yiv8342339659ygrp-mkp .yiv8342339659ad a {color:#0000ff;text-decoration:none;}#yiv8342339659 #yiv8342339659ygrp-sponsor #yiv8342339659ygrp-lc {font-family:Arial;}#yiv8342339659 #yiv8342339659ygrp-sponsor #yiv8342339659ygrp-lc #yiv8342339659hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8342339659 #yiv8342339659ygrp-sponsor #yiv8342339659ygrp-lc .yiv8342339659ad {margin-bottom:10px;padding:0 0;}#yiv8342339659 #yiv8342339659actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8342339659 #yiv8342339659activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8342339659 #yiv8342339659activity span {font-weight:700;}#yiv8342339659 #yiv8342339659activity span:first-child {text-transform:uppercase;}#yiv8342339659 #yiv8342339659activity span a {color:#5085b6;text-decoration:none;}#yiv8342339659 #yiv8342339659activity span span {color:#ff7900;}#yiv8342339659 #yiv8342339659activity span .yiv8342339659underline {text-decoration:underline;}#yiv8342339659 .yiv8342339659attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8342339659 .yiv8342339659attach div a {text-decoration:none;}#yiv8342339659 .yiv8342339659attach img {border:none;padding-right:5px;}#yiv8342339659 .yiv8342339659attach label {display:block;margin-bottom:5px;}#yiv8342339659 .yiv8342339659attach label a {text-decoration:none;}#yiv8342339659 blockquote {margin:0 0 0 4px;}#yiv8342339659 .yiv8342339659bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8342339659 .yiv8342339659bold a {text-decoration:none;}#yiv8342339659 dd.yiv8342339659last p a {font-family:Verdana;font-weight:700;}#yiv8342339659 dd.yiv8342339659last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8342339659 dd.yiv8342339659last p span.yiv8342339659yshortcuts {margin-right:0;}#yiv8342339659 div.yiv8342339659attach-table div div a {text-decoration:none;}#yiv8342339659 div.yiv8342339659attach-table {width:400px;}#yiv8342339659 div.yiv8342339659file-title a, #yiv8342339659 div.yiv8342339659file-title a:active, #yiv8342339659 div.yiv8342339659file-title a:hover, #yiv8342339659 div.yiv8342339659file-title a:visited {text-decoration:none;}#yiv8342339659 div.yiv8342339659photo-title a, #yiv8342339659 div.yiv8342339659photo-title a:active, #yiv8342339659 div.yiv8342339659photo-title a:hover, #yiv8342339659 div.yiv8342339659photo-title a:visited {text-decoration:none;}#yiv8342339659 div#yiv8342339659ygrp-mlmsg #yiv8342339659ygrp-msg p a span.yiv8342339659yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8342339659 .yiv8342339659green {color:#628c2a;}#yiv8342339659 .yiv8342339659MsoNormal {margin:0 0 0 0;}#yiv8342339659 o {font-size:0;}#yiv8342339659 #yiv8342339659photos div {float:left;width:72px;}#yiv8342339659 #yiv8342339659photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8342339659 #yiv8342339659photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8342339659 #yiv8342339659reco-category {font-size:77%;}#yiv8342339659 #yiv8342339659reco-desc {font-size:77%;}#yiv8342339659 .yiv8342339659replbq {margin:4px;}#yiv8342339659 #yiv8342339659ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8342339659 #yiv8342339659ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8342339659 #yiv8342339659ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8342339659 #yiv8342339659ygrp-mlmsg select, #yiv8342339659 input, #yiv8342339659 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8342339659 #yiv8342339659ygrp-mlmsg pre, #yiv8342339659 code {font:115% monospace;}#yiv8342339659 #yiv8342339659ygrp-mlmsg * {line-height:1.22em;}#yiv8342339659 #yiv8342339659ygrp-mlmsg #yiv8342339659logo {padding-bottom:10px;}#yiv8342339659 #yiv8342339659ygrp-msg p a {font-family:Verdana;}#yiv8342339659 #yiv8342339659ygrp-msg p#yiv8342339659attach-count span {color:#1E66AE;font-weight:700;}#yiv8342339659 #yiv8342339659ygrp-reco #yiv8342339659reco-head {color:#ff7900;font-weight:700;}#yiv8342339659 #yiv8342339659ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8342339659 #yiv8342339659ygrp-sponsor #yiv8342339659ov li a {font-size:130%;text-decoration:none;}#yiv8342339659 #yiv8342339659ygrp-sponsor #yiv8342339659ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8342339659 #yiv8342339659ygrp-sponsor #yiv8342339659ov ul {margin:0;padding:0 0 0 8px;}#yiv8342339659 #yiv8342339659ygrp-text {font-family:Georgia;}#yiv8342339659 #yiv8342339659ygrp-text p {margin:0 0 1em 0;}#yiv8342339659 #yiv8342339659ygrp-text tt {font-size:120%;}#yiv8342339659 #yiv8342339659ygrp-vital ul li:last-child {border-right:none !important;}#yiv8342339659


 

re - Urut Otomatis.xlsx (46K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Filter dalam Tabel

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Hai Roy,Untuk memfilter database tersebut perlu dibuatkan kolom kolom bantu sesuai kriteria yang dibutuhkan.Jika diinginkan judul di bagian atas maka Filter dapat dilakukan dengan PivotTable, namun jika tidak diperlukan judul di bagian atas dapat dilakukan dengan Advance Filter.
Keduanya dapat dilakukan secara manual atau dengan macro.
Silakan dicoba dulu.

Salam,HK
      From: "'Roy@ld' [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 Sent: Wednesday, 7 June 2017, 15:30
 Subject: [belajar-excel] Filter dalam Tabel [1 Attachment]
   
    Dear pada suhu2 Excel.

mohon bantuanya terkait permasalahan yg saya hadapi.

maaf sekiranya sudah pernah dibahas sebelumnya.

atas bantuan para suhu saya sangat berterima kasih.

Salam
  #yiv2854279910 #yiv2854279910 -- #yiv2854279910ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2854279910 #yiv2854279910ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2854279910 #yiv2854279910ygrp-mkp #yiv2854279910hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2854279910 #yiv2854279910ygrp-mkp #yiv2854279910ads {margin-bottom:10px;}#yiv2854279910 #yiv2854279910ygrp-mkp .yiv2854279910ad {padding:0 0;}#yiv2854279910 #yiv2854279910ygrp-mkp .yiv2854279910ad p {margin:0;}#yiv2854279910 #yiv2854279910ygrp-mkp .yiv2854279910ad a {color:#0000ff;text-decoration:none;}#yiv2854279910 #yiv2854279910ygrp-sponsor #yiv2854279910ygrp-lc {font-family:Arial;}#yiv2854279910 #yiv2854279910ygrp-sponsor #yiv2854279910ygrp-lc #yiv2854279910hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2854279910 #yiv2854279910ygrp-sponsor #yiv2854279910ygrp-lc .yiv2854279910ad {margin-bottom:10px;padding:0 0;}#yiv2854279910 #yiv2854279910actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2854279910 #yiv2854279910activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2854279910 #yiv2854279910activity span {font-weight:700;}#yiv2854279910 #yiv2854279910activity span:first-child {text-transform:uppercase;}#yiv2854279910 #yiv2854279910activity span a {color:#5085b6;text-decoration:none;}#yiv2854279910 #yiv2854279910activity span span {color:#ff7900;}#yiv2854279910 #yiv2854279910activity span .yiv2854279910underline {text-decoration:underline;}#yiv2854279910 .yiv2854279910attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2854279910 .yiv2854279910attach div a {text-decoration:none;}#yiv2854279910 .yiv2854279910attach img {border:none;padding-right:5px;}#yiv2854279910 .yiv2854279910attach label {display:block;margin-bottom:5px;}#yiv2854279910 .yiv2854279910attach label a {text-decoration:none;}#yiv2854279910 blockquote {margin:0 0 0 4px;}#yiv2854279910 .yiv2854279910bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2854279910 .yiv2854279910bold a {text-decoration:none;}#yiv2854279910 dd.yiv2854279910last p a {font-family:Verdana;font-weight:700;}#yiv2854279910 dd.yiv2854279910last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2854279910 dd.yiv2854279910last p span.yiv2854279910yshortcuts {margin-right:0;}#yiv2854279910 div.yiv2854279910attach-table div div a {text-decoration:none;}#yiv2854279910 div.yiv2854279910attach-table {width:400px;}#yiv2854279910 div.yiv2854279910file-title a, #yiv2854279910 div.yiv2854279910file-title a:active, #yiv2854279910 div.yiv2854279910file-title a:hover, #yiv2854279910 div.yiv2854279910file-title a:visited {text-decoration:none;}#yiv2854279910 div.yiv2854279910photo-title a, #yiv2854279910 div.yiv2854279910photo-title a:active, #yiv2854279910 div.yiv2854279910photo-title a:hover, #yiv2854279910 div.yiv2854279910photo-title a:visited {text-decoration:none;}#yiv2854279910 div#yiv2854279910ygrp-mlmsg #yiv2854279910ygrp-msg p a span.yiv2854279910yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2854279910 .yiv2854279910green {color:#628c2a;}#yiv2854279910 .yiv2854279910MsoNormal {margin:0 0 0 0;}#yiv2854279910 o {font-size:0;}#yiv2854279910 #yiv2854279910photos div {float:left;width:72px;}#yiv2854279910 #yiv2854279910photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2854279910 #yiv2854279910photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2854279910 #yiv2854279910reco-category {font-size:77%;}#yiv2854279910 #yiv2854279910reco-desc {font-size:77%;}#yiv2854279910 .yiv2854279910replbq {margin:4px;}#yiv2854279910 #yiv2854279910ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2854279910 #yiv2854279910ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2854279910 #yiv2854279910ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2854279910 #yiv2854279910ygrp-mlmsg select, #yiv2854279910 input, #yiv2854279910 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2854279910 #yiv2854279910ygrp-mlmsg pre, #yiv2854279910 code {font:115% monospace;}#yiv2854279910 #yiv2854279910ygrp-mlmsg * {line-height:1.22em;}#yiv2854279910 #yiv2854279910ygrp-mlmsg #yiv2854279910logo {padding-bottom:10px;}#yiv2854279910 #yiv2854279910ygrp-msg p a {font-family:Verdana;}#yiv2854279910 #yiv2854279910ygrp-msg p#yiv2854279910attach-count span {color:#1E66AE;font-weight:700;}#yiv2854279910 #yiv2854279910ygrp-reco #yiv2854279910reco-head {color:#ff7900;font-weight:700;}#yiv2854279910 #yiv2854279910ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2854279910 #yiv2854279910ygrp-sponsor #yiv2854279910ov li a {font-size:130%;text-decoration:none;}#yiv2854279910 #yiv2854279910ygrp-sponsor #yiv2854279910ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2854279910 #yiv2854279910ygrp-sponsor #yiv2854279910ov ul {margin:0;padding:0 0 0 8px;}#yiv2854279910 #yiv2854279910ygrp-text {font-family:Georgia;}#yiv2854279910 #yiv2854279910ygrp-text p {margin:0 0 1em 0;}#yiv2854279910 #yiv2854279910ygrp-text tt {font-size:120%;}#yiv2854279910 #yiv2854279910ygrp-vital ul li:last-child {border-right:none !important;}#yiv2854279910

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

Re: [belajar-excel] Filter dalam Tabel

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Hai Roy,

Maaf nih, bisa dijelaskan lebih detil kasusnya kah ?
Kalau bulan ini adalah Juni 2017, lalu Bulan Tahun diisi Feb 2019, lalu
opsi dipilih Jatuh tempo bulan ini, sedangkan data tanggal hanya ada kolom
tanggal jatuh tempo, maka outputnya itu record yang mana ?

Regards,
Kid








2017-06-07 15:30 GMT+07:00 'Roy@ld' [hidden email] [belajar-excel] <
[hidden email]>:

>
>
> Dear pada suhu2 Excel.
>
> mohon bantuanya terkait permasalahan yg saya hadapi.
>
> maaf sekiranya sudah pernah dibahas sebelumnya.
>
> atas bantuan para suhu saya sangat berterima kasih.
>
> Salam
>
>
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Filter dalam Tabel [1 Attachment]

Milis Belajar Excel mailing list
File terlampir adalah contoh.

Regards,
Kid


2017-06-08 5:38 GMT+07:00 'Mr. Kid' [hidden email] [belajar-excel] <
[hidden email]>:

>
>
> Hai Roy,
>
> Maaf nih, bisa dijelaskan lebih detil kasusnya kah ?
> Kalau bulan ini adalah Juni 2017, lalu Bulan Tahun diisi Feb 2019, lalu
> opsi dipilih Jatuh tempo bulan ini, sedangkan data tanggal hanya ada kolom
> tanggal jatuh tempo, maka outputnya itu record yang mana ?
>
> Regards,
> Kid
>
>
>
>
>
>
>
>
> 2017-06-07 15:30 GMT+07:00 'Roy@ld' [hidden email] [belajar-excel] <
> [hidden email]>:
>
>>
>>
>> Dear pada suhu2 Excel.
>>
>> mohon bantuanya terkait permasalahan yg saya hadapi.
>>
>> maaf sekiranya sudah pernah dibahas sebelumnya.
>>
>> atas bantuan para suhu saya sangat berterima kasih.
>>
>> Salam
>>
>>
>
>

re-Urut Otomatis.xlsx (37K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Filter dalam Tabel

Milis Belajar Excel mailing list
terima kasih banyak atas bantuannya.

Tuhan memberkati.

2017-06-09 11:14 GMT+08:00 'Mr. Kid' [hidden email] [belajar-excel] <
[hidden email]>:

>
>
> File terlampir adalah contoh.
>
> Regards,
> Kid
>
>
> 2017-06-08 5:38 GMT+07:00 'Mr. Kid' [hidden email] [belajar-excel] <
> [hidden email]>:
>
>>
>>
>> Hai Roy,
>>
>> Maaf nih, bisa dijelaskan lebih detil kasusnya kah ?
>> Kalau bulan ini adalah Juni 2017, lalu Bulan Tahun diisi Feb 2019, lalu
>> opsi dipilih Jatuh tempo bulan ini, sedangkan data tanggal hanya ada kolom
>> tanggal jatuh tempo, maka outputnya itu record yang mana ?
>>
>> Regards,
>> Kid
>>
>>
>>
>>
>>
>>
>>
>>
>> 2017-06-07 15:30 GMT+07:00 'Roy@ld' [hidden email] [belajar-excel] <
>> [hidden email]>:
>>
>>>
>>>
>>> Dear pada suhu2 Excel.
>>>
>>> mohon bantuanya terkait permasalahan yg saya hadapi.
>>>
>>> maaf sekiranya sudah pernah dibahas sebelumnya.
>>>
>>> atas bantuan para suhu saya sangat berterima kasih.
>>>
>>> Salam
>>>
>>>
>>
>
>
Loading...