Share via

Excel Filter Range not Extending

Anonymous
2021-01-03T07:52:08+00:00

Hello,

I have a project management worksheet keeping track of all ongoing/past projects.

It has various columns and it has filters. However the filter range is up to 34 rows only. beyond that it does not filter. Please see below:

Above is filtered list for Customer "Ghate" and it does not filter beyond rows 34 as highlighted in above image.

I have tried doing many changes in the List range/criteria range. Current advanced filter range is:

Now this list range is way beyond the 34 rows mark but it still is not filtering beyond that.

Can anyone let me know what do I need to change?

I have tried experimenting with criteria range as well, putting whole list range in that etc. but still it doesn't work.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Lee Teck Koon 3,170 Reputation points Independent Advisor
    2021-01-04T07:06:33+00:00

    Hi,

    Please check your file in onedrive . updated.

    Please convert your table to range & apply filters to row 6.

    1 person found this answer helpful.
    0 comments

17 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2021-01-04T04:54:52+00:00

    Hi,

    Share the link from where i can download your workbook.

    0 comments
  2. Anonymous
    2021-01-04T05:27:35+00:00

    Hi,

    Share the link from where i can download your workbook.

    -Link Removed-

    I have removed some details from sheet. Please suggest what to do to fix so I can fix that in my main workbook.

    @Lee Tech Koon

    Please download from above link.

    Thank you!

    0 comments
  3. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2021-01-04T05:40:56+00:00

    Hi,

    Your List and criteria range should have their own set of headings.  See the snapshot.

    Hope this helps.

    0 comments
  4. Anonymous
    2021-01-04T07:24:51+00:00

    Hi,

    Your List and criteria range should have their own set of headings.  See the snapshot.

    Hope this helps.

    Image

    So I have to add all the customer names, Status list again as separate in top row? We have large number of customers that would eat up lot of space.

    That would look rather confusing and cluttering and also it does not answer the main problem that why the filter is only working till 34 rows and not beyond that. Because at current state, there are no separate criteria rows as you have shown and filter still works till rows till 34.

    Thanks for your response.

    0 comments