Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));1))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));2))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));3))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));4))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));5))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));6))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));7))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));8))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));9))&", ";"")&
- IFERROR(INDEX(TableSYREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableSYREQ[Trace Parents]));ROW(TableSYREQ[Trace Parents])-ROW(TableSYREQ[[#Headers];[Trace Parents]]));10))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));1))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));2))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));3))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));4))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));5))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));6))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));7))&", ";"")&
- IFERROR(INDEX(TableMCREQ[Index];SMALL(IF(ISNUMBER(SEARCH([@Index];TableMCREQ[Trace Parents]));ROW(TableMCREQ[Trace Parents])-ROW(TableMCREQ[[#Headers];[Trace Parents]]));8))&", ";"")
Add Comment
Please, Sign In to add comment
