Greetings,
I have a worksheet with monthly returns for numerous mutual funds, however not all of the funds have the same start date. Example:
<tbody>
</tbody>
In a separate worksheet I need to pull in the dates and returns for a given fund, but exclude periods with NA's. I've attempted to use the INDEX function, which allows me the desired flexibility of toggling between funds:
For Funds =INDEX('Fund Returns'!$B$2:$AI$1113,A6,4)
For Dates =INDEX('Fund Returns'!$B$2:$AI$1113,A6,1)
the issue is that the above formulas are pulling in all months, even those with NA's. How can I modify my formulas to exclude months with NA's?
Thanks!!
I have a worksheet with monthly returns for numerous mutual funds, however not all of the funds have the same start date. Example:
1 | 2 | 3 | 4 |
Fund A | Fund B | Fund C | |
1/31/2000 | 2.96 | NA | NA |
2/28/2000 | 2.64 | -2.3 | NA |
3/31/2000 | .36 | -1.4 | NA |
4/30/2000 | -3.24 | -1.3 | 1.6 |
<tbody>
</tbody>
In a separate worksheet I need to pull in the dates and returns for a given fund, but exclude periods with NA's. I've attempted to use the INDEX function, which allows me the desired flexibility of toggling between funds:
For Funds =INDEX('Fund Returns'!$B$2:$AI$1113,A6,4)
For Dates =INDEX('Fund Returns'!$B$2:$AI$1113,A6,1)
the issue is that the above formulas are pulling in all months, even those with NA's. How can I modify my formulas to exclude months with NA's?
Thanks!!