Filtering from left to right?

J

Jerry

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

Thanks.
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

spreadsheet filter alerts 1
auto filter on columns 2
Data Filter 3
FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED 2
Lookup Across Multiple Rows / Columns 5
using autofilter data 2
How to filter merged cells to get more than the first row 1
Filtering Using Values In A Specific Cell 3

Top