Get data for last cell with certain criteria

[robert26]

Hi, my excel friends!

I need formula for B6 column:

If: A6=-1
Value if true: last value from C column that was longer than 5 digits. (in this case value in B6 is C3, in B8 is C7).
Value if false not necessary

Screenshot_146.jpg

[José Augusto]

Hi

Try this in B1 and copy down

=IF(A1=-1,INDEX($C$1:C1,AGGREGATE(14,6,ROW($A$1:$A1)/(LEN($C$1:$C1)>5),1)),"x")

[robert26]

Hi

Try this in B1 and copy down

=IF(A1=-1,INDEX($C$1:C1,AGGREGATE(14,6,ROW($A$1:$A1)/(LEN($C$1:$C1)>5),1)),"x")

thank you solved.