can advanced filter in excel filters case sensitive records

D

Debra Dalgleish

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")
 
Top