12 Replies Latest reply on Sep 27, 2018 9:46 PM by Raguprasath Maruthachalam

    Count the specific text in cell

    Raguprasath Maruthachalam

      Hi All,

       

      I have a data in a column where People have mentioned the country name where they have traveled

      Data will be like this

      NameCountries Travelled
      JohnSpain, Russia, Japan, Dubai
      SmithRussia, Germany, France
      DanAustralia,France,Canada
      PaulItaly, Spain, France

       

       

      I want the count for each country in one Table(see below). How can I do that?

       

      CountryCount
      Spain20
      Russia17
      France25
      Germany10