Assistance With Excel Formula

tomohawk · #1 08-03-2025, 11:24 AM

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 · #2 08-03-2025, 12:35 PM

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

Alansidman · #3 08-03-2025, 05:17 PM

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 · #4 08-03-2025, 10:50 PM

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

Code:

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:

Code:

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

xor · #5 08-03-2025, 10:54 PM

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

p45cal · #6 08-04-2025, 12:13 AM

I100>=0 perhaps since 0 is also not negative

tomohawk · #7 08-04-2025, 02:17 AM

Many thanks for the support everybody.

It's working now

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assistance with formula please	MsMagnolia	Excel	3	03-31-2022 02:28 PM
Formula Assistance Required	mfolland	Excel	1	04-16-2019 05:21 PM
Need assistance with multiple IF argument formula	Btrrcup610	Excel	1	02-25-2016 11:14 AM
Assistance with Word 2010 If formula	ciresuark	Word	1	03-09-2015 12:57 PM
Formula assistance please	blazzercat	Excel	2	07-08-2009 08:45 AM