ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column filter (https://www.excelbanter.com/excel-discussion-misc-queries/252071-column-filter.html)

Sudipta Sen[_2_]

column filter
 
I want filter column, means all headings are in coumn A1: A20 and Datas are
in column B1:D20, Now I want to filter the the datas from left to right
according to heading typed in column A1 to A20.

Is it possible, if yes, how?

Rdgs... Sudipta

Dave Peterson

column filter
 
Excel doesn't have an equivalent data|filter|autofilter for columns.

But you may be able to do what you want using data|group|group and outline (in
xl2003 menus).

It's not the same, but it may sufficient for you.

Sudipta Sen wrote:

I want filter column, means all headings are in coumn A1: A20 and Datas are
in column B1:D20, Now I want to filter the the datas from left to right
according to heading typed in column A1 to A20.

Is it possible, if yes, how?

Rdgs... Sudipta


--

Dave Peterson


All times are GMT +1. The time now is 04:11 PM.

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