wah... wah.. terima kasih..
tapi sepertinya saya salah menjelaskan.
yang saya harapkan adalah bagaimana cara agar tanda "X" tersebut berada pada kolom yang sesuai dengan interval-nya?
jadi tidak memasukkan input "X" secara manual satu per satu...
thanks a lot!! :)
"Mr. Kid" <mr.nmkid@gmail. Sent by: XL-mania@yahoogroup 02/17/2010 01:06 PM | To: XL-mania@yahoogroup cc: Subject: Re: ]] XL-mania [[ Problem plotting otomatis untuk maintenance schedule... |
Dear Pak Sofyan,
Bisa menggunakan fungsi-fungsi Mod(), LookUp(), dan CountIF()
Regards.
Kid.
On Wed, Feb 17, 2010 at 10:48 AM, <sofyan.jusuf@
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. ============ |
============ |
| 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 |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário