Spreadsheet: 270848d1381709481-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 |  | 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 | <---The formula would skip this column because "J11", which contains a Z, is false | False | <--- Multiple rows are false so the formula would skip this column as well | True | <--- This is the 1st column that meets all of the requirements, so the result in "AB" would be the row heading of "C" | True | <--- This is the 2nd column that meets all of the requirements, so the result in "AD" would be the row heading of "D" | False | <--- All rows are false so the formula would skip this column as well | True | <--- This is the 3rd column that meets all of the requirements, so the result in "AF" would be the row heading of "F" | False | <--- This is the 4th column that meets all of the requirements, so the result in "AH" would be the row heading of "G" | False | <--- This is the 2nd column that meets all of the requirements, so the result in "AJ" would be the row heading of "H" | C | <---- This is what the final result should be, the 1st instance where all of the Z's in column J are true | D | <---- This is what the final result should be, the 2nd instance where all of the Z's in column J are true | F | <---- This is what the final result should be, the 3rd instance where all of the Z's in column J are true | G | <---- This is what the final result should be, the 4th instance where all of the Z's in column J are true | H | <---- This is what the final result should be, the 5th instance where all of the Z's in column J are true
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
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.