sorry pertanyaan yang kyk gini dah sering ditanyaain neh, coba liat alias jalan
ke posting2 sebelumnya
formula bisa pake array formula index, contoh
untuk ambil code
=INDEX('Shaft Reqs.'!$B$3:$B$11,SMALL(IF('Shaft
Reqs.'!$D$3:$D$11="vacant",ROW($1:$9)),ROW()-3))
thanks
Imam Nurhadi
----- Original Message ----
From: Ivan Agustian <[EMAIL PROTECTED]>
To: XL Mania <[email protected]>
Sent: Thursday, September 11, 2008 5:24:48 AM
Subject: ]] XL-mania [[ Ambil Baris Tertentu
Dear XL Mania,
Mohon bantuannya cara untuk mengambil baris tertentu dari suatu sheet dengan
satu kriteria.
Contoh permasalahan terlampir.
Thanks, Ivan
________________________________
Always-on security tools provide safer ways to connect and share anywhere. Find
out more. Windows Live
________________________________
Make the most of what you can do on your PC and the Web, just the way you want.
Windows Live
