Forum Discussion
Mari Elin De Almeida Azevedo
Aug 21, 2017Copper Contributor
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 ...
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
- SergeiBaklanDiamond Contributor
Hi Mari,
In general Advance filtering works correctly with "<>"
- Nigel ApplewhiteCopper 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?