I have an excel spreadsheet with a list of seminars and classes that students have taken that (when abridged) looks like:
(A)___ClassName________|(B)_________Tags____________| Astrobiology | astro, bio, sci | Extremophiles | chem, bio, sci | Human Space Habitation | astro, bio, med, engi, sci | etc.
I would like to be able to extract individual tags from this and get an associated count for each tag on another sheet, such that for the above:
__Tag__|_Frequency_| astro | 2 | bio | 3 | sci | 3 | chem | 1 | etc.
I have been trying to do this only using functions, and I can get a unique list of tag strings (eg. "astro, bio, sci") using
but I haven't been able to successfully extract the tags themselves. I would like to keep the file "macro warning"-less, if possible, but I am new to excel, so if I'm going about this the wrong way please let me know!
Is this possible?