Sunday, February 12, 2012

yogi_Apply Filter Function Using Multiple Criteria


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com


user ween said:
how to USE multi FILTER?
Hi buddies,
I'd like to have a result for a FILTER formula as in my example in:
https://groups.google.com/a/googleproductforums.com/forum/#!category-topic/docs/spreadsheets/JBs0ZGeADok
I'd like to sort result from a TABLE with severals conditions so that the resultat show me only the lines that match with several criteras
I try to use function Filter but it seems that this function doesn't work. It this possible or not ?
Please try to check if i'm just dreaming or if it's possible ??
regards buddies
Ween
--------------------------------------
following is a solution to the problem