Di cell B2 tulis formula seperti ini : 
"=IF(A2<>0,A2,SMALL($A$2:$A$14,COUNTIF($A$2:$A$14,0)+1))" lalu copy ke cell 
dibawahnya dan diakhiri dengan menekan tombol CSE.
 
Semoga membantu.
 
~Ahmad Adriansyah~

________________________________

From: [email protected] on behalf of Andrian, Vozi
Sent: Thu 6/5/2008 13:52
To: [email protected]
Subject: ]] XL-mania [[ cari data minimum



Teman mohon bantuannya ya, pertanyaan di attachment. Makasih banyak...
 
Zii

 

Kirim email ke