Friday, November 2, 2012

yogi_Workaround For A Wildcard In Use With FILTER Function Using FILTER OR QUERY

                                           Google Spreadsheet   Post  #847
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Nov 01, 2012
user Bath Light said: (!category-topic/docs/spreadsheets/LQ5UihETyoI)
Filter wild card to filter to different sheet 
Mac OS 10.6 and Chrome

=Filter( 'Master'!A:J ; 'Master'!C:C="BY-Cavern")

What I need to do is replace Cavern with a wild card so I get everything in the BY category.

Anyone have an Idea how I do this?
FILTER function does not support use of a WildCard int it ... following is a Workaround solution to the problem