View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Filtering unique combinations of cells

Make sue you have headers for these columns.
From menu DataFilterAdvanced Filter
Select 'Copy to another location'
In listrange select the data range including headers.
In Copy to select a unused column say cell M1
Check Unique record only
Click OK


If this post helps click Yes
---------------
Jacob Skaria


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