View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
John T Kennedy[_2_] John T Kennedy[_2_] is offline
external usenet poster
 
Posts: 12
Default Filtering unique combinations of cells

This method gives me a list with Names & Companies, but doesn't filter the
rest of the list (ie: I want to be able to filter my whole database based on
the unique combinations of E, D & F).

"Jacob Skaria" wrote:

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.