semoga membantu
On Sunday, 2 March 2014, 16:03, WIRAnata Kemala 鄧又銘 <[email protected]> wrote: 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
Solved_777D- Shaft Broken.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
