Support Board
Date/Time: Mon, 03 Feb 2025 17:04:52 +0000
Post From: Spreadsheet
| [2019-09-26 13:36:47] |
| AndreyPoroshin - Posts: 105 |
|
While I was waiting for the answer to my question, I temporarily did this: AC =IF(AND(FRACTIME($J$42)>FRACTIME(A3),K3>0),D3,0) AE =IF(AND(FRACTIME($J$42)>FRACTIME(A3),M3>0),C3,0) this formula eliminates zeros =MOSTRECENTNONZEROVALUE(AC@3:AC@100) =MOSTRECENTNONZEROVALUE(AE@3:AE@100) |