Hello, would anyone be able to assist with an Array formula I'm working on where I'm looking to have it return only the cell in a row matching my criteria. The data starts in row 9 and row 8 is the header.
I have a table with duration values in column Y with the criteria in cell Z3. This formula currently returns the correct column but the criteria part isn't working correctly. If I remove that part and keep the rest as:
Then it starts populating with the first row.
thank you for any help!
Code:
{=IFERROR(INDEX(Data!$Y$9:$Y$561,SMALL(IF(Data!$Y$9:$Y$561>=Data!$Z$3,ROW(Data!$C$9:$C$561)-ROW(Data!D$9)),ROWS(Data!Y$9:Data!Y10))),"")}
I have a table with duration values in column Y with the criteria in cell Z3. This formula currently returns the correct column but the criteria part isn't working correctly. If I remove that part and keep the rest as:
Code:
{=IFERROR(INDEX(Data!$C$9:$C$561,SMALL(IF(Data!$Y$9:$Y$561,ROW(Data!$C$9:$C$561)-ROW(Data!C$9)),ROWS(Data!C$9:Data!C10))),"")}
Then it starts populating with the first row.
thank you for any help!