Hello All,
I am trying to identify first non blank cell without arrays and I am getting errors when I make the range dynamic. Here is what I did so far:
=MATCH(1,INDEX(1-ISBLANK(D2:T2),1,0),0) (this works correctly. The output is 4 and the first non empty cell is G2).
When I make the range (D2:T2) dynamic:
=MATCH(1,INDEX(1-ISBLANK(ADDRESS(ROW(D2),4)&":"&ADDRESS(ROW(D2),COLUMN(V2)-2)),1,0),0) this gives a wrong output of 1.
and then I tried:
=MATCH(1,INDEX(1-ISBLANK(INDIRECT(ADDRESS(ROW(D2),4)&":"&ADDRESS(ROW(D2),COLUMN(V2)-2))),1,0),0) and the output is again 1 which is not correct.
Where am I going wrong!
I am trying to identify first non blank cell without arrays and I am getting errors when I make the range dynamic. Here is what I did so far:
=MATCH(1,INDEX(1-ISBLANK(D2:T2),1,0),0) (this works correctly. The output is 4 and the first non empty cell is G2).
When I make the range (D2:T2) dynamic:
=MATCH(1,INDEX(1-ISBLANK(ADDRESS(ROW(D2),4)&":"&ADDRESS(ROW(D2),COLUMN(V2)-2)),1,0),0) this gives a wrong output of 1.
and then I tried:
=MATCH(1,INDEX(1-ISBLANK(INDIRECT(ADDRESS(ROW(D2),4)&":"&ADDRESS(ROW(D2),COLUMN(V2)-2))),1,0),0) and the output is again 1 which is not correct.
Where am I going wrong!