I wish to count the number of times a piece of text appears in a column. I only want to display that number on a chart. I've tried the following:
FIND("Text", [Book Name])
"Text" is the text I am looking for, [Book Name] is the name of the column to search.
It does produce a good return but when I display it on a chart, it also shows the number of times it didn't appear. I only want to show the times it did appear. Is there a way to filter out the number of times it doesn't find the text so it doesn't appear. Thank you.
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |