Support Board
Date/Time: Wed, 02 Jul 2025 06:16:42 +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!!
|