Re: ]] XL-mania [[ Rumus yang tepat

[siti Vi]

maaf ikutan, walaupun terlambat,

masalahnya kalau ada nomor order muncul dua kali
dan sejajar dengan nomor deliveri yg NOMORNYA SAMA
misal
order no. 15  delivery  100023  qty 7
order no. 15  delivery  100023  qty 4
apakah ini disebut Partial ? Atau Whole ?
dari contoh yg ada: belum dapat disimpulkan

misalnya saja order 15 itu harus dianggap BUKAN Partial Shipment
rumusnya gimana ya.
kalau pakai fungsi buatan makronya: ndak sulit.


On 1/1/07, abimono [EMAIL PROTECTED] wrote:


mr steffen
see attached
- abimono -
http://abimono.blogspot.com/2007/01/high-quality-women.html
http://abimono.blogs.friendster.com/abimono/2007/01/high_quality_wo.html



ctv.SteffenBook1.xls
Description: MS-Excel spreadsheet

Re: ]] XL-mania [[ Rumus yang tepat

[abimono]

mr steffen

see attached


- abimono -

http://abimono.blogspot.com/2007/01/high-quality-women.html
http://abimono.blogs.friendster.com/abimono/2007/01/high_quality_wo.html

_
[http://abimono.blogspot.com/ ] [http://www.friendster.com/abimono ] [
www.abimono.com]
[http://xl-mania.blogspot.com/ ] [http://www.friendster.com/xlmania ] [
www.XL-mania.com]

On 12/21/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:


Dear All XL mania,
Saya punya sedikit problem dalam penulisan rumus, mohon kiranya dibantu.
permasalahannya ada didalam file terlampir.

(See attached file: Book1.xls)

Best Regards,

Steffen

,
DISCLAIMER :




--



rumusyangtepat.xls
Description: MS-Excel spreadsheet

]] XL-mania [[ Rumus yang tepat

[Steffen_Steffen]

Dear All XL mania,
Saya punya sedikit problem dalam penulisan rumus, mohon kiranya dibantu.
permasalahannya ada didalam file terlampir.

(See attached file: Book1.xls)

Best Regards,

Steffen

,
DISCLAIMER :




mods : tidak perlu menambah ]] XL-mania [[ di subject, sudah otomatis dari 
yahoogroups

Book1.xls
Description: application/msexcel

Re: ]] XL-mania [[ Rumus yang tepat

[Ignatius Joko Umbaran]

Pak,

Di cell H4 tulis 
=SUM(IF(ISERR(($H$22:$DQ$117=H3)*($H$23:$DQ$118)),,($H$22:$DQ$117=H3)*($H$23:$DQ$118)))

harus di confirm dgn Control + Shift + Enter..
copy sampai cell AA4

Di cell H5 tulis
=SUM(IF(ISERR(($H$22:$DQ$117=H3)*($H$24:$DQ$119)),,($H$22:$DQ$117=H3)*($H$24:$DQ$119)))

harus di confirm dgn Control + Shift + Enter..
copy sampai cell AA5

Salam

Opeth - In My Time of Need

  - Original Message - 
  From: Seatea 
  To: XL-mania@yahoogroups.com 
  Sent: Friday, November 24, 2006 2:00 PM
  Subject: ]] XL-mania [[ Rumus yang tepat



  Dear to XL-Mania semuanya

  Mau tolong tanya dong bwt semua XL mania yang sudah jago2.

  Pls see attachment


  Thx,
  siti n