Support Board
Date/Time: Mon, 10 Mar 2025 10:50:23 +0000
Post From: Spreadsheet, nth most recent nonzero value?
| [2022-03-17 18:23:26] |
| Sawtooth - Posts: 4181 |
|
It seems the SMALL function does not work if there are any zeros in the array; it returns 0 regardless of the nth smallest value. By contrast, the LARGE function works with zeros in the array, as expected. Are you trying to return the smallest of the 10 most recent unique nonzero values? |