Hello,
I'm not sure if this is the best forum to post in, but it seemed to be the best choice.
I am working on a project and trying to count how often certain words occur in cells. Right now I have something like
Monday
Monday
Monday
Tuesday
Tuesday
I would like to have this expressed as Monday: 3 Tuesday: 2
If the values were numbers, I could easily use the frequency function, however it doesn't seem to be able to search text. Is there another function I could use or a way around this?
I'm not sure if this is the best forum to post in, but it seemed to be the best choice.
I am working on a project and trying to count how often certain words occur in cells. Right now I have something like
Monday
Monday
Monday
Tuesday
Tuesday
I would like to have this expressed as Monday: 3 Tuesday: 2
If the values were numbers, I could easily use the frequency function, however it doesn't seem to be able to search text. Is there another function I could use or a way around this?
