Kamal Subhani
Board Regular
- Joined
- Jan 26, 2004
- Messages
- 146
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Product | Quality1 | Quality3 | Quality4 | ||
2 | A | 10 | 10 | 10 | ||
3 | B | 20 | 20 | 10 | ||
4 | F | 30 | 10 | 10 | ||
5 | E | 10 | 20 | 30 | ||
Sheet1 |
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Product | Quality3 | Quality2 | Quality5 | ||
2 | C | 10 | 10 | 10 | ||
3 | D | 20 | 20 | 10 | ||
4 | A | 30 | 10 | 10 | ||
Sheet10 |
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Product | Quality1 | Quality2 | Quality3 | Quality4 | Quality5 | ||
2 | A | 10 | 40 | 10 | 10 | 10 | ||
3 | B | 20 | 20 | 10 | 0 | 0 | ||
4 | C | 0 | 10 | 0 | 10 | 10 | ||
5 | D | 0 | 20 | 0 | 20 | 10 | ||
6 | E | 10 | 20 | 30 | 0 | 0 | ||
7 | F | 30 | 10 | 10 | 0 | 0 | ||
Main |
In actual I have more than 10 sheets.
In the main sheet the Unique Products and the Unique quality will be displayed with the help of the formula
In the main sheet the total of each product according to qualties should be dispalyed
Plz help.
I think u undertand my problem.