y n y n y
y n y y y
y n y y n
I have a table with 5 columns; A,B,C,D & E. In each cell are Y (yes) or N (no). I need an IF formula to flag up "WIN" when there are 3 or more Y's in a row and "LOSE" when there are 2 or less Y's in a row. Thanks for any help you can provide.