Sunday, February 12, 2012

yogi_Apply Filter Function Using Multiple Criteria

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

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:!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
following is a solution to the problem