7 Replies Latest reply on Jul 10, 2013 12:34 AM by kettan

    How to sum unique words in string

    Charles Flook

      So i know i may not have the best title, however i'm not sure how to accurately define what i am looknig for.

       

      Basically i have string data in a column and want to be able to show a chart based off of that string data. Example:

       

      Column A (String)
      A; B; C
      A
      A; B
      A; C
      D
      E
      A; D; C

       

      The chart would be based off of count, and of each letter, so a bar for A with a count of 5, bar for B with count of 2, etc. What is the best way of making this chart? Currently the data is in excel and the excel links to another database that is updated, so the data is dynamic.