terima kasih atas bantuan...
tapi ada beberapa tambahan...
boleh ker saya gunakan formula ini bagi menampilkan data yg mempunyai nilai
diantara 1~5 & 6~10
saya dah cuba tapi x dapat...
boleh bantu saya...
yang amat mengharap
Ahmad
----- Original Message -----
From: Ahmad Zamroni
To: [email protected]
Sent: Friday, September 19, 2008 9:08 AM
Subject: RE: ]] XL-mania [[ tampilkan data yg bukan kosong
=INDEX($A$2:$A$52,SMALL(IF($B$2:$B$52>0,ROW($1:$51)),ROW()-1))
akhiri dengan Ctrl-Shift-Enter
-zam-
http://wongmbatu.blogspot.com/
------------------------------------------------------------------------------
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ahmad
Sent: Wednesday, September 17, 2008 3:52 PM
To: Undisclosed-Recipient:;
Subject: ]] XL-mania [[ tampilkan data yg bukan kosong
Assalamualaikum wrt...
Saya nak minta bantuan...
sila lihat attachment utk keterangan...
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
\--------------------------------------------------------------------------/
