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