Filtering from left to right?
 

Is it possible to set up a filter for data running across the spreadsheet
from left to right, rather than top to bottom?

Thanks.

Filtering from left to right?
 

Unfortunately, no.

--
Biff
Microsoft Excel MVP


"Jerry" wrote in message
...
Is it possible to set up a filter for data running across the spreadsheet
from left to right, rather than top to bottom?

Thanks.

Filtering from left to right?
 

There is an example he
http://www.atlaspm.com/index.html

Filtering from left to right?
 

One other thought. Maybe you could transpose your table in another sheet,
then just use autofilter as per normal over there.

Your source table is assumed in Sheet1, with top left cell A1
In Sheet2,
In A1:
=OFFSET(Sheet1!$A$1,COLUMNS($A:A)-1,ROWS($1:1)-1)
Copy across/fill down as far as required to transpose the table, hence
availing autofilter's functionality to be applied as per normal. You could
freeze/kill the formulas post transpose.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Jerry" wrote:
Is it possible to set up a filter for data running across the spreadsheet
from left to right, rather than top to bottom?

Thanks.