I have 'Name' subsets in col A. If I want to find the first 'Back' value from the bottom of subset '1. Target Satin', I can use :
=INDEX(B2:B26,SUMPRODUCT(MAX(ROW(A2:A26)*(E2=A2:A26))-1))
in cells F2, F3 I want to add a condition to this and only return the first 'Back' value from the bottom of each subset that doesn't equal 0 in col C