Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Horizontal filter

How can I filter some columns with filter?

(I don't work with the transpose)
I want work with a type of "horizontal filter" if exist.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default Horizontal filter

There is not exactly such a function in Excel. There are only 256 columns in
Excel, so I think the general Excel users will find the "traditional"
direction of filters more value-adding.

But for you case, in fact, Excel has a powerful "Pivot Table" function,
which can be used to summarize almost any type of data in a logical manner.
Try exploring that!

Regards,
Edwin Tam

http://www.vonixx.com




"Wallace" wrote:

How can I filter some columns with filter?

(I don't work with the transpose)
I want work with a type of "horizontal filter" if exist.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Horizontal FILTER!! Maniv Excel Worksheet Functions 4 September 19th 12 08:39 AM
Filter PivotTable dropdown items to match report filter Catherine D Excel Discussion (Misc queries) 1 August 16th 08 12:12 AM
Copy only visible cells after filter is applied/ sum after filter MAM Excel Worksheet Functions 0 April 9th 08 04:09 AM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM
How to set multiple filter values for a filter in the page fields Simon Lenn Excel Programming 1 December 29th 03 09:35 PM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"