Pakai formula array (CTRL+SHIFT+ENTER) di [C3] =MIN(IF(H3:Q3>0,$H$2:$Q$2)) [D3] =MAX(IF(H3:Q3>0,$H$2:$Q$2))
Contoh terlampir From: [email protected] [mailto:[email protected]] On Behalf Of adityadharma Cohay Sent: Thursday, September 29, 2011 9:36 AM To: [email protected] Subject: ]] XL-mania [[ Fungsi Mencari Schedule dari Manpower Loading Dear Master XL, Mohon pencerahan, bagaimana formula untuk Mencari Schedule dari Manpower Loading seperti file terlampir. Thanks, Adityadharma mohon pencerahan, bagaimana formula pada cell warna kuning untuk kasus seperti di atas ini. start date,end date, dan duration diambil dari data manpower loading disampingnya Thanks, Adityadharma
Copy of Fungsi Mencari Schedule dari Manpower Loading.xls
Description: MS-Excel spreadsheet
