Jun 11 2021 07:41 PM
Jun 11 2021 09:57 PM
@Mel4342 See picture below. No need to test for W1 and X1 both being equal to 1. Either one will do to return "Yes".
Entered the formula in Y1 and copied it down.
Jun 12 2021 01:11 AM
I use Excel 365 so, naturally, wanted the result as a spilt array in preference to copying formulas.