If all values are true for an option then return true else false

[simpleminded]

Hi everyone,

I am kind of stuck in this problem need your advise:

I have data that looks like this:

Option	Value
OPTION A	TRUE
OPTION A	TRUE
OPTION A	FALSE
OPTION B	TRUE
OPTION B	TRUE
OPTION C	FALSE
OPTION C	FALSE
OPTION C	FALSE
OPTION C	FALSE
OPTION C	FALSE

And I am looking for output like this

Option	Value
OPTION A	FALSE
OPTION B	TRUE
OPTION C	FALSE

Basically if all values for a particular option are True then set the value as true and if any value for a particular option is false set value as false and each option should have just 1 entry.

Thank you in anticipation of your advise. 

[michael_treadwell · Accepted solution]

Try taking a Count of True by Option and a Count by Option and testing their equality.

See the attached example.

[MarqueeCrew · Accepted solution]

If you use the SUMMARIZE tool and the MIN function, you will get FALSE if it ever is and TRUE otherwise.

Thanks,
Mark

[michael_treadwell]

@MarqueeCrew wins

[MarqueeCrew]

It was a photo finish @michael_treadwell  you can use the Racer X image and we can team together!