Filter by Row?

[Robert Hatcher]

I am working with a somewhat convoluted workbook of personnel
records. The Personnel are listed by columns and the categories are
by row. I’m having trouble filtering and I believe it is because of
the data arrangement. Often I need to filter on different categories.
For example “Position/Title” so that I can look at all of a particular
type of employee. When filtering is enabled, the selection arrows are
only available on the column headings, not the row headings. Is there
a way to get around this limitation? Unfortunately I cannot change
the orientation of the data.

Thanks
Robert

 

[Gord Dibben]

Excel does not have a filter across a row function.

What prevents you from transposing the data to the other orientation?

If transposing is defintely out I would suggest VBA to hide columns which do not
meet "Position/Title" criteria.


Gord Dibben MS Excel MVP