Then in that same empty column create a HOLD KEY index. Use this formula in Z2 and copy down:

=IF(OR(ISNUMBER(SEARCH("HOLD", E2:O2))), N(Z1) + 1, N(Z1))


Now you have a unique list of index numbers going down that column.

On a separate sheet you can collect the first instance of each key.

Column A:
KEY
1
2
3
4
5
6
etc....

In column B, at B2, then copied down:

=IF(ISNUMBER(MATCH(A2, Sheet1!$Z:$Z, 0)), INDEX(Sheet1!$A:$A, MATCH(A2, Sheet1!$Z:$Z,0)), "")

This presumes the information you want to list is in column A.