+ Reply to Thread
Results 1 to 8 of 8

Filtering - Not working on ALL rows

  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    Utah, USA
    MS-Off Ver
    2016
    Posts
    5

    Filtering - Not working on ALL rows

    Hi! My filter is not working for the whole table. There are no blank rows in the table. The "Advanced Filter" has something in the "List Range" that I can't get rid of. Can you offer any suggestions?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,647

    Re: Filtering - Not working on ALL rows

    Welcome to the forum.

    Details about how to attach your sample workbook are at the top of the page.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Filtering - Not working on ALL rows

    Hey KW welcome to the forum.

    I'd guess one of the following is happening:

    1. You have text and numbers in the column your trying to sort. Make all values/numbers not text and try to sort again.
    2. You have a space in front of some of the text and it sorts it that way. Use Trim() on the whole column and try to sort again.

    If neither of those is helpful, then we need a workbook sample.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    02-18-2020
    Location
    Utah, USA
    MS-Off Ver
    2016
    Posts
    5

    Re: Filtering - Not working on ALL rows

    Thank you AliGW !

  5. #5
    Registered User
    Join Date
    02-18-2020
    Location
    Utah, USA
    MS-Off Ver
    2016
    Posts
    5

    Re: Filtering - Not working on ALL rows

    OK, I added an attachment so you can see what I'm dealing with. I think it has something to do with "Table Design" because those words come up when I click the cells through row 7 but not afterwords.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-18-2020
    Location
    Utah, USA
    MS-Off Ver
    2016
    Posts
    5

    Re: Filtering - Not working on ALL rows

    Thanks MarvinP !

  7. #7
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Filtering - Not working on ALL rows

    Hi KW,

    It looks like you have defined a table that is only a few rows down. When you use those auto filter dropdowns it only sorts the top few rows. Copy your data using values only and try again. I don't know how you got the top rows to be defined as the table and then added more data below it but that is what it looks like.

    If you look at Formulas -> Names Manager it will show the table only is defined down to row 7. You might try to delete that name and try again, or do like above.
    Sorting Problem.xlsx

  8. #8
    Registered User
    Join Date
    02-18-2020
    Location
    Utah, USA
    MS-Off Ver
    2016
    Posts
    5

    Re: Filtering - Not working on ALL rows

    Thanks MarvinP. I couldn't delete the Names Manager table so I ended up copying and pasting to a new worksheet per your recommendation. Your help is appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Filtering with VBA Not Quite Working
    By Stephen Troughton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2018, 11:50 AM
  2. [SOLVED] VBA filtering working unless February?
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2018, 12:03 PM
  3. (edited title) BUG filtering for blanks (or filtering out all empty rows)
    By zextrot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-22-2017, 01:51 PM
  4. Advanced filtering - wildcards not working.
    By bluphoto in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2014, 11:46 AM
  5. Manual filtering function isn't working
    By esec12 in forum Excel General
    Replies: 12
    Last Post: 08-14-2014, 06:37 PM
  6. [SOLVED] Filtering by Dates not working correctly
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2014, 02:08 AM
  7. Excel freeze when I delete multiple rows (visible rows after filtering)
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2012, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1