2
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
{=INDEX(User1!Tags,MATCH(0,COUNTIF($A$1:A1,User1!Tags),0))}
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?
This would work, but I would need a column for every unique tag, right? So far there are 47 unique tags, and that number will increase as users add more entries. Can the process of column adding be automated? – rcrdcsnv – 2013-04-01T20:11:28.230
I am not sure that you can do this without macros and i just started to use them so i can not provide you with a solution – rexxar – 2013-04-02T06:33:03.073