Coba ketik array formula
=MAX((C7:AG7>0)*($C$4:$AG$4))
Akhiri dengan menekan CONTROL+SHIFT+ENTER


Sent from Mail for Windows 10

From: halak hita halakhita1...@gmail.com [belajar-excel]
Sent: Monday, January 27, 2020 11:01 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Rumus menentukan tanggal terakhir

  
Dear Master excel

Tolong dibantu, bagaimana rumus agar saya bisa monitoring tanggal terakhir 
update masing-masing kota


salam
Franki





Attachment: re-RUMUS Monitor Tanggal Terakhir Update.xlsx
Description: MS-Excel 2007 spreadsheet

Reply via email to