Selecting Window Conditionally
There is an Excel file that teaches how to perform the Selecting Window Conditionally operation.
Excel Template for Selecting Window Conditionally
This workbook demonstrates selecting window conditionally with formulas on a 1-row data layout.
Hope it is useful.