Counting unique values

hi, the pivot table will be the best way to solve your problem

hth
regards from Brazil
Marcelo

"giantwolf" escreveu:

>
> Hi,
>
> I am trying to get a formula whereby I am looking in two columns and
> counting unique values in one column that occur when matched against a
> specified criteria from another column. ie.
>
> Me Dog
> Me Dog
> Me Cat
> You Dog
>
> Therefore in this example if I wanted to count how many unique values
> there were in column a that corresponded with the word "dog" the
> formula would return 2 (counting once for the two occurences of "me
> dog" and once for the "you dog".
>
> Many thanks in advance,
>
> GW
>
>
> --
> giantwolf
> ------------------------------------------------------------------------
> giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
> View this thread: http://www.excelforum.com/showthread...hreadid=567923
>
>

hi, the pivot table will be the best way to solve your problem

hth
regards from Brazil
Marcelo

"giantwolf" escreveu:

>
> Hi,
>
> I am trying to get a formula whereby I am looking in two columns and
> counting unique values in one column that occur when matched against a
> specified criteria from another column. ie.
>
> Me Dog
> Me Dog
> Me Cat
> You Dog
>
> Therefore in this example if I wanted to count how many unique values
> there were in column a that corresponded with the word "dog" the
> formula would return 2 (counting once for the two occurences of "me
> dog" and once for the "you dog".
>
> Many thanks in advance,
>
> GW
>
>
> --
> giantwolf
> ------------------------------------------------------------------------
> giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
> View this thread: http://www.excelforum.com/showthread...hreadid=567923
>
>

Thanks, I was thinking about a pivot table but I was hoping to have a formula which is already in a table and automatically updates when new data is pasted into a different sheet.