View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.