can advanced filter in excel filters case sensitive records

  • Thread starter Thread starter priya
  • Start date Start date
In the criteria area, leave the heading cell blank
In the cell below, enter a formula that refers to the first row of data.
For example:

=EXACT(D2,"b")
 
Back
Top