Support Board
Date/Time: Fri, 31 Oct 2025 05:58:44 +0000
Post From: Spreadsheet, nth most recent nonzero value?
| [2022-03-17 23:07:50] |
| Sawtooth - Posts: 4281 |
|
The SMALL function works if you replace the zeros with NOVALUE, in another column: =IF(BS3=0,NOVALUE,BS3) However, it doesn't skip duplicates either. The only way to simultaneously return the 10 most recent unique nonzero values to row 3 is to use at least 10 Formula Columns. Since you are using column BS, can I assume you want the 10 values in a one-column table instead (not associated with chart bars)? Date Time Of Last Edit: 2022-03-17 23:13:52
|