Filter columns in Excel
 

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

--
Message posted from http://www.ExcelForum.com

Filter columns in Excel
 

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.

--
Regards,
Tom Ogilvy

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

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

Any thoughts?


---
Message posted from http://www.ExcelForum.com/

Filter columns in Excel
 

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

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

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

Any thoughts?


---
Message posted from http://www.ExcelForum.com/