Hi,

I have a complicated question for help. I hope that I make it sound ok.

First thing to remember is that this sheet is linked to another, which
is in-turn link to another...ive been filtering data!

so what i have is:

respective sales in F3:Z200

What I want is for it to idenitfy where there are only sales in one
store (so where there are it will say one)...that is easy I can do
that! but the next bit is where I am stuck.

The brands can be the same, so there could be more than 1 brand
matching in column B (B3:B200), and there could be sales in different
shops, e.g. B52 = x3 and b114 = x4, however they are selling (have
values in cells) H52 and X52 respectively. Thus I want this to tell me
that it is FALSE or somethng other than 1.

Thus, what I should have is, in say column AX (AX3:AX200) either a 1 or
a False.

I am stuck because there could be one brand, there could be, or three,
or even up 10 of the same brand, but they might be selling in different
shops, i want to identify which are only selling in one.

If there is anyone out there, that understood that! lol, please please
I would really appreciate your help!

Greg.