How can I count number of cells in a column that contains partial text
enter image description here
I want the result to become 6 since text AB (A and B) can be found from all those rows except Row 4 that has only C in it.
I want the result to become 6 since text AB (A and B) can be found from all those rows except Row 4 that has only C in it.
New contributor
Harvey Oyzon is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.