Using a text filter in a pivot table

Question

Hi, I'm trying to perform some analysis on a huge chunk of data - most I can achieve using pivot tables - the last piece however requires me to look at cell vales and count if a particlar word appears in the text.

This is easy from a table view - I can just use text filter "contains" = the word, however I can't see how to do it in a pivot table - if I can at all!!!

Thanks

Dave

Answer 1

Here is one way...Looking for 'word' in cell H1

=--NOT(ISERROR(SEARCH("word", H1)))

---

If this post answers your question, please mark it as the Answer... Jim Thomlinson

Answer 2

thanks Jim - helper column?

How do I express:

If H1 contains "word",1 else 0

Answer 3

You need a helper column in your source data that calculates the existence of the word. Have it return 1 or 0 and then just sum the helper column in your pivot.

---

If this post answers your question, please mark it as the Answer... Jim Thomlinson