• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Can I write an 'or' statement in a pivot filter?

    Worked Great! .....the bold that is. I added a helper column with this formula: =IF(OR(AT2<>"",BA2<>""),"yes","no") so that it would tell me if there was a value in column AT2 or BA2 using a discreet 'yes' or 'no' and it worked as well! :)
  2. C

    Can I write an 'or' statement in a pivot filter?

    Thanks Chandoo--and you are a 'punny' crew aren't you?? I will try the helper column; have learned so much from you; when are you coming to Atlanta?
  3. C

    Can I write an 'or' statement in a pivot filter?

    Disclaimer: I am a self taught novice.... I am trying to determine in a pivot if there is a true statement in any of five columns on a spreadsheet but when I put all five in the filter box it seems to show the data as an "and" statement rather than an "or" statement. Is there any way to...
Back
Top