Support Board
Date/Time: Wed, 05 Nov 2025 09:10:33 +0000
Post From: Compare range of individual values
| [2023-12-12 06:07:58] |
| User273277 - Posts: 87 |
|
I found another post from a while ago with a similar question. There was no final solution posted. I put into column P to remove the zeros: =IF(ID1.SG2@3=0,NOVALUE,ID1.SG2@3) Then I am trying to use index in columns q-z for now to pull the next sequential non-novalue number: =INDEX(P4:P54,NMATCH(2,1,P4:P54,0),1) But the index is not working. I haven't used index here before, and looking for working examples. |