DRExcel515
Board Regular
- Joined
- Oct 20, 2017
- Messages
- 56
In the tables below I've outlined a small sample of the data I currently have. On the first table "Raw Data" is a specific fund code with multiple month-end dates in the second column and that funds current yield for each of those month-ends in the 3rd column. Now some of the funds in this spreadsheet may have (null) values for certain month ends (which complicates this but I can't change it as it comes that way out of the database). The second table lists out a few distinct fund codes in column 1 and in column 2 I am trying to calculate the average month over month change in the current yield on the 1st table or the "Raw Data" tab. I would need to ignore the (null) values if they occur for specific fund codes on certain month-ends. Any help would be much appreciated!
First Table is on "Raw Data" Tab
<tbody>
</tbody>
Second Table is on "Sheet1"
<tbody>
</tbody>
First Table is on "Raw Data" Tab
Fund Code | Month End | Cur Yield | Month/Month | |
<tbody> </tbody> | 8/31/2017 | 3.21 | ||
<tbody> </tbody> | 9/30/2017 | 3.26 | =(3.26/3.21)-1 | |
<tbody> </tbody> | 10/31/2017 | 3.43 | =(3.43/3.26)-1 | |
<tbody> </tbody> | 11/30/2017 | (null) | Not Available | |
<tbody> </tbody> | 12/31/2017 | 3.212 | Not Available | |
<tbody> </tbody> | 1/31/2018 | 3.35 | =(3.35/3.212)-1 | |
<tbody> </tbody> | 2/28/2018 | 3.25 | =(3.25/3.35)-1 |
<tbody>
</tbody>
Second Table is on "Sheet1"
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody>
</tbody>