Support Board
Date/Time: Mon, 10 Mar 2025 10:24:17 +0000
Post From: Spreadsheet, nth most recent nonzero value?
| [2022-03-17 18:55:26] |
| j4ytr4der_ - Posts: 946 |
|
I'm just trying to return the most recent nonzero, then the next, the next, etc. But to do so, I have first done this to get the rows containing nonzero values... ROW(VLOOKUP(MOSTRECENTNONZEROVALUE(BS4:BS50), BS4:BS50, 1, TRUE))
Column BS of course contains the actual values I'm looking for. so from there, I just want the smallest number first, and so on so that I can build an INDIRECT() to get me the actual value. Hope that makes sense. Stupidly complex but, only way I can think to do what I want, and there is no UNIQUE() function in SC. Date Time Of Last Edit: 2022-03-17 18:55:43
|