Hi,

Put this formula in g1 and drag down

=D1&E1&F1

Put this formula in H1 and drag down

=COUNTIF($G$1:$G$20,G1)

The second formula will return a 1 for unique items so filter by 1 on column
G and you have a unique list.

Mike
"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.