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

2 comments:

  1. This formula doesn't work ;)
    i try it many times and i have a parse error
    can you check it or should i share the document with you if you have gmail account

    regards

    ween

    ReplyDelete
  2. Hi ween:

    Please share the document so any one with link can view and edit, and post the url here and in Google Docs Help forum.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete