Support Board
Date/Time: Sun, 22 Jun 2025 21:08:10 +0000
Post From: Spreadsheet, nth most recent nonzero value?
| [2022-03-17 23:42:40] |
| j4ytr4der_ - Posts: 947 |
|
Yep, got it now. Was a combination of the issue around SMALL() not handling zeroes, and also absolute vs. relative references in my range reference. Got what I wanted now. It takes 11 columns total but I can live with that. Not sure I'm even ultimately going to keep this idea but wanted to try it out. I appreciate the assist on this!!
|