• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

filter

As filters do not apply on columns but on rows, one can transpose the range/table and then filter on first column.
 
In dynamic array versions of Excel, the FILTER function has a parameter that allows horizontal filtering.
This is not just hiding unwanted values; it creates new arrays with the unwanted data removed.
 
Back
Top