Login Page - Create Account

Support Board


Date/Time: Sat, 28 Dec 2024 08:56:24 +0000



Post From: SPREADSHEET - MOSTRECENTNONZEROVALUE(Range)

[2016-02-19 16:49:01]
bekitz3 - Posts: 83
Can you please check the functionality of this spreadsheet function: MOSTRECENTNONZEROVALUE(Range)

In an attempt to understand & test this function I entered a simple formula in static cell G1 ('# of Trades' column).

G1=MOSTRECENTNONZEROVALUE(G3:G10)

I suspected this to constantly return the value in G3, but it always returns G10.
Date Time Of Last Edit: 2016-02-19 17:09:22