Login Page - Create Account

Support Board


Date/Time: Mon, 10 Mar 2025 10:33:52 +0000



Post From: Spreadsheet, nth most recent nonzero value?

[2022-03-17 15:16:45]
j4ytr4der_ - Posts: 946
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