[belajar-excel] pengelompokan alamat

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

[belajar-excel] pengelompokan alamat

rizald al kaaf
met siang rekan2, selamat berlibur hehe
ganggu nihh

saya punya data alamat, nama jalannya doang
maunya dikelompokkan per kelurahan dengan cara kira2,,,,kira2 jalan yg
mengandung kata2 tertentu terdapat di kelurahan tertentu

gimn caranya ya?bocoring dong :p

terima kasihhh

pengelompokan alamat.xls (45K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] pengelompokan alamat

M. Ferdiansyah
Dear P' Rizald,

Sembari menunggu master" beexcel menjawab, izinkan saya untuk mencoba
menjawabnya ya..

file terlampir..

wassalam,
ferdy

> met siang rekan2, selamat berlibur hehe
> ganggu nihh
>
> saya punya data alamat, nama jalannya doang
> maunya dikelompokkan per kelurahan dengan cara kira2,,,,kira2 jalan yg
> mengandung kata2 tertentu terdapat di kelurahan tertentu
>
> gimn caranya ya?bocoring dong :p
>
> terima kasihhh
>



____________ _________ _________ _________ _________ _________ _________
Notice  : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________

coba jawab - pengelompokan alamat.xls (56K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] pengelompokan alamat

Kid
Administrator
In reply to this post by rizald al kaaf
Coba array formula : (selalu ambil yang terakhir)
=INDEX(REF!$E$3:$E$8,*MAX*
(IF(COUNTIF(D2,"*"&REF!$D$3:$D$8&"*"),ROW(REF!$E$3:$E$8)-ROW(REF!$E$3)+1)))

Ganti fungsi Max dengan fungsi Min untuk mengambil yang pertama ditemukan

Regards.
Kid.

2011/5/1 rizald al kaaf <[hidden email]>

>
>
> met siang rekan2, selamat berlibur hehe
> ganggu nihh
>
> saya punya data alamat, nama jalannya doang
> maunya dikelompokkan per kelurahan dengan cara kira2,,,,kira2 jalan yg
> mengandung kata2 tertentu terdapat di kelurahan tertentu
>
> gimn caranya ya?bocoring dong :p
>
> terima kasihhh
>  
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] pengelompokan alamat

Hilman
In reply to this post by rizald al kaaf
Formula Array pada cell E2

=IFERROR(OFFSET(REF!$E$3,SMALL(IF(ISERROR(SEARCH(REF!$D$4:$D$8,Sheet1!D2)),FALSE,ROW($1:$5)),1),0),"Au Ah Elap")

copy ke bawah




________________________________
From: rizald al kaaf <[hidden email]>
To: belajar-excel <[hidden email]>
Sent: Sunday, May 1, 2011 1:25 PM
Subject: [belajar-excel] pengelompokan alamat


 
met siang rekan2, selamat berlibur hehe
ganggu nihh

saya punya data alamat, nama jalannya doang
maunya dikelompokkan per kelurahan dengan cara kira2,,,,kira2 jalan yg
mengandung kata2 tertentu terdapat di kelurahan tertentu

gimn caranya ya?bocoring dong :p

terima kasihhh

 

pengelompokan alamat by Hilman.xls (59K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Re: pengelompokan alamat

rizald al kaaf
trims atas jawabannya rekan2
tp blm bisa coba, masi blm di depan lapie

besok reportnya ya

salam,

On Sunday, May 1, 2011, Hilman <[hidden email]> wrote:

>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>       Formula Array pada cell E2
> =IFERROR(OFFSET(REF!$E$3,SMALL(IF(ISERROR(SEARCH(REF!$D$4:$D$8,Sheet1!D2)),FALSE,ROW($1:$5)),1),0),"Au Ah Elap")
> copy ke bawah
>
>
> From: rizald al kaaf <[hidden email]>
> To: belajar-excel <[hidden email]>
> Sent: Sunday, May 1, 2011 1:25 PM
> Subject: [belajar-excel] pengelompokan alamat
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>       met siang rekan2, selamat berlibur hehe
> ganggu nihh
>
> saya punya data alamat, nama jalannya doang
> maunya dikelompokkan per kelurahan dengan cara kira2,,,,kira2 jalan yg
> mengandung kata2 tertentu terdapat di kelurahan tertentu
>
> gimn caranya ya?bocoring dong :p
>
> terima kasihhh
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>    
>
>
>
>
>
>
>
>
>
>
>
>
>
>


------------------------------------

---------------------------------------------------------------------
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 & owners: [hidden email]

keluar dari membership milis (UnSubscribe):
kirim mail kosong ke  [hidden email]
---------------------------------------------------------------------Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/belajar-excel/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/belajar-excel/join
    (Yahoo! ID required)

<*> To change settings via email:
    [hidden email]
    [hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/