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
No comments:
Post a Comment