Filter by column

  • So I would like to filter by column


    abc inc A B C D
    -----------------------
    info line - 0 0 0 0
    info line - 0 0 0 0
    info line - 0 0 0 0
    -----------------------
    totals - # # # #


    Where I would filter to A and B,C,D would hide.
    Once before somehow I used the Validation feature to this but that was years ago. Dont know if that will help.
    Your help appreciated!

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Filter by column


    if you transposed your data like this
    info line info line info line
    A
    B
    C
    D


    you would make your life easier, and be able to use auto filters, which would do what you ask.


    you dont have to retype all data, just "copy" >"Paste Special" and tick the transpose box

  • Re: Filter by column


    That is actually how the data originally stored, the "boss man" had me transpose it for printing purposes. I would perfer it the other way, easier to manage. Since of course I "the little man" do all the printing I am trying to make my life easier.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Filter by column


    Easy solution, thanks. Now I know the column filter has been done before somehow using the validation feature, if anyone knows I would appreciate it, although I am no longer in a rush for it.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!