Assistance With Excel Formula

[tomohawk]

I have a defined range (see attached)

In column L, the values will gradually change in value, going from negative to positive.



I want to identify the first row in that column (L) that is not negative and return the value in column A for that row

[Logit]

The first non-negative number is L34 ?????

[Alansidman]

Pictures are of little value as we cannot manipulate data in picture. Please attach a workbook that we can use to test our proposed solutions.

[ArviLaanemets]

Add (hidden) columns into your Named Range with formulas like

ColumnRowNo = ROW()-HeaderRowNo
and
PositCnt=COUNTIFS(ColumnLDatarange,">0",ColumnRowNo,"<=" & [@ColumnRowNo]

To return matching value in column A for 1st occurrence of positive value in olumn L:

=INDEX(ColumnADatarange, SUMIFS(ColumnRowNo,PositCnt,1))

[xor]

=index(a1:a100,match(1,--(l1:l100>0),0))

[p45cal]

I100>=0 perhaps since 0 is also not negative

[tomohawk]

Many thanks for the support everybody.

It's working now