Complex Average growth formula

[DRExcel515]

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 [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Fund Code[/TD]
[TD]Month End[/TD]
[TD]Cur Yield[/TD]
[TD]Month/Month[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]8/31/2017[/TD]
[TD]3.21[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]9/30/2017[/TD]
[TD]3.26[/TD]
[TD]=(3.26/3.21)-1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]10/31/2017[/TD]
[TD]3.43[/TD]
[TD]=(3.43/3.26)-1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]11/30/2017[/TD]
[TD](null)[/TD]
[TD]Not Available[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]12/31/2017[/TD]
[TD]3.212[/TD]
[TD]Not Available[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1/31/2018[/TD]
[TD]3.35[/TD]
[TD]=(3.35/3.212)-1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2/28/2018[/TD]
[TD]3.25[/TD]
[TD]=(3.25/3.35)-1[/TD]
[/TR]
</tbody>[/TABLE]

Second Table is on "Sheet1"
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78"]Fund Code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 108"]
<tbody>[TR]
[TD="class: xl65, width: 108"]Average Change of the Month/Month column above[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BACHU[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BBGAC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BBMUH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BC15T[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BCEAG[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78"]BCGAC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]