Hello,
I just signed up and I need some help with a formula i'm trying to create with a large table.
It is laid out like so:
The Customer Name column will have many duplicate values, because the middle columns have different values. The "Outcome" column will be either 'TRUE' or 'FALSE' for each difference "web address" in the table.Please Login or Register to view this content.
What I want to do is check if unique "Customer Name" has any 'TRUE' values in the "Outcome" column and make a count.
This way it's not counting how many 'TRUE' there is for each customer and summing them up, but giving a BOOLEAN statement of 'TRUE' if ANY "Outcome" Column value is TRUE for any UNIQUE Customer name.
Example:
The total would be "2" because there are two unique "Customer Name" that have "Outcome" TRUE.Please Login or Register to view this content.
I could convert the Outcome column to 1/0 instead of T/F if that makes this more possible by working with integers instead of string or bool values.
Bookmarks