XL Mania yang saya hormati,
Mohon bantuannya untuk membuatkan rumus untuk kasus terlampir, berhubung ada ribuan baris yang perlu dibuat
| DATA | | HASIL yang diinginkan | | ||||||
| | | | | | | | | | |
| Part No | Promised Date | Open | Qty Required (Prod'n) | | MIH Qty | MIH Date | Vendor Name | Remarks | |
| LS-120-3002-00 | 00-Jan-1900 | 104000 | (83,098) | | 104000 | TBA | | | |
| | 15-Nov-2010 | 64000 | | | | | | | |
| | 08-Dec-2010 | 80000 | | | | | | | |
| | 04-Jan-2011 | 4000 | | | | | | | |
| | 05-Jan-2011 | 88000 | | | | | | | |
| LS-120-3008-00 | 00-Jan-1900 | 4500 | (3,385) | | 4500 | TBA | | | |
| | 15-Nov-2010 | 1500 | | | | | | | |
| | 04-Jan-2011 | 1500 | | | | | | | |
| LS-120-3012-00 | 00-Jan-1900 | 16000 | (14,307) | | 16000 | TBA | | | |
| | 08-Nov-2010 | 13000 | | | | | | | |
| | 01-Dec-2010 | 13000 | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| Noted: | * MIH Qty, nilainya harus lebih besar dari Qty required. Datanya diambil dari Open PO | | | ||||||
| | Apabila jumlah dari Open PO kecil dari Qty required, maka pada MIH Qty kolom diisi TBA and MIH Date NO OPO | ||||||||
| | * MIH date, datanya diambil dari Promise date | | | | | | | ||
| | Apabila promise date 00-Jan-1900, maka diganti menjadi TBA | | | | |
Atas bantuannya saya ucapkan terima kasih
Regards,
Candra
+607-6612384
********************************************************************** CONFIDENTIALITY CAUTION : This email is intended only for the use of the individual or entity to whom it is addressed and contains information that is confidential and may also be privileged. If you, the reader of this email, are not the intended recipient, you are strictly prohibited from disseminating, distributing, copying, disclosing or in any way use or rely on information contained in this email or any attachment. If you have received this email in error, please notify us immediately by return email and delete the original email including any attachment. www.beyonics.com **********************************************************************
| ada yang mau nyobain ice cream bikinan momods? |
| 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