Filtering from left to right?

  • Thread starter Thread starter Jerry
  • Start date Start date
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.
 
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
 
Back
Top