Hi team, I am trying to sort by weight an equity index through sector and subsector.
Formula is ={LARGE(IF(AND($C:$C=$G3;$D:$D=$H3);$E:$E);1)} where in column C are sectors, column D subsectors, column E index weight.
It doesn't work though. Your help is very welcome. I attach spreadsheet sample.
Best,
XL
Bookmarks