Counting elements in list (within a cell)
I am working with results from a Google form. The spreadsheet has elements within the cell.user, answer, ...John Doe, "A,B,C,F,G",...Jane Doe, "B,D", ...Richard Roe, "B,G", ... Is there an easy way to count these elements, so a bar plot will show the following ? A: _] 1 B:___] 3C:_] 1D:_] 1E:_] 1F:_] 1G:__] 2
guilhem
vince_faller