Support Board
Date/Time: Mon, 10 Mar 2025 10:43:01 +0000
Post From: Spreadsheet, nth most recent nonzero value?
| [2022-03-17 01:27:27] |
| j4ytr4der_ - Posts: 946 |
|
I've got a solution that would work, except that the SMALL() function doesn't appear to work the way it is described. From the documentation: Returns the Nth smallest number from an array of numbers. The first argument is the array, while the last argument controls which number will be returned. 1 means the smallest number, 2 the second smallest and so on. Empty cells are not counted, TRUE will be considered as 1, FALSE as 0. Returns #VALUE! if the last argument is smaller than 1 or greater than the number of numerical values (and booleans) in the array.
But what it actually returns is the value contained in the Nth lowest row number, not the lowest value in the range. Support, is this how the SMALL() function is meant to work? If so that's unfortunate, and I think the documentation could use some tweaking to accurately reflect what it returns. Date Time Of Last Edit: 2022-03-17 01:28:08
|