[belajar-excel] Tanya : Filter Data (<= dan >=) [1 Attachment]

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Tanya : Filter Data (<= dan >=) [1 Attachment]

Milis Belajar Excel mailing list



&lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.01//EN&quot; &quot;http://www.w3.org/TR/html4/strict.dtd&quot;&gt;









 

&nbsp;



 


   
     
     
       Dear All Suhu Excel yg saya hormati, Saya punya permasalahan nih, saya ingin mendapatkan hasil ‎ filter data sesuai pada lampiran... Tolong solusi formulanya ya... Makasih suhu2..^_^ Sent from my BlackBerry 10 smartphone on the XL network.

   
     

   
    __._,_.___

            View attachments on the web
 
     

   
       
        Posted by: [hidden email]        
     
     

   
     
       
         
                          Reply via web post
                     
          &bull;
         
           
               Reply to sender            
         
          &bull;
         
           
              Reply to group            
         
          &bull;
         
            Start a New Topic
         
          &bull;
         
                            Messages in this topic
                (1)
                     
       
     
   

       

           
       
             
       
           
           
                Have you tried the highest rated email app?
                With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
           
       
             
     
   







   
     


      ============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html 
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: [hidden email]
posting ke milis, kirimkan ke: [hidden email]
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages 
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@.../ 
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ 
menghubungi moderators &amp; owners: [hidden email]
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : [hidden email]
---------------------------------------------------------------------      


   
 

 




    Visit Your Group

     
           
      New Members
      1
   
                                             
 



 
   &bull; Privacy  &bull; Unsubscribe  &bull; Terms of Use  





   

 
 
 
 



     




     

  .


   

 

__,_._,___






 







Tanya Filter Data.xlsx (21K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Tanya : Filter Data (<= dan >=) [1 Attachment]

Milis Belajar Excel mailing list
Halo Orie,

Sambil tunggu masukan dari suhu disini. File terlampir menggunakan Vlookup,
Approximate Match.
Maaf kalau belum sesuai ya ?

Salam
Sony


*gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*

On Mon, Apr 3, 2017 at 9:47 PM, [hidden email] [belajar-excel] <
[hidden email]> wrote:

>
>
> Dear All Suhu Excel yg saya hormati,
>
> Saya punya permasalahan nih, saya ingin mendapatkan hasil ‎ filter data
> sesuai pada lampiran...
>
> Tolong solusi formulanya ya...
> Makasih suhu2..^_^
>
>
> Sent from my BlackBerry 10 smartphone on the XL network.
>
>
>

Tanya Filter Data_rev1.xlsx (22K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Tanya : Filter Data (<= dan >=)

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Dear Arie,




Coba gunakan formula : VLOOKUP(F3;A$1:D$100;4;TRUE)




Rgd's
Mbul




On 03/04/17 21:47, [hidden email] [belajar-excel] wrote:

>
> Dear All Suhu Excel yg saya hormati,
>
> Saya punya permasalahan nih, saya ingin mendapatkan hasil ‎ filter
> data sesuai pada lampiran...
>
> Tolong solusi formulanya ya...
> Makasih suhu2..^_^
>
>
> Sent from my BlackBerry 10 smartphone on the XL network.
>


Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Tanya : Filter Data (<= dan >=) [1 Attachment]

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Maaf, gunakan file terlampir.

Salam
Sony


*gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*

On Tue, Apr 4, 2017 at 6:53 AM, Sony Ario <[hidden email]> wrote:

> Halo Orie,
>
> Sambil tunggu masukan dari suhu disini. File terlampir menggunakan
> Vlookup, Approximate Match.
> Maaf kalau belum sesuai ya ?
>
> Salam
> Sony
>
>
> *gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*
>
> On Mon, Apr 3, 2017 at 9:47 PM, [hidden email] [belajar-excel] <
> [hidden email]> wrote:
>
>>
>>
>> Dear All Suhu Excel yg saya hormati,
>>
>> Saya punya permasalahan nih, saya ingin mendapatkan hasil ‎ filter data
>> sesuai pada lampiran...
>>
>> Tolong solusi formulanya ya...
>> Makasih suhu2..^_^
>>
>>
>> Sent from my BlackBerry 10 smartphone on the XL network.
>>
>>
>>
>
>

Tanya Filter Data_rev1.xlsx (22K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Tanya : Filter Data (<= dan >=)

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Dear All Suhu...


Berhasil !!!
Makasih bang Sony n Mbul Nobie, formulanya membantu sekali...
Salam sukses buat kalian ^_^




--------------------------------------------
Pada Sen, 3/4/17, Mbul [hidden email] [belajar-excel] <[hidden email]> menulis:


 Judul: Re: [belajar-excel] Tanya : Filter Data (<= dan >=)
 Kepada: [hidden email]
 Tanggal: Senin, 3 April, 2017, 5:20 PM

 Dear Arie,




 Coba gunakan formula :
 VLOOKUP(F3;A$1:D$100;4;TRUE)




 Rgd's
 Mbul




 On 03/04/17 21:47, [hidden email]
 [belajar-excel] wrote:
 >
 > Dear All Suhu Excel yg saya hormati,
 >
 > Saya punya
 permasalahan nih, saya ingin mendapatkan hasil ‎ filter
 > data sesuai pada lampiran...
 >
 > Tolong solusi
 formulanya ya...
 > Makasih suhu2..^_^
 >
 >
 >
 Sent from my BlackBerry 10 smartphone on the XL network.
 >