Spreadsheet: 271111d1381827723-help-with-a-formula-to-find-the-nth-occurrence-nth-occurrence-example3
Sheet: Example 2

Bull Trend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WHAT I NEED!
# | # | Date | Time | Open | High | Low | Close | Vol | Mark | P/L | A | B | C | D | E | F | G | H | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1st Instance Were All of the "Z"s Are True | 2nd Instance | 3rd Instance | 4th Instance | 5th Instance
3884 | 41 | 2001-01-02 00:00:00 | 00:45:00 | 0.9455 | 0.9468 | 0.9452 | 0.9458 | 60 | X | Loss | True | False | True | True | False | True | False | False
7233 | 76 | 2001-02-19 00:00:00 | 22:00:00 | 0.924 | 0.924 | 0.9232 | 0.9235 | 60 | Y | Break Even | True | False | False | False | True | True | True | False
10235 | 107 | 2001-04-04 00:00:00 | 04:30:00 | 0.9009 | 0.9028 | 0.9004 | 0.9022 | 60 | Z | Profit | True | False | True | True | False | True | True | True |  |  |  |  |  |  |  |  | C | D | F | G | H
13194 | 138 | 2001-05-17 00:00:00 | 00:15:00 | 0.8843 | 0.8863 | 0.8839 | 0.8862 | 60 | X | Loss | True | False | True | True | False | False | False | False
15225 | 159 | 2001-06-15 00:00:00 | 04:00:00 | 0.866 | 0.8671 | 0.8654 | 0.8664 | 60 | X | Loss | True | False | False | True | False | True | True | False
27792 | 290 | 2001-12-17 00:00:00 | 01:45:00 | 0.9039 | 0.9067 | 0.9036 | 0.9061 | 60 | Z | Profit | True | False | True | True | False | True | True | True |  |  |  |  |  |  |  |  | C | D | F | G | H
31609 | 330 | 2002-02-12 00:00:00 | 00:00:00 | 0.8777 | 0.8792 | 0.8775 | 0.8782 | 60 | Z | Profit | True | False | True | True | False | True | True | True |  |  |  |  |  |  |  |  | C | D | F | G | H
36601 | 382 | 2002-04-25 00:00:00 | 00:00:00 | 0.8936 | 0.8945 | 0.8926 | 0.8943 | 60 | Z | Profit | True | False | True | True | False | True | True | True |  |  |  |  |  |  |  |  | C | D | F | G | H
38914 | 406 | 2002-05-29 00:00:00 | 02:15:00 | 0.9292 | 0.9311 | 0.9292 | 0.9306 | 60 | Z | Profit | False | True | True | True | False | True | True | True |  |  |  |  |  |  |  |  | C | D | F | G | H
39025 | 407 | 2002-05-30 00:00:00 | 06:00:00 | 0.9377 | 0.9385 | 0.9371 | 0.9382 | 60 | Z | Profit | True | False | True | True | False | True | True | True |  |  |  |  |  |  |  |  | C | D | F | G | H
51793 | 540 | 2002-12-03 00:00:00 | 06:00:00 | 0.9967 | 0.9993 | 0.9964 | 0.999 | 60 | X | Loss | False | True | False | True | False | True | True | False
 |  |  |  |  |  |  |  |  |  |  |  |  | ALL TRUE Z'S | ALL TRUE Z'S |  | ALL TRUE Z'S | ALL TRUE Z'S | ALL TRUE Z'S |  |  |  |  |  |  |  |  | I need a formula hear that finds the 1st, 2nd, 3rd, etc instances were the rows that contain X's in column "J" are true with the result being the column heading.
1.) Column "J" titled "[NAME]" contians X,Y,Z's. Columns "L, N, P, R, T, V, X, and Z" contain true of false values.
Column "AB" would be the first column that would contain formulas looking for the desired result.
Desired Result
I need a formula that finds all of the rows with Z's in column J. It would then check columns "L, N, P, R, T, V, X, and Z" to see if all of the rows containing Z were true, if so the result would be the column heading of the column.
Requirements
The row in column "J" contains a Z in it's cell
All of the cells containing Z are true in either columns "L, N, P, R, T, V, X, or Z"
The formulas in "AB, AD, AF, AH, and AJ" look for the next instance were all Z's a true.
Example
Column "J" contains 6 cells that have Z's in them.
Column "P" is the first column were all six Z's from coulmn "J" are true, so the result for the formula in column "AB" would be the heading of column "P" which is the letter C.
Column "R" is the second instance were all six Z's from column "J" are true, so the result for the formula in column "AD" would be the heading of column "R" which is the letter D.
This process of seeking all true values would continue for a until all of the columns contain true/false values were checked by the forumla.
Thank you again for taking the time to review my spreadsheet and assisting me with creating a formula that provides me with my desired result.