I have a spreadsheet with a column with repeating number of different kinds of words like
A1 A2 A3 A1 AA A2 A7 A8 A1
Now I want to plot a graph showing the frequency of occurrences of a word. The words are different but the re-occur quite often. Just using the countif is not helpful because then I have to manually specify the criteria of each word in the formula. Since the number of words are large, I want the words to be each auto-filled in the criteria. Can someone suggest a formula for this?