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 DataFilterAdvanced 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

Big Tony wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html