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

Our take

Are you tired of lengthy formulas cluttering your spreadsheets? If you’re using the filter function to exclude multiple values from the same column, there’s a more efficient way to express it. Instead of writing out each condition separately, you can simplify your formula for better clarity and speed. Discover how to streamline your approach with a shorter notation that enhances readability while maintaining functionality. Keep reading to learn this time-saving technique that will transform your spreadsheet experience.

=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]

Read on the original site

Open the publisher's page for the full experience

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