RE: Filtering unique combinations of cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Your method tells me how many times each combination appears. I must have
asked the question in the wrong way.

"Mike H" wrote:

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.

.

Relevant Pages

  • Running full legal - advice anyone?
    ... If I hear someone I want to talk to, I like to be able to grab the mike and reply. ... Through the filter the harmonics are acceptable, -70 dBc or so, but on lower bands the harmonics go straight through the filter and are likely to QRM the band above the one you're using. ... This could be a niche market for a G or EI manufacturer. ... As you can see at HF I have an all-black-box idiot-proof setup of legoboxes bolted together. ...
    (uk.radio.amateur)
  • RE: Filtering unique combinations of cells
    ... Put this formula in g1 and drag down ... The second formula will return a 1 for unique items so filter by 1 on column ... How can I setup a filter to show only each unique combination of columns D, ...
    (microsoft.public.excel.misc)
  • RE: OWC 11.0 - Subtotals return incorrect values
    ... Drag "Product Categories" natural hierarchy into the page filter area. ... Basically the totals don't match. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.olap)
  • Re: Drag from SP2 window to desktop?
    ... > display the same help text as originally displayed by the javascript ... Embedded within the HTML will be lines like this: ... > The idea is that if the user wants to perform a "filter" operation on one ... they can drag and drop the filter icon (which is surrounded ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Filtering AFN mk3 [Xnews]
    ... I'd like to use what Mike Dee has posted or to use a rewritten ... Could you post a suggested block of filter statements in the way Mike ... score file. ...
    (news.software.readers)