Thursday, May 17, 2012

yogi_Filter A Range For Specified Entity And Display All Records If No Entity Is Specified


Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #544    May 17, 2012     www.energyefficientbuild.com.

user Spirtax said:
filter if
Hello
how can i use filter column if variable is passed and if not use others filter parameters. if none filter variable passed show all results.
i can't figure out the right syntax for that.
-----------------------------------------------------------------------------------
following is a solution to the problem

No comments:

Post a Comment