In column A, "1234" appears 5 different times. In the adjacent column B, there are 4 instances of "True" but 1 instance of "False."
I only want to return the value from column A (once) if all instances are equal to "True.' So in the example above, "1234" would not be returned. Only the ones in green should be returned and only once not multiple times.
Is there a VBA or formula I can use to accomplish this?
I only want to return the value from column A (once) if all instances are equal to "True.' So in the example above, "1234" would not be returned. Only the ones in green should be returned and only once not multiple times.
Is there a VBA or formula I can use to accomplish this?