Login Page - Create Account

Support Board


Date/Time: Tue, 16 Sep 2025 14:42:21 +0000



Post From: Spreadsheet, nth most recent nonzero value?

[2022-03-17 15:16:45]
j4ytr4der_ - Posts: 947
Tom, one small issue with this approach is that it's quite possible for me to have the same level separated by some cells of zeros, in which case the value repeats. I would prefer to only have any given value of the 10, be acknowledged once. Any idea of an efficient way to accomplish this?

For example...

4340.75  4345.00  4341.75  4346.75  4346.50  4348.50  4349.75  4352.75  4352.75  4358.50