Side Filter
Want to filter data columnwise
i.e from Column A1 With Rdgs. Sudipta |
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 |
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 |
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