Koreksi : = SMALL(('TDK-R'!$A$2:$A$22=A2)*('TDK-R'!$I$2:$I$22),1)seharusnya
: =SMALL(IF(('TDK-R'!$A$2:$A$200=$A$2),('TDK-R'!$I$2:$I$200)),1)koreksi :
=IF(('data base'!$B$3:$B$7<=D2)*(D2<='data base'!$C$3:$C$7),'data
base'!$D$3:$D$7)seharusnya : =SMALL(IF(('data
base'!$B$3:$B$7<=$E2)*($E2<='data base'!$C$3:$C$7),'data base'!$D$3:$D$7),1)
saya membagi menjadi 2 kolom supaya rumusnya mudah dibaca
To: [email protected]
From: [email protected]
Date: Mon, 19 Sep 2011 07:03:10 +0000
Subject: RE: [belajar-excel] Kapasitas mesin dinamis
letakkan rumus ini di sel D2 dan E2 (worksheet hasil ) :
=SMALL(('TDK-R'!$A$2:$A$22=A2)*('TDK-R'!$I$2:$I$22),1)
=IF(('data
base'!$B$3:$B$7<=D2)*(D2<='data base'!$C$3:$C$7),'data
base'!$D$3:$D$7)
rumus diatas adalah rumus array formula ( jadi saat entri , lalu akhiri dgn
[Ctrl] + [Shifte] bersamaan lalu tekan [Enter]
hasilnya :
743
0.6035
Semoga sesuai
To: [email protected]
From: [email protected]
Date: Mon, 19 Sep 2011 12:55:03 +0800
Subject: [belajar-excel] Kapasitas mesin dinamis
Teman2...Maaf ya..saya lupa menghapus data2 yg tidak diperlukan
Saya kirim ulang ya....Mohon bantuannya
Best Regards,
Sodik
.
NOTICE - This message and any attached files may contain information that is
confidential, legally privileged or proprietary. It is intended only for use by
the intended recipient. If you are not the intended recipient or the person
responsible for delivering
the message to the intended recipient, be advised that you have received this
message in error. Any dissemination, copying, use or re-transmission of this
message or attachment, or the disclosure of any information therein, is
strictly forbidden. BlueScope
Steel Limited does not represent or guarantee that this message or attachment
is free of errors, virus or interference.
If you have received this message in error please notify the sender immediately
and delete the message. Any views expressed in this email are not necessarily
the views of BlueScope Steel Limited.
