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