Re: ]] XL-mania [[ Mencari Kolom Terakhir

Mon, 21 Apr 2014 06:42:35 -0700 

Hai Khol..

Coba begini:
=LOOKUP(99^9,INDIRECT("B"&MATCH(A9,$A$1:$A$4,0)&":"&"E"&MATCH(A9,$A$1:$A$4,0)))
copas kebawah


Wassalam

~ Bagus ~



  ----- Original Message -----
  From: muhammad kholidun
  To: [email protected]
  Sent: Thursday, April 10, 2014 9:12 PM
  Subject: ]] XL-mania [[ Mencari Kolom Terakhir [1 Attachment]




  Bagaimana mencari data kolom terakhir sebelum kolom kosong pada baris 
tertentu.


  Terima kasih

Kirim email ke