G
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:
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 could be the same as B114, but they could have sales
values in different shop cells, eg. H52 and X114. Thus, I would want
this to tell me that this is false. However, if it were to say that B52
and B114 (which are the same) are selling in H52 and H114 respectively,
then it would return a 1 value.
Thus, what I should have is, in say column AX (AX3:AX200) either a 1 or
a False value.
I am stuck because there could be one brand, there could be two, 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.
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 F2 to to Z2 I have a list of shop names 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 could be the same as B114, but they could have sales
values in different shop cells, eg. H52 and X114. Thus, I would want
this to tell me that this is false. However, if it were to say that B52
and B114 (which are the same) are selling in H52 and H114 respectively,
then it would return a 1 value.
Thus, what I should have is, in say column AX (AX3:AX200) either a 1 or
a False value.
I am stuck because there could be one brand, there could be two, 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.