14 Replies Latest reply on Mar 23, 2016 5:37 PM by Chris Gadd

    Any way to create text filters similar to excel?




      Problem:  The data in the column that I wanted to filter on contains different data points (fund names) that are essentially a concatenated string.  Excel can get around this by using a text filter and searching for a particular string.


      I.E.: Two separate funds (one named AA, the other named BB) both are in the same cell as "AA;BB"


      Example Data:



      Fund NameProperty Name
      AA;#BBProperty 2
      DD;#AA;#CCProperty 23
      CC;#AAProperty 17
      CC;#DDProperty 21


      It would be nice if I could have a regular quick filter that if filtered on "AA" it would return:


      Property 2

      Property 23

      Property 17


      I have attached a sample workbook as well for reference.