Case sensitive advanced filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to filter a list into unique entries on a case sensitive basis.
Basically, I need the filter to recognize that "David" is unique from
"DAVID". Right now the advanced unique filter returns one line not two.
 
Create a criteria area on the worksheet (cells J1:J2 in this example)
Leave the criteria heading cell blank
In the cell below (J2), enter a formula that refers to the first row of
data in the table. For example, if your names start in cell B2:

=SUMPRODUCT(--EXACT(B2,$B$1:B2))=1

Select a cell in the data table, and choose Data>Filter>Advanced Filter
Select 'Copy to another location'
For list range, select the column to be filtered.
For criteria range, select the blank heading, and the cell with the
formula: $J$1:$J$2
For Copy to, select the starting cell for the copied data.
Click OK
 
Back
Top