Another play using autofilter on a helper col

In G2:
=IF(COUNTA(D2:F2)<3,"",IF(SUMPRODUCT((D$2:D2=D2)*( E$2:E2=E2)*(F$2:F2=F2))1,"","x"))
Copy G2 down to cover the max expected extent of data. Col G will flag
unique combinations with "x". Apply autofilter on col G, choose: x to filter
out the lot, on demand.

Success? Punch it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"John T Kennedy" wrote:
I have a spreadhseet (10K+ rows) that contains
Column D: First Name
Coulmn E: Last Name
Column F: Company Name

How can I setup a filter to show only each unique combination of columns D,
E &F?

Thanks in advance for sharing your expertise.