1 min readfrom 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)

submitted by /u/d8gfdu89fdgfdu32432
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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