Count of unique stores in a group

I have data with three columns,

Store #
Group Name
Item #

Every store # is associated to a particular Group Name, however a store # will appear more than once due to different Item # showing up. I'm trying to get the count of unique stores for each Group Name. I've attached a small sample file that hopefully gets the point across. I tried pivot tabling, but it would return the count every time a store showed up, even if it was the same one.

Anyone want any insight on this/need more explanation?

The best solution I came up with had to use two steps, but its all contained in the same chart. Look at the "Answer" tab and tell me if this would work.

Hey that's correct, however I don't even need the columns for the individual stores. I just need the count of stores for each group. Thanks for the help

Hello
If you're happy using Array formulas then the following placed in cell B2 on your Answer Sheet and copied down should work, assuming all your Shop Numbers are numeric as in your example.

=SUM(--(FREQUENCY(IF(Sheet1!$B$2:$B$31=A2,Sheet1!$A$2:$A$31),Sheet1!$A$2:$A$31)>0))

Enter with CTRL+SHIFT+ENTER

The Formulas Calculation option in your example workbook was set to Manual. For this formula to calculate automatically you'll need to change it to Automatic.

Hope this helps
DBY