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

**Ecervantes** · 07-18-2017, 02:10 PM

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.

**Tsjallie** · 07-18-2017, 03:35 PM

Added formulas to count the unique values with a condition next to yours.

**Ecervantes** · 07-18-2017, 07:58 PM

Thank you! I still don't get how that works but it seems to be doing what I asked for.

**BoredWorker** · 07-18-2017, 10:23 PM

wow! learn a new thing here

it count as normal, and divide with 1, the duplicate with turn to 1/2 or less. and the sum will become 1.

(ie, a,a,a,b,b,c)

countif will turn to {3,3,3,2,2,1}

divide to 1,
{1/3,1/3,1/3,1/2,1/2,1/1}
and turn to
{0.33,0.33,0.33,0.5,0.5,1}

sum the result
a = 0.33+0.33+0.33 =1
b = 0.5+0.5 =1
c = 1

**Ecervantes** · 07-18-2017, 10:42 PM

Ah, thank you. Now I understand.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count with multiple criteria but duplicates only once

[SOLVED] count with multiple criteria without duplicates based on a different column

[SOLVED] Count without duplicates based on multiple criteria from different cells

Create New Count List Excluding Duplicates

In Excel - Sum amount with multiple criteria and excluding duplicates from sum

Count first entries (ignore duplicates) against multiple criteria

[SOLVED] Count excluding Duplicates

Bookmarks

Bookmarks

Posting Permissions