INDEX | filtering the data horizontally and vertically
INDEX | filtering the data horizontally and vertically
When we set the column to zero, the whole chosen row in the selected range appears.
the selected range appears.
And if we set the row to zero, the whole chosen column appears.
We could use this feature to filter the data horizontally and vertically.