Hi Roger
Thank you for this but what I get is partially not what I want.
Here is what I do : each name has a defined weight individually. Accor, Air liquide, etc.. I do a sumif(range;Sector,range) tha gves me the total weight of the sector in front of each.
When I do your formula, (yellow column), or whan i do a "LARGE" function, it gives me 3 times the 15.36% (as it appears 3 times), then 2 times 13.83..; etc
What I would do is something that returns one time the 1st biggest value (whatever the number of times it appears) , then, the second, ..
Is there a way to do, in an other column a IF function like IF(this value is already in the list ; TRUE 0 ; FALSE this value) ?
Many thanks anyway for looking at this !
Here is what I have
|
Basket Weight |
icb_sector_name |
Total Sector Weight |
Major Sectors |
| ACCOR SA |
1,48% |
Travel & Leisure |
1,48% |
15,36% |
| AIR LIQUIDE SA |
1,25% |
Chemicals |
1,25% |
15,36% |
| ALCATEL-LUCENT |
0,32% |
Technology Hardware & Equipmen |
0,55% |
13,83% |
| ALSTOM |
1,63% |
Industrial Engineering |
4,45% |
13,83% |
| ARCELORMITTAL |
1,41% |
Industrial Metals & Mining |
1,41% |
9,19% |
| AXA SA |
0,74% |
Nonlife Insurance |
0,74% |
7,57% |
| BNP PARIBAS |
3,97% |
Banks |
7,57% |
7,57% |
| BOUYGUES SA |
11,34% |
Construction & Materials |
15,36% |
7,57% |
| CAP GEMINI |
1,37% |
Software & Computer Services |
1,37% |
7,57% |
| CARREFOUR SA |
4,82% |
Food & Drug Retailers |
4,82% |
7,37% |
| CREDIT AGRICOLE SA |
2,08% |
Banks |
7,57% |
4,82% |
| DANONE |
7,37% |
Food Producers |
7,37% |
4,62% |
| DEXIA SA |
0,06% |
Banks |
7,57% |
4,45% |