I am in need of counting distinct text values within a column where the 2nd column is equal to a value.
Example:
ColA has values such as Jan, Feb, Mar, etc
ColB has values such as FGG1212, GGF2233, etc
ColB will have repeating values. I need to count ColB where ColA equals "Jan", but they have to be unique values.
Can someone assist me with this?
Example:
ColA has values such as Jan, Feb, Mar, etc
ColB has values such as FGG1212, GGF2233, etc
ColB will have repeating values. I need to count ColB where ColA equals "Jan", but they have to be unique values.
Can someone assist me with this?