Mas Yudi, Bisa juga dengan Sumproduct
=SUMPRODUCT(($B4=Data!$A$2:$A$116)*(E$3=Data!$E$2:$E$116)) Rgds Yasman David From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of yudhi nich Sent: Wednesday, July 03, 2013 3:24 PM To: XL-mania@yahoogroups.com Subject: ]] XL-mania [[ menyamakan hasil di row dengan kolom Dear Para Suhu 2 excel. Mohon bantuannya untuk mendapatkan hasil dari ( mencocokan ) lead time dengan Forwarder. Terlampir, Terimakasih atas bantuannya. Rgd’s Yudi *** WORLEYPARSONS GROUP NOTICE *** "This email is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this email in error, please notify us immediately by return email and delete the email and any attachments. Any personal views or opinions expressed by the writer may not necessarily reflect the views or opinions of any company in the WorleyParsons Group of Companies."
