Forum Discussion
Solved
Excel Countif function for comma separated data in cells
I have a string of names, separated by commas, in cells within a column. Each string may be different but a specific name may appear in multiple cells. How can I use Countif() to count specific nam...
GAJett Some samples help visitors to understand question correctly. I assume you can use COUNTIFS() with wild card, something like.
=COUNTIFS(A:A,"*harun24hr*")Replace harun24hr with your desired name. If you want to cell reference then use-
=COUNTIFS(A1:A8,"*" & B1 &"*")
