Assistance With Excel Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Assistance With Excel Formula

08-03-2025, 10:50 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

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))

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 AM.