Find unique names and count their status

**webstmonkey** · 03-13-2013, 08:43 PM

Hi Everybody!

I am trying to find a formula that will find the unique names in one column and count their status from another.

The file I have attached gives an example.

A has names. Some names are there multiple times. B has a status of "New". Ignoring any duplicates and blank cells, I want to count how many times there is a name that has a status of "New"

Example: Marry is listed four times, each time with a "New" status. This should be counted as 1.

Example.xls

**vlady** · 03-13-2013, 09:30 PM

Welcome to the forum.
look attachment

Example.xls

**webstmonkey** · 03-13-2013, 11:46 PM

That worked beautifully! Thank you!

**alx0101** · 03-14-2013, 01:17 AM

EDIT: moving to new post as is a new (but related) problem requiring a different solution. Linking back to this post.

Hi, can this be done by:

1. WITHOUT using array formula
AND
2. ONLY using formula, no menu sort or macro options

ie. columnn A has list of numbers, some occur more than once.
output to two new columns listing each unique number and how often it occurs in first column.

This could instead be names instead of numbers.

If I use countifs or frequency i would still get duplicated counts.

MARY MARY 3
JOHN JOHN 2
JOHN JOE 1
MARY
JOE
MARY