I am using Numbers to track data. I have a column that has comma separated values within each row (e.g. ‘I like cats, I hate rain, I like dogs’).
Is it possible to count the number of appearances for a specific phrase (e.g. ‘I like cats’) and report that count in a cell, for each phrase?