ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Side Filter (https://www.excelbanter.com/excel-programming/440006-side-filter.html)

Sudipta Sen[_2_]

Side Filter
 
Want to filter data columnwise
i.e from Column A1

With Rdgs.
Sudipta

joel[_727_]

Side Filter
 

You can't filter rows. You can transpose your worksheet using
pastespecial to switch rows and columns. There is no problems doing
this with 2007 but witth 2003 you are limited to 256 columns. so if
your original worksheet has less than 256 row with 2003 you can tranpose
the sheett, otherwise, you can't.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=182901

Microsoft Office Help


Mike H

Side Filter
 
Hi,

There's no inbuilt way of doing that but you could try this method

http://blog.livedoor.jp/andrewe/archives/50283818.html
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sudipta Sen" wrote:

Want to filter data columnwise
i.e from Column A1

With Rdgs.
Sudipta


Paul Robinson

Side Filter
 
Hi
Pivot Tables can be viewed as a horizontal filter. They are easy to
set up - see the help.
regards
Paul

On Feb 26, 11:14*am, Sudipta Sen
wrote:
Want to filter data columnwise
i.e from Column A1

With Rdgs.
Sudipta




All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com