Forum Discussion

Mari Elin De Almeida Azevedo's avatar
Aug 21, 2017

Advanced filter

Good afternoon, I work with
many spreadsheets and many filters ... has done advanced filtering but when I use the <> sign it's like If it made no difference ... I was doing something wrong, because I need to do the filter type "different operation status" ... But using the signal <> n will ... I have put several ways in the right ... since I'm thankful already ...

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Mari,

     

    In general Advance filtering works correctly with "<>"

     

     

    • Nigel Applewhite's avatar
      Nigel Applewhite
      Copper Contributor

      I need help with a complex EXcel filtering probem that I have.

      I deal with data with numerous combinations of results and I want to avoid hard coding.

      how would I write formulas in excel to do this?

Resources