]] XL-mania [[ Digest Number 2323

Microsoft Excel Community

Messages In This Digest (5 Messages)

1a.

Re: Mendisable exit pada excel From: i Haps

2a.

Re: Look Up Beberapa Karakter di Shhet berbeda From: i Haps

2b.

Re: Look Up Beberapa Karakter di Shhet berbeda From: Kid Mr.

2c.

Re: Look Up Beberapa Karakter di Shhet berbeda From: sigit lalamentik

3a.

Re: Formula Tidak Bekerja From: Kid Mr.

View All Topics | Create New Topic

Messages

1a.

Re: Mendisable exit pada excel

Posted by: "i Haps" hapsari.stlizbeth@gmail.com   liz_indri_haps

Wed Jan 18, 2012 9:58 pm (PST)

' *tulis di modul this workbook*
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox "anda terkungkung di sini tidak bisa keluar, trus ginama dong
caranya",48,"???"
End Sub

- i -

*
*
2012/1/17 iskandar <nomor_pribadi@yahoo.co.id>

> **
>
> Dear para suhu, Mohon maaf klo ane banyak nanya. Kali pertanyaan yang ada
> dibenaku bisa nggak dg vba mendisable menu/tombol exit pada excel? Yang
> dimaksud tombol exit ini buan pada userform tp pada menu excelnya sendiri
> baik di pojok kanan atas maupun dimenu office button/file --> exit. Mohon
> pencerahan para master...
> terima kasih...
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.

Re: Look Up Beberapa Karakter di Shhet berbeda

Posted by: "i Haps" hapsari.stlizbeth@gmail.com   liz_indri_haps

Wed Jan 18, 2012 9:59 pm (PST)

Mas Kelana ingin memfilter tetapi *tidak terus terang bilang *
*bahwa ingin memfilter*

*Formula filter*:
array formula harus di akhiri dengan menahan nafas PLUS menekan
3 tombol Terkenal (Ctrl + Shift + Enter):
=IFERROR(INDEX(JURNAL!F$5:F$38,SMALL(IF(JURNAL!$B$5:$B$38=$B$3,ROW($1:$34)),ROW(1:$34))),"")

- i -

2012/1/17 Kelana Putra <k31_l13l@yahoo.com>

> **
> Dear Suhu-suhu Excel,
> Newbie mo tanya, caranya untuk me lookup beberapa karakter yang berada
> dilain sheet, sesuai dengan file terlampir.
> Sebelumnya sudah coba pke rumus Index dan Match, tapi tetep ga bisa.
> Tolong dibantu ya para Suhu-suhu Excel.
> Regards,
> Kelana
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2b.

Re: Look Up Beberapa Karakter di Shhet berbeda

Posted by: "Kid Mr." mr.nmkid@gmail.com   nmkid.family@ymail.com

Wed Jan 18, 2012 10:00 pm (PST)

Dear Kelana,

Mungkin mau mencoba fitur Pivot Table.

Regards,
Kid.

2012/1/17 Kelana Putra <k31_l13l@yahoo.com>

> **
>
>
> Dear Suhu-suhu Excel,
>
> Newbie mo tanya, caranya untuk me lookup beberapa karakter yang berada
> dilain sheet, sesuai dengan file terlampir.
> Sebelumnya sudah coba pke rumus Index dan Match, tapi tetep ga bisa.
> Tolong dibantu ya para Suhu-suhu Excel.
>
> Regards,
> Kelana
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2c.

Re: Look Up Beberapa Karakter di Shhet berbeda

Posted by: "sigit lalamentik" lalamentiksigit80@gmail.com   lalamentiksigit80

Wed Jan 18, 2012 10:00 pm (PST)

Copy paste aja formula ini gan,

=VLOOKUP($B$3&B9,Jurnal!A8:F8,6,0)

taruh di coloumn debit nya

[image: solve.jpg]

Takecare,
Sigit

Dear Suhu-suhu Excel,

Newbie mo tanya, caranya untuk me lookup beberapa karakter yang berada
dilain sheet, sesuai dengan file terlampir.
Sebelumnya sudah coba pke rumus Index dan Match, tapi tetep ga bisa.
Tolong dibantu ya para Suhu-suhu Excel.

Regards,
Kelana

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

3a.

Re: Formula Tidak Bekerja

Posted by: "Kid Mr." mr.nmkid@gmail.com   nmkid.family@ymail.com

Wed Jan 18, 2012 10:03 pm (PST)

Dear Agung,

Coba formula :
=IF(COUNTIF(C3,"*00j$*")+COUNTIF(C3,"*00k$*"),DATE(20&RIGHT(D3,2),LEFT(D3,2),MID(D3,4,2)),--TEXT(20&MID(C3,SEARCH("$00",C3)+4,6),"0000-00-00"))

Regards,
Kid.

On Tue, Jan 17, 2012 at 08:22, Anggana, Agung <agung.anggana@sc.com> wrote:

> **
>
>
> Dear Temans,****
>
> ** **
>
> ****Ada**** yang bisa bantu pencerahannya.. kenapa formula untuk 4 & 5
> conditionalnya tidak bekerja ya sesuai conditional if yang ke 2 dan ke 3**
> **
>
> Lebih lengkapnya bisa di lihat di attach…****
>
> ** **
>
> Thanks****
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the addressee, do not disclose, copy, circulate
> or in any other way use or rely on the information contained in this email
> or any attachments. If received in error, notify the sender immediately and
> delete this email and any attachments from your system. Emails cannot be
> guaranteed to be secure or error free as the message and any attachments
> could be intercepted, corrupted, lost, delayed, incomplete or amended.
> Standard Chartered PLC and its subsidiaries do not accept liability for
> damage caused by this email or any attachments and may monitor email
> traffic.
>
> Standard Chartered PLC is incorporated in England with limited liability
> under company number 966425 and has its registered office at 1 Aldermanbury
> Square, London, EC2V 7SB.
>
> Standard Chartered Bank ("SCB") is incorporated in England with limited
> liability by Royal Charter 1853, under reference ZC18. The Principal Office
> of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In
> the United Kingdom, SCB is authorised and regulated by the Financial
> Services Authority under FSA register number 114276.
>
> If you are receiving this email from SCB outside the UK, please click
> http://www.standardchartered.com/global/email_disclaimer.html to refer to
> the information on other jurisdictions.
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Recent Activity

•  68
  New Members

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! Groups

Mental Health Zone

Schizophrenia groups

Find support

Dog Fanatics

on Yahoo! Groups

Find people who are

crazy about dogs.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| ayooo... coba cari XL-mania di linkedin.com                       |
| boss2 dari zone visit, moderasi nge-lag lagi deghhhh :(           |
+-------------------------------------------------------------------+
| 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.friendster.com/xlmania atau...  |
| 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              |
+-------------------------------------------------------------------+

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe