Side Filter
in [Programming]
|
Prev: Change Data Connection Definitions from local to sharepoint
Next: Upload file to SharePoint from machine with CAC
From: Sudipta Sen on 26 Feb 2010 06:14 Want to filter data columnwise i.e from Column A1 With Rdgs. Sudipta
From: joel on 26 Feb 2010 06:36 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/showthread.php?t=182901 [url="http://www.thecodecage.com"]Microsoft Office Help[/url]
From: Mike H on 26 Feb 2010 06:40 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
From: Paul Robinson on 26 Feb 2010 08:57
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 <Sudipta...(a)discussions.microsoft.com> wrote: > Want to filter data columnwise > i.e from Column A1 > > With Rdgs. > Sudipta |