Dear SVS, Good Afternoon.
The result 4 is CORRECT!
But if you can received a different result you must change the logic process.
Try to search for
"Competency"
"Capability"
"Capability & Competency" (the text must be equal at cells)
Tell me if it worked for you.
-----------------------------------------------------------------------
Quote:
Originally Posted by SVS
I have a column which can contain text as below :
Competency
Capability
Capability & Competency
I want to count all the cells which contains either competency / capability or both .
The count of the above should be 3 and not 4 .
If we do 2 separate count if and add it will give 4 but what i need it to count is only 3 . ( i.e no of unique rows which has any one of this input ) .
Can anyone help me how to do this .
|