Filter by using advanced criteria - Excel - Office - Microsoft

In Excel 2010, search capability has been added to the AutoFilter. ... Because the equal sign is used to indicate a formula when you type text or a value in a cell, ...

office.microsoft.com