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