Ideally, I need to sort the data in TABLE A to 30 tables similar to TABLE B
TABLE B is for a sole Category eg Skin, Hair. Row 17 will indicate the price point (Numbers in columns B,D etc of TABLE A ) from TABLE B (B4), Row 18 the price point for Brand B (B5). The indication could be a 1 present. Row 19 will indicate if there are competitors (excluding those which do not begin with "Team" ) present in any of the other price points, so will look at rows 6-11 and indicate in columns C to G of TABLE B if there is a competitor present (it is not necessary to count the number of competitors, although this is useful).
Row 20 will indicate the level of DoB or 3rd Tier depending on the Category.
I need to produce a table for each team, and each category.
Any ideas?
Thank you in advance for your help
Berney
TABLE B is for a sole Category eg Skin, Hair. Row 17 will indicate the price point (Numbers in columns B,D etc of TABLE A ) from TABLE B (B4), Row 18 the price point for Brand B (B5). The indication could be a 1 present. Row 19 will indicate if there are competitors (excluding those which do not begin with "Team" ) present in any of the other price points, so will look at rows 6-11 and indicate in columns C to G of TABLE B if there is a competitor present (it is not necessary to count the number of competitors, although this is useful).
Row 20 will indicate the level of DoB or 3rd Tier depending on the Category.
I need to produce a table for each team, and each category.
Any ideas?
Thank you in advance for your help
Berney
Fact Base v20.xls | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | TABLEA | |||||||||||||||
2 | PricePoints | 1verylow5veryhigh | ||||||||||||||
3 | Skin | Hair | Oral | Spread | Dressings | IceCream | ||||||||||
4 | Team1(A) | 5 | Team1(A) | 5 | Team1 | 5 | Team1(D) | 5 | Team1(D) | 5 | Team1(G) | 3 | 0 | |||
5 | Team1(B) | 1 | Team1(C) | Team2 | 4 | Team1(E) | 4 | Team1(F) | 4 | Team2(G) | 4 | 0 | ||||
6 | Team2(A) | 3 | Team2(A) | 5 | Team3 | 3 | Team2(D) | 3 | Team2(D) | 3 | Team3(G) | 3 | 0 | |||
7 | Team2(B) | 2 | Team2(C) | 1 | Team4 | 2 | Team3(D) | 2 | Team3(F) | 2 | Team4(G) | 4 | 0 | |||
8 | Team3(A) | 5 | Team3(A) | 4 | Team5 | 1 | Team3(E) | 1 | Team4(D) | 1 | Team5(G) | 3 | 0 | |||
9 | Team3(B) | 1 | Team3(C) | 2 | DoB | 3 | Team4(D) | 5 | Team4(F) | 5 | DoB | 4 | 0 | |||
10 | Team4(A) | 2 | Team4(A) | 3 | Team5(D) | 4 | Team5(D) | 4 | ||||||||
11 | Team5(A) | 5 | Team5(A) | 3 | Team5(E) | 3 | Team5(F) | 3 | ||||||||
12 | DoB | 3 | 3rdTier | 3 | 3rdTier | 3 | DoB | 3 | ||||||||
13 | ||||||||||||||||
14 | TABLEB | |||||||||||||||
15 | PricePoint | |||||||||||||||
16 | 1 | 2 | 3 | 4 | 5 | |||||||||||
17 | Team1 | (A) | ||||||||||||||
18 | (C) | |||||||||||||||
19 | Others | |||||||||||||||
20 | DoB | |||||||||||||||
pricepointsData |