Filter columns in Excel

P

parenson

Is it possible to filter columns in Excel rather than filter rows? Whe
you do an AutoFilter and select a value in a column, Excel will filte
out the rows that do not match the selected filter criteria. I need t
turn this 90 degrees and specify a value in a row and then have th
columns filtered out accordingly.

I have attempted transposing my spreadsheet to turn columns into row
and rows into columns, but this screws up the formatting.

Any thoughts
 
T

Tom Ogilvy

there are no filters that work that way.

You could probably write code that hides columns based on some criteria you
pass to the code.
 
A

Alan Beban

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=ArrayColumnFilter(dataRange, filter_row, filter_value)

array entered into a range of sufficient size to accommodate the
filtered data, will do what you describe. The function returns as an
array the filtered data; if called from the worksheet, it returns that
data to the selected range into which the formula is array entered.

Alan Beban
 
Top