Hi, any one help horizontal filter in excel
GraH - Guido Well-Known Member Jan 15, 2020 #3 As filters do not apply on columns but on rows, one can transpose the range/table and then filter on first column.
As filters do not apply on columns but on rows, one can transpose the range/table and then filter on first column.
P Peter Bartholomew Well-Known Member Jan 16, 2020 #4 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.
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.