So if the market for instance would be East and there would be 10 entries
for that market of which
6 are unique you want to return 6?

=SUMPRODUCT(--(A2:A400<""),--(A2:A400="East")/COUNTIF(B2:B400,B2:B400&""))

If you want to count it as 10 use


=COUNTIF(A2:A400,"East")


--


Regards,


Peo Sjoblom






"John" wrote in message
...
I have been up and down trying to find a answer but no luck.

I have a spreadsheet that contains all the employees for the company. One
column lists the branch where the employee sits, and another lists the
market
group they belong to. I need a formula that counts how many locations are
in
that market group.

Any ideas?

Using Excel 2003.