Results 1 to 5 of 5

Count from a text list, excluding duplicates, with multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-18-2017
    Location
    Washington
    MS-Off Ver
    2013
    Posts
    3

    Count from a text list, excluding duplicates, with multiple criteria

    Hello,

    I know this has been asked a lot, but I'm not finding anything that seems to work in my case.

    In the attached example, I am trying to count the total number of unique tools. I would only like to count the rows where columns A and B match. Then for the unique tools only, I want to count the totals of each status from column C. I want to do this with a formula because this is a shared workbook and I can't use tables. Right now I have the total counts in the table on the right, but it is not excluding duplicates. If someone could help it would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count with multiple criteria but duplicates only once
    By arodasr in forum Excel General
    Replies: 17
    Last Post: 07-20-2015, 03:34 AM
  2. [SOLVED] count with multiple criteria without duplicates based on a different column
    By antagonanin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2013, 09:46 AM
  3. [SOLVED] Count without duplicates based on multiple criteria from different cells
    By perryadam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2013, 12:54 PM
  4. Create New Count List Excluding Duplicates
    By Scudder93 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2012, 10:33 AM
  5. Replies: 2
    Last Post: 12-02-2011, 03:42 PM
  6. Count first entries (ignore duplicates) against multiple criteria
    By Bazza in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2008, 11:44 AM
  7. Count excluding Duplicates
    By GRM via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-15-2005, 05:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1