I have a table arranged by columns into SETS of results. I am looking for a way to mark all the columns of a set as false if any one column of the set is false.
Hopefully the attached sheet should make this clear.
I have a table arranged by columns into SETS of results. I am looking for a way to mark all the columns of a set as false if any one column of the set is false.
Hopefully the attached sheet should make this clear.
May be:
In B15 then drag across:
=SUMPRODUCT(($B$12:$U$12=B12)*(--$B$14:$U$14=0))=0
Quang PT
does this do what you want
in B15 put
=IF(COUNTIF($B$14:$U$14,FALSE)>0,FALSE,TRUE)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There is actually a super-easy formula for this.
...Except that, that won't be able to check which "set" your in?Please Login or Register to view this content.
Try this in B16:
And pull across to U16.Please Login or Register to view this content.
We're tricking SUMPRODUCT into adding up booleans (TRUE = 1 and FALSE = 0) where it's both (1) in the set and (2) true in row 14; and then comparing it to how big the set is with the COUNTIFS. If the number of TRUES isn't the same as the count then there are FALSES so it throws FALSE.
...Now that I think about it, you could probably do it with COUNTIFS instead of SUMPRODUCT, also.
Alternatively, in B15 and copy across:
=COUNTIFS($B$12:$U$12,B12,$B$14:$U$14,FALSE)=0
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks