Forum Discussion

Copper Contributor

Nov 16, 2022

Solved

Identify position of last positive value in range from positive values in a row

Hi, I am looking for a way to identify every position of a value which is the last positive value in a row. As an example below, I want to identify which row the yellow cell. The output in C2:C4 ...

excel

Formulas and Functions

OliverScheurich
Nov 16, 2022
mlylyly
=LET(u,A2:A11,FILTER(ROW(u)-1,(u>0)*(OFFSET(u,1,0)<=0)))
You can try this LET formula.

Patrick2788

Silver Contributor

Nov 16, 2022

mlylyly

Try this one:

=LET(values,A2:A11,f,FILTER(ROW(values),values>0),SORT(LARGE(f,SEQUENCE(4))))