newbie coba bantu jawab yah. seperti nya ini kudu pake array formula yah.
enter formula di H9 yakni: =MAX(IF(B4:B31=H3,D4:D31)) , lalu pakai 3 jari sakti (shift-control-enter), lalu ganti format cells ke tanggal jika diperlukan :) o ya, kalo ga pake 3 jari sakti, maka hasil formula akan 0. semoga membantu. On Fri, Feb 21, 2014 at 12:31 PM, MSJ Planners Block D < [email protected]> wrote: > > > Dear XL-Members.. > > Silahkan di bantu untuk unek unek saya yang terlampir. Demikian dan terima > kasih… > > > > > > > > Salam, > > Musriadi > > ______________________________________________________________________ > This email has been scanned by the Symantec Email Security.cloud service. > For more information please visit http://www.symanteccloud.com > ______________________________________________________________________ > > > -- regards, Wira 鄧又銘 on desktop FireFox
