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     www.energyefficientbuild.com.    Nov 01, 2012
user Bath Light said: (http://productforums.google.com/forum/?zx=gdxpen6jynp#!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