As I showed and as DO mentioned: adjust the cell references.Notice in B6 and B7 the formula returns "No", when, in fact, the four consecutive "N"egative results are in K6:N6 and J7:M7.
It must be $G$6:$S$6 ( not $Z$6 )
As I showed and as DO mentioned: adjust the cell references.Notice in B6 and B7 the formula returns "No", when, in fact, the four consecutive "N"egative results are in K6:N6 and J7:M7.
It must be $G$6:$S$6 ( not $Z$6 )
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks