Hi,
I have a combination Index and Match function which pulls in the weights of my portfolio for a given list of tickers. I have it handling the #N/A error if the portfolio does not hold a particular security by using IF(ISNA... and returning a zero instead. However, this is a problem when I use the SMALL formula on the resulting list of weights because it will include the securities with a "weighting" of zero. My formula for SMALL only ranks the securities if they are of a particular asset class: Equity, Fixed or Gold. Here is the formula:
=SMALL(INDEX(($D$222:$D$10014={"Equity","Fixed","Gold"})*$C$222:$C$10014,0),ROW(A1))
where C has the weights and D has the asset class list
Any suggestions on how to make this formula ignore cells with a zero?
Thanks,
Phillycheese
Bookmarks