Forum Discussion

Isra Irfan's avatar
Isra Irfan
Copper Contributor
Mar 23, 2017

Issue With Advance Filter in Excel

Hi,   I was using advance filter in Excel to select the data with multiple criteria, but i found that it works as "Begins with" not "Equal To"   Example:   If my Criteria has (1) Abacus (2) Com...
Excel Online
Formulas & Functions
dilipandey's avatar
dilipandey
Copper Contributor
Mar 24, 2017

HI Isra,

 

To filter just se, use below text in critera:-

 

="=se"

 

and advance filter option will only filter the exact text "se". 

 

 

Regards,

DILIPandey

  • Isra Irfan's avatar
    Isra Irfan
    Copper Contributor
    Mar 24, 2017

    Hi

     

    It is still  the same.

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 25, 2017

      Hi Isra,

       

      What Dilip mentioned shall work, check if you enter your criteria correctly

       

Resources