Results 1 to 8 of 8

Thread: Filter issues
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2018
    Posts
    154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Filter issues

    Hi,

    My filter does not work properly. It just displays a minor portion of all values in the column. I have no blank rows in the table array.

    How do I solve this?

  2. #2
    Board Regular
    Join Date
    Jun 2018
    Posts
    154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter issues

    Bumping this thread, any suggestions? Have not managed to make it work yet.

  3. #3
    Board Regular
    Join Date
    Jul 2013
    Location
    Essex, UK
    Posts
    115
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter issues

    I suggest you read the Guidelines here which offer advice on the sort of information you need to give in order to explain your problem clearly.

    Helping you to Excel

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,513
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Filter issues

    You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
    Regards Dante Amor

  5. #5
    Board Regular
    Join Date
    Jun 2018
    Posts
    154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter issues

    I managed to solve it! I had some hidden columns. Though I am facing a new similar issue in another file which I can not seem to solve. See screenshot:
    https://imgur.com/t6KR8tw

    All cells in the table range have values. No hidden or empty columns or row. I filtered a number of projects from the table, then sorted them in ascending order. Not sure if all but a lot of numbers then appeared in in the wrong row and context. The most f*cked up thing about this f*cking issue is the whole table and data gets messed up and I can not restore it unless I do ctrl+z, which does not work when I have worked for a while until noticing things are incorrect. Really disturbing, so I need to re-do the whole thing. Please help!

  6. #6
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,513
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Filter issues

    Quote Originally Posted by Cameltoe View Post
    I managed to solve it! I had some hidden columns. Though I am facing a new similar issue in another file which I can not seem to solve. See screenshot:
    https://imgur.com/t6KR8tw

    All cells in the table range have values. No hidden or empty columns or row. I filtered a number of projects from the table, then sorted them in ascending order. Not sure if all but a lot of numbers then appeared in in the wrong row and context. The most f*cked up thing about this f*cking issue is the whole table and data gets messed up and I can not restore it unless I do ctrl+z, which does not work when I have worked for a while until noticing things are incorrect. Really disturbing, so I need to re-do the whole thing. Please help!

    If you first filter and then order, then the rows are rearranged.
    The suggestions that you first order and then perform the filter.
    Regards Dante Amor

  7. #7
    Board Regular
    Join Date
    Jun 2018
    Posts
    154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter issues

    Thank you man for response! At least are there any ways to sort data correct without ctrl+z if you by mistake filter first and then order?

  8. #8
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,513
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    12 Thread(s)

    Default Re: Filter issues

    Quote Originally Posted by Cameltoe View Post
    Thank you man for response! At least are there any ways to sort data correct without ctrl+z if you by mistake filter first and then order?
    As you well know, machines do what you do. They do not know if your procedure was correct or wrong.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •