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

user Spirtax said:
filter if
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