Excel 2024: The Advanced Filter Treats Criteria as "Begins With"
February 17, 2025 - by Bill Jelen

Check out this simple use of Advanced Filter. You are asking for all rows with the Product of Apple to be copied to the output range.

After clicking OK, the output range includes both Apple and Applesauce.

It turns out that this is by design. Microsoft says Excel is supposed to work this way.
If you want to extract just Apple and not Applesauce, you have to set up a formula to make the criteria look like a formula:

Thanks to Derek Fraley for the heads up about this apparent bug that is not a bug.
This article is an excerpt from MrExcel 2024 Igniting Excel
Title photo by Brandon Cormier on Unsplash