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

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