Counting with numerous citeria..complicated

[GregA]

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:

From B3:B200 a list of brands

From column F3 to to Z3 I have a list of shops and then their

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.

 

[Bob Phillips]

Do you mean something like

=IF(SUMPRODUCT(($B$3:$B$200=$B3)*($F$3:$Z$200))=1,"Only one","More than
one")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[dbahooker]

you and your stupid fucking un-readable functions

grow some balls pussy

you can use subqueries in SQL -- keep your data in a database

Excel is for babies.

-Aaron
ADP Nationalist