Login Page - Create Account

Support Board


Date/Time: Tue, 18 Feb 2025 22:23:11 +0000



Post From: Compare range of individual values

[2023-12-12 06:07:58]
User273277 - Posts: 64
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.