I have a list of countries recorded in Cells from A2 to A1000, some cells have 4 or more countries recorded, and I want to Count certain countries
I have been using this Formula where I have the country that I am looking for entered into Cell C1
=COUNTIF($A$2:$A$100,"*"&C$1&"*")
What it doesn't do is separate those countries with some of the same name like Sudan and South Sudan also North Korea and South Korea
Therefore can any on help with the formula
I have been using this Formula where I have the country that I am looking for entered into Cell C1
=COUNTIF($A$2:$A$100,"*"&C$1&"*")
What it doesn't do is separate those countries with some of the same name like Sudan and South Sudan also North Korea and South Korea
Therefore can any on help with the formula