Hot Fox

quinta-feira, 31 de julho de 2014

RE: ]] XL-mania [[ menghitung banyak stanby,used,loss [1 Attachment]

Dear Ari Mike,

Lihat formulanya pada lampiran ya

Salam

Adi IDrus

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: Tuesday, July 29, 2014 4:42 PM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ menghitung banyak stanby,used,loss [1 Attachment]

mohon bantuan untuk formula pada lampiran

__._,_.___

View attachments on the web

Posted by: Adi Idrus <adi.idrus@bridgestone.co.id>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message, melecehkan, tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu"
Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/
:: ------------- ::::::::::::::::::::
Berikan testimoni di :
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www.mail-archive.com/xl-mania@yahoogroups.com

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: ]] XL-mania [[ menghitung used dan stanby serta loss [1 Attachment]

Rekan Arimike,

Semoga ini bisa menjawab :

=COUNTIF($C$3:$C$26,O$4)

Regards

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: Tuesday, July 29, 2014 4:02 PM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ menghitung used dan stanby serta loss [1 Attachment]

Rekan2 yang baik dan super sekali mohon bantuannya untuk problem yang saya lampirkan.

*** WORLEYPARSONS GROUP NOTICE *** "This email is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this email in error, please notify us immediately by return email and delete the email and any attachments. Any personal views or opinions expressed by the writer may not necessarily reflect the views or opinions of any company in the WorleyParsons Group of Companies."

__._,_.___

View attachments on the web

Posted by: "David, Yasman (ECM - RIAU)" <Yasman.David@rekindworleyparsons.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Tanya Nilai Maksimum Absolut

Hai YB,

Misal data di A1:A6

array formula dalam sebuah cell berbunyi :

=max( abs( a1:a6 ) )

Jika di-VBA-ken

Sheets("nama sheet penulisan hasil").range("alamat cell hasil").value = Evaluate("max( abs( a1:a6 ) )")

Bagian yang di-biru bisa didinamiskan sendiri kan ya

Wassalam,

Kid.

2014-07-16 15:35 GMT+10:00 baptista_yr@yahoo.com [XL-mania] <XL-mania@yahoogroups.com>:

Dear all excel masters,
Selamat siang semua. Saya mau menanyakan bagaimana penulisan di dalam macro vba yang penulisan di excelnya adalah sbb:
=ABS(J61)&" m "&IF(J61<0,"Up","Down")&" ,"&ABS(K61)&" m "&IF(K61<0,"Left","Right")
Jadi intinya saya mau mencari nilai maximum dari sederetan nilai yang diabsolutkan. Dalam deretan nilai yang mau dicari nilai maksimumnya, terdapat angka yang bernilai minus. Sebagai contoh bila ada deret angka {0,200,-50,123,346,-546}, makan nilai maksimum yang dicari adalah 546.
Terima kasih sebelumnya untuk bantuan dan informasinya dari para masters sekalian.

Cheers,
YB

__._,_.___

Posted by: "Mr. Kid" <mr.nmkid@gmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ menghitung banyak stanby,used,loss [1 Attachment]

2014-07-29 16:42 GMT+07:00 Ari Mike arimike@ymail.com [XL-mania] <XL-mania@yahoogroups.com>:

mohon bantuan untuk formula pada lampiran

__._,_.___

View attachments on the web

Posted by: andre sidharta <andre@ivanjaya.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

quarta-feira, 30 de julho de 2014

Re: ]] XL-mania [[ menghitung used dan stanby serta loss

Hai Arimike,

untuk Used :
=COUNT($C$3:$C$26)

untuk Standby :
=COUNTIF($C$3:$C$26,O$4)

untuk Loss :

copy formula untuk standby ke cell hasil untuk loss

Wassalam,

Kid.

2014-07-29 19:02 GMT+10:00 arimike@ymail.com [XL-mania] <XL-mania@yahoogroups.com>:

Rekan2 yang baik dan super sekali mohon bantuannya untuk problem yang saya lampirkan.

__._,_.___

Posted by: "Mr. Kid" <mr.nmkid@gmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

terça-feira, 29 de julho de 2014

Re: ]] XL-mania [[ menghitung used dan stanby serta loss

Dear Pak

Pakai Fungsi COUNTIF

Masukan formula berikut ke cell O5 :
=COUNTIF(C3:C26,"stanby")

Regards,

Jaka Purnama

2014-07-29 16:02 GMT+07:00 arimike@ymail.com [XL-mania] <XL-mania@yahoogroups.com>:

Rekan2 yang baik dan super sekali mohon bantuannya untuk problem yang saya lampirkan.

__._,_.___

Posted by: Jaka Purnama <jaka.purnama88@gmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Mengganti Character dgn Syarat di Cells

Hai Galuh,

Kalau mau pakai UDF, bisa diunduh disini pada sheet SubsMidChar

yang bunyi function dalam sebuah general module VBA-nya berbunyi :

[letakkan dalam sebuah general module di VBE]

're-write VB : 201305
Public Function SubsMidChar(sTeks As String, Optional sChar As String = "*") As String
    Dim vKata As Variant, sHasil As String
    For Each vKata In Split(sTeks, " ")
        If Len(vKata) > 2 Then
            sHasil = sHasil & Left(vKata, 1) & String(Len(vKata) - 2, sChar) & Right(vKata, 1) & " "
        Else
            sHasil = sHasil & vKata & " "
        End If
    Next vKata
    SubsMidChar = Trim(sHasil)
End Function

Cara pakai dalam worksheet :

=SubsMidChar( teks , [karakter_pengganti] )

Contoh untuk data di A1 berbunyi : 'Contoh dari ku'

Bunyi Formula Hasilnya

=SubsMidChar( A1 ) C****h d**i ku

=SubsMidChar( A1 , "#" ) C####h d##i ku

=SubsMidChar( A1 , "@?$" ) C@@@@h d@@i ku

Wassalam,

Kid.

2014-07-23 13:15 GMT+10:00 Galuh Sukmana galuh.sukmana@gmail.com [XL-mania] <XL-mania@yahoogroups.com>:

Dear All Excelers,

Saya ingin mengganti beberapa char dicell bersyarat menggunakan replace atau substitute, tetapi saya kesulitan membuatnya karena masing2 cell tidak sama jumlah characternya

Cth:
Budi Indah Lalu = B**i I***h L**u
Windarini Suratmi = W*******i S*****i
Mejikuhibiniu = M***********u
Bantex Bagus Putih = B****x B***s P***h

Mohon bantuannya utk bisa memberikan pencerahannya. Atas bantuannya diucapkan terima kasih

Regards,
Galuh

__._,_.___

Posted by: "Mr. Kid" <mr.nmkid@gmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ sortir ribuan no hp supaya menjadi no yang valid. [1 Attachment]

Coba ini Sdr. Jayyusz (lihat file)

On Tuesday, July 29, 2014 10:37 PM, "jayyusz@yahoo.com [XL-mania]" <XL-mania@yahoogroups.com> wrote:

halo,

saya mau bertanya, bagaimana cara singkat untuk mensortir ribuan no hp yang belum tentu valid formatnya supaya menjadi valid.

contoh :
626208164547598
6208164547598
08164547598
8164547598
628164547598
62628164547598

saya ingin mengambil no yang sudah di sortir menjadi 8164547598 selain itu tidak ditampilkan.
seampai sekarang saya manual mensortir per tingkat.
contoh saya sortir dahulu yang angka depan nya 62 kemudian setelah mendapatkan haasilnya di sortir kembali dan seterusnya.

untuk lebih jelas nya saya melampirkan contoh data excel nya.

nb: saya ingin mensortir berdasarkan no yang valid yang ada di indonesia berdasarkan provider yang ada.
(telkomsel 812,813,821) seperti itu.

tq before

__._,_.___

View attachments on the web

Posted by: HERIS PAMUNTJAR <heris2001@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Yahoo Groups

Instantly Explore All Attachments Within Each Group Conversation

You can now explore files, preview and download photos directly within each conversation.

Visit Your Group

New Members 11

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: ]] XL-mania [[ Mengganti Character dgn Syarat di Cells [1 Attachment]

Selamat Idul Fitri ...

coba ini Galuh ( lihat file )

On Tuesday, July 29, 2014 10:37 PM, "Galuh Sukmana galuh.sukmana@gmail.com [XL-mania]" <XL-mania@yahoogroups.com> wrote:

Dear All Excelers,

Saya ingin mengganti beberapa char dicell bersyarat menggunakan replace atau substitute, tetapi saya kesulitan membuatnya karena masing2 cell tidak sama jumlah characternya

Cth:

Budi Indah Lalu = B**i I***h L**u

Windarini Suratmi = W*******i S*****i

Mejikuhibiniu = M***********u

Bantex Bagus Putih = B****x B***s P***h

Mohon bantuannya utk bisa memberikan pencerahannya. Atas bantuannya diucapkan terima kasih

Regards,

Galuh

__._,_.___

View attachments on the web

Posted by: HERIS PAMUNTJAR <heris2001@yahoo.com>

Reply via web post