RE: ]] XL-mania [[ Problem plotting otomatis untuk maintenance schedule...

 

C5=OFFSET($C$3,,MAX((D5:K5="X")*COLUMN(D5:K5))-COLUMN($C$3))

Jangan lupa jangan tekan ENTER tapi CTRL+SHIFT+ENTER

 

Terus dicopy ke bawah

---

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of sofyan.jusuf@trakindo.co.id
Sent: Wednesday, February 17, 2010 10:49 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Problem plotting otomatis untuk maintenance schedule...

 

 

Dear pakar Excel yang hebat-hebat...
mohon pencerahan nih mengenai kasus saya. Soalnya harus ngerjain sampe 100-an yang seperti ini. :)
siapa tau ada yang bisa ngasih pencerahan dan membantu... :)

case-nya bisa di lihat di attchment.. Thanks A lot!!!



rgds,
sofyan

=========================================================================== This email is confidential.  If  you are not the  addressee tell the sender immediately  and destroy this  email without using,  sending or storing it. Emails are not secure  and may suffer  errors, viruses, delay, interception and amendment.  The Trakindo Group of Companies do not accept liability for damage   caused   by   this   email   and   may   monitor   email  traffic. Unless expressly stated, any opinions are the sender's and are not approved by  the  Tiara Marga Trakindo  Group of Companies and  this email is not an offer, solicitation,  recommendation   or   agreement   of    any     kind. ===========================================================================

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4872 (20100216) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4872 (20100216) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__._,_.___

Reply to sender | Reply to group

Messages in this topic (10)

Recent Activity:

• New Members 129

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| malu bertanya kerja manual... kebanyakan nanya (malas lihat post  |
| lama, nanya itu2 aja, males liat help) capeee deh... :( :( :(     | 
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| 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              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___