how to count unique values in excel based on criteria

Hi

I need to count the number of unique text values stored in column A based on
the contents of column B. Column B contains groups of values of different
sizes (# rows) for each group I need to count the number of unique
corresponding values stored in column A. These are all text based.

Any suggestions on how to do this?

Thanks,
Jorge

I think the CountIf function is what you're looking for.
HTH,
Gary Brown


"Jorge" wrote:

> Hi
>
> I need to count the number of unique text values stored in column A based on
> the contents of column B. Column B contains groups of values of different
> sizes (# rows) for each group I need to count the number of unique
> corresponding values stored in column A. These are all text based.
>
> Any suggestions on how to do this?
>
> Thanks,
> Jorge

With a list of unique names from Column B in another column, let's say
Column C...

D1, copied down:

=SUM(IF(FREQUENCY(IF(($A$1:$A$100<>"")*($B$1:$B$100=C1),MATCH($A$1:$A$100
,$A$1:$A$100,0)),ROW(INDIRECT("1:"&ROWS($A$1:$A$100))))>0,1,0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Is this what you're looking for?

Hope this helps!

In article <[email protected]>,
"Jorge" <[email protected]> wrote:

> Hi
>
> I need to count the number of unique text values stored in column A based on
> the contents of column B. Column B contains groups of values of different
> sizes (# rows) for each group I need to count the number of unique
> corresponding values stored in column A. These are all text based.
>
> Any suggestions on how to do this?
>
> Thanks,
> Jorge