Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 18 Apr 2024 22:43:08 +0000

How to Post a Message for Support

Post From: Spreadsheet

[2019-09-26 13:36:47]
[Go To First Post]
AndreyPoroshin - Posts: 102
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)