Advanced Filter not producing the desired result

Hello,

I am using Advanced Filter to filter a list. See the screenshot enclosed.

The correct filter result here would be the yellow cells (rows 6 to 10).

However, the filter result only shows rows 7 to 10.

Any idea what I am doing wrong here ?

Thanks.

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Does this when I click on OK in the advanced filter dialog (Excel 365):

Excel 2016 (Windows) 32 bit

	A	B
4	Code	Description
7	060002BB	article 3
8	060003	article 4
9	060005	article 5
10	060006	article 6

Sheet: Sheet1

It's to do with the fact that these are text values, and not number values, I think.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Right, well:

1. Share the cross-post link as instructed (unless you wish to incur a further infraction).
2. Share the solution.
3. READ THE FORUM RULES to which you agreed when you joined, and therefore about which you should not be unaware.

And what was the solution?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who helped.

Thank you.

Now, please mark the thread as solved, as requested.

Thank you.