•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Shorter notation for or in filter when using the same column
=filter(A:A,(A:A<>1) + (A:A<>2) + (A:A<>3))
Is there a shorter way of typing this like
=filter(A:A,A:A<>1|2|3)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#natural language processing for spreadsheets
#generative AI for data analysis
#filter
#A:A
#excel
#Excel functions
#shorter notation
#or
#shorter way
#data filtering
#notation
#logical operators
#column
#conditions
#inequalities
#expression
#range