Spreadsheet: 271076d1381810400-help-with-a-formula-to-find-the-nth-occurrence-nth-occurrence-example2
Sheet: Example 2

Bull Trend
# | # | 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 "X"s Are True | 2nd Instance | 3rd Instance | 4th Instance | 5th Instance | 6th Instance | 7th Instance | 1st Instance Were All of the "X"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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | F | G | H
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | F | G | H
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | F | G | H
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | F | G | H
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | F | G | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above used the same formula as per your 1st Example.
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.