sepertinya masalahnya ada dirumus
=OFFSET(dataentry!$B$5,SMALL(IF(dataentry!$B$6:$B$105=$E$2,ROW($1:$99)),ROW()-7),2)
yg saya tebalkan itu sepertinya bermasalah karena datanya tidak ada..sehingga
kalau kita hilangkan kondisoanal formatingnya akan terlihat pesan error
row()-7 pada posisi "B4" akan bernilai -3
sementara data bapak mulai dari posisi row ke 6
----- Original Message -----
From: Ahmad
To: XL Mania
Sent: Friday, August 08, 2008 10:19 AM
Subject: ]] XL-mania [[ paparkan data
Assalamualaikum wrt..
Saya ada kekeliruan sedikit..harap
kawan2 dapat memberi tunjuk ajar kepada saya...
Sila lihat attachment.
Terima Kasih
Ahmad
------------------------------------------------------------------------------
/---------------------------------------------------------------------------\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not the addressee indicated in this Message (or responsible for
delivery of this Message to such person),you are hereby notified that
any dissemination, distribution, printing or copying of this Message or
any part thereof is prohibited. Please delete this Message if received
in error and advise the sender by return e-mail. Opinions, conclusions
and other information in this Message that do not relate to the
official business of this company shall be understood as neither given
nor endorsed by this company.
This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd)
*Scanner Engine powered by Norman Virus Control
\--------------------------------------------------------------------------/
