=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/> 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

Kirim email ke